Re: transitioning postgres oid - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: transitioning postgres oid
Date
Msg-id 20020515005416.F10256@svana.org
Whole thread Raw
In response to Re: transitioning postgres oid  ("Robert Abbate" <cogea@ectisp.net>)
List pgsql-general
On Tue, May 14, 2002 at 10:15:45AM -0500, Robert Abbate wrote:
> Actually, if I was able to get the old database up, I wouldn't needed to
> re-install postgres again. That is my problem. I could not get the old
> databases up and running at all. I had to do a fresh installation. So now
> the old databases are just sitting there. Any ideas?

If you are only upgrading minor versions (say 7.2 to 7.2.1) then you can
just replace the binaries and you're set. If you're doing a major upgrade
then a pg_dump is the only way.

Just confirm you still have a pg_database file, a pg_xlog directory and a
global directory.

I beleive postgres -D /path/to/db will work.

HTH,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postmaster core dumps with SPI_repalloc
Next
From: Martín Marqués
Date:
Subject: Re: restoreing dumps fail