Re: [PERFORM] Postgres version change - pg_dump

2004-12-20 Thread Iain
riginal Message - From: sarlav kumar To: pgsqlnovice ; pgsqlperform Sent: Monday, December 20, 2004 11:40 PM Subject: [PERFORM] Postgres version change - pg_dump Hi All,   Thanks to everyone for helping with my previous questions.   I have a test data

Re: [PERFORM] Postgres version change - pg_dump

2004-12-20 Thread Christopher Kings-Lynne
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

Re: [PERFORM] Postgres version change - pg_dump

2004-12-20 Thread sarlav kumar
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

Re: [PERFORM] Postgres version change - pg_dump

2004-12-20 Thread sarlav kumar
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]>

Re: [PERFORM] Postgres version change - pg_dump

2004-12-20 Thread Stefan Weiss
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

Re: [PERFORM] Postgres version change - pg_dump

2004-12-20 Thread Bruno Wolff III
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

[PERFORM] Postgres version change - pg_dump

2004-12-20 Thread sarlav kumar
Hi All,   Thanks to everyone for helping with my previous questions.   I have a test database running on Postgres 7.3.2.    version   - PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96 I have another ser