Re: 2 PGSQL instances in the same server

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:
    

Greg Smith has something analagous, though more sophisticated:
    

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