Re: restore failure - Mailing list pgsql-admin

From Tom Lane
Subject Re: restore failure
Date
Msg-id 5008.1226944025@sss.pgh.pa.us
Whole thread Raw
In response to restore failure  ("Anony Mous" <fyngyrz@gmail.com>)
List pgsql-admin
"Anony Mous" <fyngyrz@gmail.com> writes:
> I have a moderate size database under RH9 / pgsql 7.3 (I think... that's the
> PG_VERSION in the postgres user data directory.) Under 100 mb for the whole
> thing.

> I'm trying to move the DB to postgresql 8.3 under the current ubuntu in a
> 4-core, 4gb machine.

Try using the 8.3 pg_dump (or more likely pg_dumpall) to dump from the
7.3 server.  (Just point it at that server over the net, you don't need
to install it on the old machine.)

            regards, tom lane

pgsql-admin by date:

Previous
From: Ben Webber
Date:
Subject: Re: Change in logging behaviour between 8.1 and 8.2
Next
From: Mischa Sandberg
Date:
Subject: Re: Reliably determining whether the server came up