As others have already said, use the newer
version of pg_dump and it should go ok.
I had lots of problems restoring 7.1 dumps
into 7.4 database, but it goes smoothly if I use the 7.4 version of
pg_dump.
Assuming you have 2 servers, the old one
and a new one, call pg_dump from your new se
Hi Sarlav,
From what I understand, I need to execute the pg_dump command from the
new server( so that it will use the 7.4.6 version), but connect to the
old DB. Am I right?
Basically.
The truth is Sarlav, that any pg_dump version before the new 8.0 version
is likely to have errors restoring. Y
Hi,
I think I miscommunicated something. I am doing a pg_dump from Postgres 7.3.2. I am restoring it on Postgres 7.4.6 on Fedora Core 3 on a different server.
I tried doing the dump and restoring it on the new DB. I did not have any problem with the UNIQUE contraint so far. But I got an error
Hi,
From what I understand, I need to execute the pg_dump command from the new server( so that it will use the 7.4.6 version), but connect to the old DB. Am I right?
Thanks,
SaranyaBruno Wolff III <[EMAIL PROTECTED]> wrote:
On Mon, Dec 20, 2004 at 06:40:34 -0800,sarlav kumar <[EMAIL PROTECTED]>
sarlav kumar wrote, On 2004-12-20 15:40:
> I would like to do a pg_dump on the test database, and restore it in
> the new database on Postgres 7.4.6. I would like to know if there
> would be any problem due to the postgres version/OS change. If so,
> could someone tell me what precautions I can tak
On Mon, Dec 20, 2004 at 06:40:34 -0800,
sarlav kumar <[EMAIL PROTECTED]> wrote:
>
> I would like to do a pg_dump on the test database, and restore it in the new
> database on Postgres 7.4.6. I would like to know if there would be any
> problem due to the postgres version/OS change. If so, cou
