Re: Where is a pgAdmin III server list stored?

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Ken Winter <ken(at)sunward(dot)org>
Cc: pgAdmin List <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Where is a pgAdmin III server list stored?
Date: 2015-09-23 08:47:01
Message-ID: CA+OCxowMDRwrBky3pkdC_H1JLb0ogrGDWtugnmMs7vsO5LdLWw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi

On Tue, Sep 22, 2015 at 9:30 PM, Ken Winter <ken(at)sunward(dot)org> wrote:
> I need to migrate my pgAdmin to a new (Windows 7) computer. My pgAdmin
> setup on my old (also Win 7) computer includes a couple dozen servers. I'm
> hoping that I can somehow copy these to the new computer so I don't have to
> re-enter them manually.
>
> Is the server list in a file somewhere, and if so how do I find it? Or if
> it is somehow stored "inside" of pgAdmin, is there a way to export it from
> the old computer and import it into the new one?

The settings are stored in the Windows Registry. If you fire up
regedit, you should be able to export all the settings under:

HKEY_CURRENT_USER\Software\pgAdmin III

to a text file, then re-import them on the new machine. If you only
want the servers, the key is:

HKEY_CURRENT_USER\Software\pgAdmin III\Servers

The usual caveats and disclaimers about poking around in the registry
apply - be careful and do so at your own risk.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Michal Kozusznik 2015-09-25 11:56:58 Re: Where is a pgAdmin III server list stored?
Previous Message Vahdet Mert 2015-09-23 03:31:43 Re: How to enable PgAdmin Query Tool Favorites