snippetMinor
How can I import my server list from pgAdmin 3 to pgAdmin 4?
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.
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.