Skip site navigation (1) Skip section navigation (2)

Re: Restoring from pg_data

From: Rafael Enrique Ortiz Guerrero <rafael(at)sugarlabs(dot)org>
To: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Restoring from pg_data
Date: 2010-12-11 14:43:26
Message-ID: AANLkTinEF2kO02-XMtK1UPXwTYy8X7scQ8N_Mc0RaZ_T@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
>

In response to

pgsql-novice by date

Next:From: Machiel RichardsDate: 2010-12-13 08:54:02
Subject: pgstatspack version?
Previous:From: Jasen BettsDate: 2010-12-11 09:52:29
Subject: Re: Restoring from pg_data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group