Re: Ruuning two instances of Postgres on the same machine

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert James <srobertjames(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Ruuning two instances of Postgres on the same machine
Date: 2009-07-27 00:30:55
Message-ID: 18867.1248654655@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Robert James <srobertjames(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-07-27 01:56:31 Re: synchronous_commit=off doesn't always return immediately
Previous Message Robert James 2009-07-26 23:46:24 Ruuning two instances of Postgres on the same machine