Postgres 7.1.3 and pg_dump / pg_restore

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

Browse pgsql-general by date

  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