| 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
| 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 |