Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] Postgres version change - pg_dump

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: sarlav kumar <sarlavk(at)yahoo(dot)com>
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>,pgsqlnovice <pgsql-novice(at)postgresql(dot)org>,pgsqlperform <pgsql-performance(at)postgresql(dot)org>
Subject: Re: [PERFORM] Postgres version change - pg_dump
Date: 2004-12-21 05:58:14
Message-ID: 41C7BB76.9090206@familyhealth.com.au (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
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.  You should restore the dump like this:

psql -f dump.sql database

And then when you get errors, you will see the line number of the error. 
  Then you can edit the dump to fix it.

Chris

In response to

pgsql-novice by date

Next:From: IainDate: 2004-12-21 07:09:55
Subject: Re: [PERFORM] Postgres version change - pg_dump
Previous:From: Mike GDate: 2004-12-21 04:33:04
Subject: Re: CAST and timestamp

pgsql-performance by date

Next:From: IainDate: 2004-12-21 07:09:55
Subject: Re: [PERFORM] Postgres version change - pg_dump
Previous:From: Theo GalanakisDate: 2004-12-21 05:53:51
Subject: Re: PG Logging is Slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group