From: Chris Browne <cbbrowne@acm.org>
To: pgsql-admin@postgresql.org
Subject: Re: 2 PGSQL instances in the same server
Date: Thu, 04 Nov 2010 12:38:03 -0400
Message-ID: <87lj59rqms.fsf@cbbrowne.afilias-int.info> (raw)
References: <AANLkTik5huKGe7MK0UeEM4R=9dhF+84wDF8x=CWb-CU8@mail.gmail.com>
rbarreca@gmail.com (Ramiro Barreca) writes:
> We need to have, for migration, either an instance of our actual PG 8.4.4 and a
> new one of PG 9.0 for testing.
> Where can we found a paper for helping us?
> Our platform is Centos 5.4 x86 64 bits
The "complication" to this is that it is quite likely not simple to do
this using pre-packaged (e.g. - RPM files) Postgres builds.
Anyone that's involved with building Postgres tends to have tooling
handy to help have multiple versions of Postgres around.
I have a script I use for this sort of thing:
<https://github.com/cbbrowne/pginit;
Greg Smith has something analagous, though more sophisticated:
<https://github.com/gregs1104/peg;
It amounts to:
1. Installing both versions of software;
2. Possibly using scripts to help manage where the results get
installed.
If you're accustomed to entrusting installation totally to RPM-based
installations of Postgres, you're headed into new territory to have to
choose and configure where the installations are done. But it's really
no big deal - it's not unusual for me to install several different
instances of Postgres in the course of an hour, refreshing some
instances I use to test Slony-I.
--
output = ("cbbrowne" "@" "linuxfinances.info")
"In the free software world, a rising tide DOES lift all boats, and
once the user has tasted Unix it's easy for them to switch between
Unices." -- david parsons
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: 2 PGSQL instances in the same server
In-Reply-To: <87lj59rqms.fsf@cbbrowne.afilias-int.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox