From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Postgres 7.1.3 and pg_dump / pg_restore |
Date: | 2002-01-28 19:30:20 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB0452DDE7@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Howdy:
We are currently running Postgres 7.1.3 on Mandrake Linux 8.0, kernel
version 2.4.16. Also, we are trying to load migrate data to RedHat Linux
7.2, kernel 2.4.7.
We are currently doing something close to this:
[snip]
pg_dump -t <table> -Fc <database> | pg_restore -v -h <new server> -d
<database> -O
[snip]
A new table gets created and it seems fine. When we try to do a pg_dump of
the entire database, the process goes along fine until it comes to a few
errors.
For example, the backend error comes up when, say, Postgres can not find
a sequence name, or, if a table is seemingly corrupt.
There has got to be a better way to dump the database from Server A to
Server B
without a lot of interruptions and errors. Has anyone else tried to dump
and
restore a database from one server to the next? Any tips are appreciated!
Thanks!
-X
From | Date | Subject | |
---|---|---|---|
Next Message | Darren Ferguson | 2002-01-28 19:32:23 | Re: Postgres 7.1.3 and new kernel |
Previous Message | Trond Eivind =?iso-8859-1?q?Glomsr=F8d?= | 2002-01-28 19:20:24 | Re: Postgres 7.1.3 and new kernel |