TransWikia.com

save/export PGAdmin server list configuration settings

Database Administrators Asked by Phill Pafford on November 5, 2021

I have a ton of configured connections listed in the Server Groups, is there a way I can save this? not just save the passwords but the Server Group Settings

enter image description here

5 Answers

I've the same issue and solve it in this way, using this doc

  1. Export

    /path/to/python /path/to/setup.py --dump-servers /path/to/pg4_cnx.json
    

Output message : Configuration for x servers dumped to /path/to/pg4_cnx.json.

  1. Import

    /path/to/python /path/to/setup.py --load-servers /path/to/pg4_cnx.json
    

Output message : Added n Server Group(s) and x Server(s).

Under Windows (7|10), you can find "python.exe" & "setup.py" in this sub-dirs of your PgAdmin4 install : pgAdmin 4venvScriptspython.exe pgAdmin 4websetup.py

Hope this help you

Answered by P. Qualis on November 5, 2021

Under Windows, pgAdmin4 stores the server list in the users directory in a SQLLite 3 format. Here:

%your-user-home%AppDataRoamingpgAdminpgadmin4.db

Answered by Alex K. on November 5, 2021

I ran into a similar issue where I was on OSX and now have a windows computer. I don't want to have to re-enter all of the connection entries. I found out that on OSX the PGADMIN III servers list is located in your home user directory inside the file "pgadmin3 Preferences":

vim ~/Library/Preferences/pgadmin3 Preferences

Now it doesn't seem like there is an easy way to import this into a non-OSX version, however at least I should be able to copy/paste most of it into the new PGADMIN III application.

Answered by T.J. on November 5, 2021

In Ubuntu 13.10 pgAdmin stores configuration in user's home directory:

/home/<<username>>/.pgadmin3
or shorter
~/.pgadmin3

Note that this file is hidden, so you may need to enable some kind of "Show hidden files" option in your file manager.

Answered by Tomas Greif on November 5, 2021

Under Windows this information is stored in the Registry under the key:

HKEY_CURRENT_USERSoftwarepgAdmin III

In Linux systems I would expect some file in the user home directory.

Answered by a_horse_with_no_name on November 5, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP