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

Re: restore failure

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Anony Mous" <fyngyrz(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: restore failure
Date: 2008-11-17 17:47:05
Message-ID: 5008.1226944025@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Anony Mous" <fyngyrz(at)gmail(dot)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

In response to

pgsql-admin by date

Next:From: Mischa SandbergDate: 2008-11-18 05:38:44
Subject: Re: Reliably determining whether the server came up
Previous:From: Ben WebberDate: 2008-11-17 15:31:56
Subject: Re: Change in logging behaviour between 8.1 and 8.2

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