From: | Vincenzo Romano <vincenzo(dot)romano(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Running v8.1 amd v8.2 at the same time for a transition |
Date: | 2007-06-06 07:00:14 |
Message-ID: | 200706060900.14663.vincenzo.romano@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tuesday 05 June 2007 23:55:20 Oliver Elphick wrote:
> On Tue, 2007-06-05 at 23:40 +0200, Vincenzo Romano wrote:
> > Hi all.
> > I need to run both 8.1 and 8.2 at the same time in order to check
> > everything in 8.2 *before* shutting 8.1 down.
> > I need to run both as I only have one machine available.
> > I'm using a debian derivateive (Kubuntu) that provides a nice pg_wrapper
> > mechanism to direct connections for tools to either version you want.
> > Infact I see both versions running, one on port 5432 and one on port
> > 5433. The point is thay I have no clue on ow to choose which instance
> > attach to. I've already posted this question to the KUbuntu team with no
> > answer in 14+ hours.
> >
> > Is there anyone with a good hint?
>
> man pg_wrapper
>
> psql --cluster 8.1/main -d your_database
Much better, as I've been told:
pg_lsclusters
will show all the active clusters.
The bad point is that there's a lack of information or, at least, of
cross references.
The "main" cluster is mentioned only in
/usr/share/doc/postgresql-<VER>/README.Debian.gz
and not in the manpages. And ther's no cross reference into the
pg_wrapper(1), user_clusters(5) or postgresqlrc(5) man pages.
But the point is that I'm a newbie so maybe it's just my fault!
--
Vincenzo Romano
--
Maybe Computer will never become as intelligent as Humans.
For sure they won't ever become so stupid. [VR-1988]
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2007-06-06 07:08:48 | Re: pl/pgsql debuging, was Re: debugging C functions |
Previous Message | Jim Nasby | 2007-06-06 04:49:31 | Re: Large Database \d: ERROR: cache lookup failed for relation ... |