Re: Running v8.1 amd v8.2 at the same time for a transition - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Running v8.1 amd v8.2 at the same time for a transition
Date
Msg-id 20070606100210.GC8997@svana.org
Whole thread Raw
In response to Re: Running v8.1 amd v8.2 at the same time for a transition  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-general
On Wed, Jun 06, 2007 at 11:05:00AM +0200, Hannes Dorbath wrote:
> Isn't it funny that stupid wrapper scripts create confusion instead of
> making things easier for users.
>
> Running 2 PG instances is a trivial thing to do. It requires a quick
> look at the PostgreSQL documentation to find out that:
>
> - The port is defined in postgresql.conf
> - pg_ctl -D defines what cluster to work on
> - The switch for the port in psql is -p

That doesn't work if you want to have multiple versions of psql,
initdb, pg_dump, or pg_restore. PostgreSQL doesn't support multiple
parallel installations of different versions in a transparent way.

> But instead people spend their time on going out and ask how to use some
> poor wrappers, their distribution provides. Probably this has costed
> them more time than a look in the PG documentation.

Wrappers aren't great, but they're a necessity if you want to be able
to run multiple versions of postgres simultaneously in a reasonably
transparent way.

At least now the package management system can let you install a new
version, upgrade an old cluster to a new version and when the upgrade
is complete, uninstall the old one.

> Anyway, I guess wrappers are a must have like 3D desktops these days.

You have an better alternative for handling multiple versions?

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: "Bart Degryse"
Date:
Subject: plperl and/or insert trigger problem
Next
From: Richard Huxton
Date:
Subject: Re: plperl and/or insert trigger problem