From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | rod(at)iol(dot)ie |
Cc: | Cousin Florence <fcousin(at)sopragroup(dot)com>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgAdmin linking to the wrong pg_dump |
Date: | 2010-09-23 10:15:05 |
Message-ID: | 4C9B28A9.7@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Le 23/09/2010 12:06, Raymond O'Donnell a écrit :
> On 23/09/2010 10:52, Cousin Florence wrote:
>> I do not understand why pgAdmin searches pg_dump in this location. I
>> still have an "old" pgAdmin 1.10 installed, but it is not in the path
>> (I checked it) How can I correct it, so that pgAdmin links to the
>> pg_dump located in "C:\Program Files\pgAdmin III\1.12"?
>
> Hi there,
>
> Go to File -> Options, and on the "General" tab look for "PG bin path" -
> enter the correct path here.
>
And, actually, there are no really good answers to this question. You
need a pg_dump release that goes along with the server release you will
use to restore your dump. I mean, if you want to dump a database on a
8.3 server and restore it on a 8.4, you need either a 8.3 or a 8.4
pg_dump (preferably a 8.4 one). Not a 9.0, not a <8.3. If you dump with
pgAdmin 1.12, you will have (by default) a 9.0 dump which you may have
problems to restore on the 8.4 server.
Users have to know that pgAdmin's dump and restore facilities use
pg_dump and pg_restore of the last available PostgreSQL release by default.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Valentine Gogichashvili | 2010-09-23 10:18:08 | Connection color is not correctly changed in query windows connection drop-down. |
Previous Message | Raymond O'Donnell | 2010-09-23 10:06:52 | Re: pgAdmin linking to the wrong pg_dump |