Thread: Getting data from old data dir

Is there any way to dump the data from an old 7.2 data
dir after having updated PG to 7.3?

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

CSN <cool_screen_name90001@yahoo.com> writes:

> Is there any way to dump the data from an old 7.2 data
> dir after having updated PG to 7.3?

Yes, compile and install 7.2.3 in a different location, point it at
your $PGDATA dir, and dump the data out.

Or, if you're using RPMs, might be easiest to just do a forced
downgrade to 7.2, dump out the data and then upgrade again.

-Doug

On Fri, 6 Dec 2002, CSN wrote:

> Is there any way to dump the data from an old 7.2 data
> dir after having updated PG to 7.3?

Yes, uninstall 7.3, reinstall 7.2 and restart the db server, then pg_dump
from that, then shut down 7.2, uninstall, and install 7.3

7.3 SHOULD have refused to startup with 7.2 data under it, so your
database should still be intact just inaccessible.