On Sat, Dec 11, 2010 at 4:52 AM, Jasen Betts <jasen@xnet.co.nz> wrote:
On 2010-12-07, Rafael Enrique Ortiz Guerrero <dirakx@gmail.com> wrote:
> I have a server executable of the postgres version that the DB was working > on, the problem is that i have two versions of postgres running in that > server, but only the latest version (8.4) seems to be getting up the DBs, > while the old version don't, I've checked and all the DBs are there in > $PGDATA, I've tried with psql and it only shows the 8.4 DBs not the 8.2 DBs. > > What can I do?
what os + distro
for debian linux you could try
psql --cluster 8.2/main -l
and/or
pg_dumpall --cluster 8.2/main
Great this is what was looking for, I'm always running Ubuntu/Debian servers so this is useful.
for more info on the debian weirdness see the documentation for the postgresql-common package and the pg_wrapper man-page