| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Iain | 2004-12-21 07:09:55 | Re: [PERFORM] Postgres version change - pg_dump |
| Previous Message | Mike G | 2004-12-21 04:33:04 | Re: CAST and timestamp |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Iain | 2004-12-21 07:09:55 | Re: [PERFORM] Postgres version change - pg_dump |
| Previous Message | Theo Galanakis | 2004-12-21 05:53:51 | Re: PG Logging is Slow |