Re: transitioning postgres oid

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Robert Abbate <cogea(at)ectisp(dot)net>
Cc: Andrew Sullivan <andrew(at)libertyrms(dot)info>, pgsql-general(at)postgresql(dot)org
Subject: Re: transitioning postgres oid
Date: 2002-05-14 14:54:16
Message-ID: 20020515005416.F10256@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-05-14 15:04:12 Re: Using COPY
Previous Message Tom Lane 2002-05-14 14:45:21 Re: postmaster core dumps with SPI_repalloc