1

Is there an easy way to restore databases from PGadmin 3 into Pgadmin 4? Right now data on both, and I want to gather all my data on the same server. The port on PGadmin 3 is 5432 and 5433 on PGadmin 4. My PostgreSQL versions is 10.1 on pgadmin 3 and 11.3 on pgadmin 4.

Previously, with help I succeeded in doing so by using Notepad++, but I can't figure out how we did then.

closed as off-topic by DPSSpatial, Vince, whyzar, neogeomat, Taras Jul 26 at 4:23

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions relating to general IT or with no clear GIS component, are off-topic here but can be researched/asked at Stack Overflow (software development), Super User (computing hardware and software), Database Administrators (relational databases) and other SE sites" – DPSSpatial, Vince, whyzar, neogeomat, Taras
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Your apparent mix-n-match of administration tool names and database instance references is confusing (especially using pgAdmin-III to manage a 10.1 instance), but this is really in the proper domain of Database Administrators. – Vince Jul 25 at 15:27
0

I would recommend using this documentation Backup and Restore

A powerful, but user-friendly Backup and Restore tool provides an easy way to use pg_dump, pg_dumpall, and pg_restore to take backups and create copies of databases or database objects for use in a development environment.

Using the pg_dump utility, pgAdmin provides an easy way to create a backup in a plain-text or archived format. You can then use a client application (like psql or the Query Tool) to restore a plain-text backup file, or use the Postgres pg_restore utility to restore an archived backup. The pg_dump utility must have read access to all database objects that you want to back up.

enter image description here

The Restore dialog provides an easy way to use a Custom, tar, or Directory format backup taken with the pgAdmin Backup dialog to recreate a database or database object. The Backup dialog invokes options of the pg_dump client utility; the Restore dialog invokes options of the pg_restore client utility.

enter image description here

  • I have tried this more than once. I think the problem for me is how I change the port from 5432 to 5433? – DyndeMachine Jul 28 at 15:01

Not the answer you're looking for? Browse other questions tagged or ask your own question.