Re: postgres-two different version

We run two servers when we are trying out new versions (development, qa, and production).  And,
its a failsafe for upgrades.  Since you need to unload for major upgrades anyway, it is completely
reasonable.

Naomi

codeWarrior wrote:

Why would you want two servers on the same box ??? There's this thing called 
"schemas" within one database... and postgreSQL is very capable of managing 
multiple databases from the same server....

If you insist on trying to run two postgreSQL server on teh same box -- You 
also need to make sure that your two different versions dopnt share TCP/IP 
ports -- they cannot both listen on the same IP:PORT address -- so you will 
need to manage your postgresql.conf and pg_hba.conf files separately -- one 
for each postgresql server... ditto for your startup scripts.

You will probably also have some issues when using pgsql at the command line 
[localhost].

Why not just upgrade your 8.1.3 installation to 8.2 ?




"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message 
news:1892.1170169384@sss.pgh.pa.us... 

"Bottini" <g.bottini@arpa.vda.it> writes:   

Is possible  to install two different version of postgresql on the same
Linux server? I want to install  the 8.2 version in a server where is
installed 8.1.3 version     

You can, but not when installing from RPM: the RPMs have a fixed idea of
where to put the software, and I don't think it's feasible to change.
You'd need to build from source and use the --prefix configure option
to put the two sets of code in different places.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
   

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings 

-- 
---------------------------------------------------------------------------- 
Naomi Walker                          Chief Information Officer 
Mphasis Healthcare Solutions          nwalker@mhs.mphasis.com  ---An EDS Company                   602-604-3100 
---------------------------------------------------------------------------- 
A positive attitude may not solve all your problems, but it will annoy 
enough people to make it worth the effort. --Herm Albright (1876 - 1944)
----------------------------------------------------------------------------