Re: Installing different PostgreSQL versions in parallel

Hi John

On Tue, Dec 06, 2011 at 10:55:40PM -0800, John R Pierce wrote:
> afraid I don't have much int he way of suggestions for you to
> achieve that goal. I install my Solaris postgres builds into
>
> /opt/(mygroup)/pgsqlXX/
>
> and their lib and bins and everything are in that path, then when I
> launch them, I expressly put the data somewhere like
> /u02/pgsqlXX/data

Thanks a lot for your time and effort.

One solution for my problem would be adjusting the SONAME of the libraries. At
least for 8.X libraries, it is set to 'lib<name>.so.M'. I could adjust the
SONAME to include the minor version as well, like 'lib<name>.so.M.N', which
would allow me to have libraries of different pgsql versions in /opt/csw/lib
and make sure the binaries load the libraries matching their version.

However, there is a concern in the OpenCSW community against this approach.
Therefore, I would like to know what pgsql thinks about mixing binaries and
libraries of different pgsql versions. Maybe a developer could shed some light
on this issue?

Regards
Rafael