Re: Ruuning two instances of Postgres on the same machine - Mailing list pgsql-general

From Tom Lane
Subject Re: Ruuning two instances of Postgres on the same machine
Date
Msg-id 18867.1248654655@sss.pgh.pa.us
Whole thread Raw
In response to Ruuning two instances of Postgres on the same machine  (Robert James <srobertjames@gmail.com>)
List pgsql-general
Robert James <srobertjames@gmail.com> writes:
> I'm currently running Postgres 8.2 on Windows XP.  I would like to use some
> 8.4 features, but I don't want to migrate my 8.2.  Is there any way to run
> both instances together? Are there any problems with that?

What you need is
    * different install directories
    * different data directories
    * different port numbers
I'm not sure how friendly the Windows installers are on the first point,
but otherwise it's not hard.  All the developers have multiple versions
running on their machines all the time, so it's plenty well-tested.

> Alternatively, is the procedure to move from 8.2 to 8.4 without data or
> function loss documented anywhere?

Dump, reload, check for incompatibilities by testing your apps and/or
reading the release notes.

            regards, tom lane

pgsql-general by date:

Previous
From: Robert James
Date:
Subject: Ruuning two instances of Postgres on the same machine
Next
From: Alvaro Herrera
Date:
Subject: Re: synchronous_commit=off doesn't always return immediately