Re: Running 2 versions of postgres on the same server at the same time ??? - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Running 2 versions of postgres on the same server at the same time ???
Date
Msg-id dcc563d10809301929v410fd9d2nfb8a6cbf7642ed64@mail.gmail.com
Whole thread Raw
In response to Running 2 versions of postgres on the same server at the same time ???  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: Running 2 versions of postgres on the same server at the same time ???  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Sep 30, 2008 at 8:21 PM, Gauthier, Dave <dave.gauthier@intel.com> wrote:
> Hi:
>
> I have v8.2.5 running on my server and serving my DB to my customers.  I
> also have v8.3.4.  I created a v8.3.4 instance (initdb) but haven't started
> anything yet (no pg_ctl start yet).  I want to test v8.3.4 on the server
> while keeping v8.2.5 running and serving my customers at the same time.  Wil
> lthere be any problems if I start v8.3.4 while v8.2.5 is running?

I've got 8.1, 8.2 and 8.3 running on my laptop all at the same time.
If you're running debian it's super simple, the setup is fully
automagic.  Since you've already got it initdbed, all you need to do
is make sure it's set to come up on a different port and you're set.
Since the space around 5432 is pretty empty for reserved services,
it's typical to just use the next port and so on.  5433, 5434, 5435
and so on.

Also, you might have to increase your shm settings in your kernel to
provide enough shared memory for both instances.

It's actually a pretty common practice to install two versions for
migration purposes.

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Running 2 versions of postgres on the same server at the same time ???
Next
From: Lennin Caro
Date:
Subject: Re: Counting unique rows as an aggregate.