[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 server where a newer version of

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, could

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 take

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

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.