25

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

16

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

HKEY_CURRENT_USER\Software\pgAdmin III

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

  • I'm on OSX 10.9 and I don't see this file nor any hidden file with pg in it that contains the information I'm looking for. I do see a query history and password file but not the Server List – Phill Pafford Nov 20 '13 at 16:59
  • 1
    On openSUSE 13.1, the server list is, among other settings, in the file .pgadmin3 in the home directory. – Jaan Mar 16 '14 at 18:16
  • @Jaan: why don't you add that as an answer? – a_horse_with_no_name Mar 16 '14 at 18:56
  • In Windows 7 pgadminIII 1.16 was such a key, but I didn't find the server configs there. Did I miss something? – jan Jan 8 '15 at 15:03
10

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.

10

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

%your-user-home%\AppData\Roaming\pgAdmin\pgadmin4.db

  • This is now the current correct answer for Windows – dangel Oct 18 at 0:52
6

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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