Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5C9059FB35C for ; Tue, 30 Jan 2007 15:52:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 56043-02 for ; Tue, 30 Jan 2007 15:52:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E69F79F9C1D for ; Tue, 30 Jan 2007 15:52:33 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from eciweb.eldocomp.com (eciweb.eldocomp.com [205.159.99.39]) by svr4.postgresql.org (Postfix) with ESMTP id 1EA995AF898 for ; Tue, 30 Jan 2007 19:52:32 +0000 (GMT) Received: from ecimail.eldocomp.com [172.20.128.2] by eciweb.eldocomp.com with XWall v3.38 ; Tue, 30 Jan 2007 12:52:19 -0700 Received: from ecimail.eldocomp.com ([172.20.128.2]) by ecimail.eldocomp.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 30 Jan 2007 12:52:19 -0700 Received: from [172.20.131.10] ([172.20.131.10]) by ecimail.eldocomp.com with Microsoft SMTPSVC(6.0.3790.1830); Tue, 30 Jan 2007 12:52:18 -0700 References: <002101c74464$4d7eea50$ae05a8c0@arpavda.it> <1892.1170169384@sss.pgh.pa.us> In-Reply-To: From: Naomi Walker To: codeWarrior Cc: "pgsql-admin@postgresql.org" Subject: Re: postgres-two different version Date: Tue, 30 Jan 2007 12:52:18 -0700 X-Assembled-By: XWall v3.38 Message-ID: <45BFA1F2.5050301@eldocomp.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/279 X-Sequence-Number: 24435 This is a multi part MIME message. --_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 call= ed=20 > "schemas" within one database... and postgreSQL is very capable of managin= g=20 > multiple databases from the same server.... > > If you insist on trying to run two postgreSQL server on teh same box -- Yo= u=20 > also need to make sure that your two different versions dopnt share TCP/IP= =20 > ports -- they cannot both listen on the same IP:PORT address -- so you wil= l=20 > need to manage your postgresql.conf and pg_hba.conf files separately -- on= e=20 > for each postgresql server... ditto for your startup scripts. > > You will probably also have some issues when using pgsql at the command li= ne=20 > [localhost]. > > Why not just upgrade your 8.1.3 installation to 8.2 ? > > > > > "Tom Lane" wrote in message=20 > news:1892.1170169384@sss.pgh.pa.us... > =20 >> "Bottini" writes: >> =20 >>> 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 >>> =20 >> 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 >> >> =20 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings > =20 --=20 ----------------------------------------------------------------------------= =20 Naomi Walker Chief Information Officer=20 Mphasis Healthcare Solutions nwalker@mhs.mphasis.com=20 =20 ---An EDS Company 602-604-3100=20 ----------------------------------------------------------------------------= =20 A positive attitude may not solve all your problems, but it will annoy=20 enough people to make it worth the effort. --Herm Albright (1876 - 1944) ---------------------------------------------------------------------------- -- CONFIDENTIALITY NOTICE -- Information transmitted by this=C2=A0e-mail is proprietary to MphasiS and/or= its Customers and is intended for use only by the individual or entity to w= hich it is addressed, and may contain information that is=C2=A0privileged, c= onfidential or exempt from disclosure under applicable law. If you are not t= he intended recipient or it appears that this e-mail has been forwarded to y= ou without proper authority, you are notified that any use or dissemination = of this information in any manner is strictly prohibited. In such cases, ple= ase notify us immediately at mailmaster@mphasis.com and delete this mail fro= m your records. --_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable =20 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:
=20
Why would you want two servers on the same box ??? There'=
s this thing called=20
"schemas" within one database... and postgreSQL is very capable of managing=20
multiple databases from the same server....

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

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

Why not just upgrade your 8.1.3 installation to 8.2 ?




"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message=20
news:1892.1170169384@sss.pgh.pa.us...
=20 
=20
=20
"Bottini" <g.bottini@arpa.vda.it> writes:
=20   
=20
=20
Is possible  to install two different version of post=
gresql on the same
Linux server? I want to install  the 8.2 version in a server where is
installed 8.1.3 version
=20     
=20
=20
You can, but not when installing from RPM: the RPMs hav=
e 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

=20   
=20
=20



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


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

-- CONFIDENTIALITY NOTICE --

Info= rmation transmitted by this=A0e-mail is proprietary to MphasiS and/ or its Customers and is inte= nded for use only by the individual or entity to which it is addressed, and may contain inform= ation that is privileged, confidential or exempt from disclosure under applicable law. If = you are not the intended recipient or it appears that this mail has been forwarded to you wi= thout proper authority, you are notified that any use or dissemination of this informatio= n in any manner is strictly prohibited. In such cases, please notify us immediately at mailm= aster@mphasis.com and delete this e-mail from your records.

 

--_NextPart_1_qmZrHLajoetbkwlTZTViemHPfyb--