Re: Restoring from pg_data

Hi Jasen

On Sat, Dec 11, 2010 at 4:52 AM, Jasen Betts <jasen(at)xnet(dot)co(dot)nz> wrote:

> On 2010-12-07, Rafael Enrique Ortiz Guerrero <dirakx(at)gmail(dot)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
>
>
Thanks!

> --
> ⚂⚃ 100% natural
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>