Re: Help! Upgrade to 8.4 dropped my databases

Andrew Perrin wrote:

> 1.) Is there a way to "reconnect" the 8.3 server, after reinstalling
> it, to the raw files, so that the databases are there? I will then
> do a pg_upgradecluster and be happy; or, alternatively,

If you're in a hurry, just install 8.3 from source and run postmaster -D
/path/to/data/files (be sure to choose a nonconflicting port). Then you
can connect to it with pg_dump and get the data out and into the 8.4
installation.

Oh, make sure you keep an eye out for the socket directory too ...
default PG places sockets in /tmp whereas Debian places them in
/var/run/postgresql. Just in case.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support