HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How can I import my server list from pgAdmin 3 to pgAdmin 4?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
pgadmincanhowserverlistfromimport

Problem

I wonder whether there is any way to import my server list from pgAdmin 3 to pgAdmin 4 (so that I don't have to create servers one by one again).

Solution

For Windows in C:\Users\%user%\AppData\Roaming\pgAdmin you can find pgadmin4.db which is where pgAdmin4 saves its configuration. It is SQLite format 3 and with SQLite browser you can open it and insert servers into server table and then save and they are added to pgAdmin4. Note that passwords are saved encrypted so leave NULL to input them later.
Now you could make sql script that reads registry export from pgAdmin III and inserts into table for fully automated process.

Context

StackExchange Database Administrators Q#143347, answer score: 4

Revisions (0)

No revisions yet.