From g.bottini@arpa.vda.it Tue Jan 30 11:40:43 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1968B9FB3EA for ; Tue, 30 Jan 2007 07:40:43 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 54150-07 for ; Tue, 30 Jan 2007 07:40:40 -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 D079C9FA304 for ; Tue, 30 Jan 2007 07:40:39 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from relay2.partout.it (unknown [217.76.216.102]) by svr4.postgresql.org (Postfix) with ESMTP id B21205AF9B8 for ; Tue, 30 Jan 2007 11:40:38 +0000 (GMT) Received: from relay2.partout.it (unknown [127.0.0.1]) by relay2.partout.it (Symantec Mail Security) with ESMTP id 1F418C4967 for ; Tue, 30 Jan 2007 12:41:42 +0100 (CET) X-AuditID: ac186702-a2571bb000000c9a-58-45bf2ef5743e Received: from dominod02.partout.it (unknown [172.25.103.1]) by relay2.partout.it (Symantec Mail Security) with ESMTP id D95AE30406 for ; Tue, 30 Jan 2007 12:41:41 +0100 (CET) Received: from pfrbottini ([217.76.214.46]) by dominod02.partout.it (Lotus Domino Release 6.5.4) with ESMTP id 2007013012403922-762 ; Tue, 30 Jan 2007 12:40:39 +0100 From: "Bottini" To: Subject: postgres-two different version Date: Tue, 30 Jan 2007 12:46:34 +0100 Message-ID: <002101c74464$4d7eea50$ae05a8c0@arpavda.it> MIME-Version: 1.0 X-Priority: 1 (High) X-MSMail-Priority: High X-Mailer: Microsoft Office Outlook 11 Importance: High Thread-Index: AcdEZEqXiy75MIKYRtC0GqNF+H2WQw== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-MIMETrack: Itemize by SMTP Server on D02/PARTOUT(Release 6.5.4|March 27, 2005) at 30/01/2007 12.40.39, Serialize by Router on D02/PARTOUT(Release 6.5.4|March 27, 2005) at 30/01/2007 12.40.40, Serialize complete at 30/01/2007 12.40.40 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0022_01C7446C.AF435250" X-Brightmail-Tracker: AAAAAA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.435 tagged_above=0 required=5 tests=BAYES_50, HTML_MESSAGE, X_PRIORITY_HIGH X-Spam-Level: X-Archive-Number: 200701/272 X-Sequence-Number: 24428 This is a multi-part message in MIME format. ------=_NextPart_000_0022_01C7446C.AF435250 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" Hi all Probably is a stupid question, =20 But I =91m a newbie and I don=92t want to destroy my server :-) =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 If the answer is affirmative,I think that I have to change 2 things :the installation directory and the port. 1) I install postgres with the rpm command .I think that I have to use = the option =96relocate.But how? 2) In what=92s file I can change the port? =20 Thanks a lot. =20 Gian Piero Bottini __________________________=20 dott. Gian Piero Bottini=20 ARPA Valle d'Aosta=20 Loc. Grande Charri=E8re 44=20 11020 Saint Christophe - Aosta=20 Tel. 0165-278552=20 contatto skype gianpiero.bottini=20 _______________________________=20 =20 =20 ------=_NextPart_000_0022_01C7446C.AF435250 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="iso-8859-1"

Hi all

Probably is a stupid = question,

 

But I ‘m a newbie and I don’t want = to destroy my server J

 

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

 

If the answer is affirmative,I think that I = have to change 2 things :the installation directory and the = port.

1) I install postgres with the rpm command .I = think that I have to use the option –relocate.But = how?

2) In what’s file I can change the = port?

 

Thanks a lot.

 

Gian Piero = Bottini

__________________________<= /em> 
dott. Gian Piero = Bottini

ARPA Valle d'Aosta =
Loc. = Grande Charri=E8re 44
11020 Saint Christophe - = Aosta
Tel.= 0165-278552

contatto skype gianpiero.bottini 
_______________________________ =

 

 

------=_NextPart_000_0022_01C7446C.AF435250-- From uwe.seher@googlemail.com Tue Jan 30 12:22:40 2007 Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 9CAE29FB20D for ; Tue, 30 Jan 2007 08:22:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 19538-07 for ; Tue, 30 Jan 2007 08:22:28 -0400 (AST) X-Greylist: delayed 00:06:33.404682 by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id 5403B9FB1B9 for ; Tue, 30 Jan 2007 08:22:28 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so181393nfb for ; Tue, 30 Jan 2007 04:22:26 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=beta; h=received:date:to:subject:from:content-type:mime-version:references:content-transfer-encoding:message-id:in-reply-to:user-agent; b=iKCqOogtBpULh/9FGyBUuEtHNf5oiSitGTHoFzV4o7IP8kLcgAMEQJ/o4RF4vLKOkoO4M9VD8fKhUMy4G0s1JuMsfVlSIHNfri0/vMsxx2ChyH5JGQvkUI+ItbQjtmMvZrmH6wRpipelfgyR6Hj0V/KpAKoDi3AOiRUDml5p7s0= Received: by 10.49.58.13 with SMTP id l13mr630199nfk.1170159352677; Tue, 30 Jan 2007 04:15:52 -0800 (PST) Received: from vulcanus.arteng.local ( [84.163.162.244]) by mx.google.com with ESMTP id b1sm1910789nfe.2007.01.30.04.15.51; Tue, 30 Jan 2007 04:15:52 -0800 (PST) Date: Tue, 30 Jan 2007 13:15:50 +0100 To: Bottini , pgsql-admin@postgresql.org Subject: Re: postgres-two different version From: "Uwe Seher" Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8 MIME-Version: 1.0 References: <002101c74464$4d7eea50$ae05a8c0@arpavda.it> Content-Transfer-Encoding: 8bit Message-ID: In-Reply-To: <002101c74464$4d7eea50$ae05a8c0@arpavda.it> User-Agent: Opera Mail/9.10 (Win32) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=BAYES_50, SPF_PASS X-Spam-Level: X-Archive-Number: 200701/273 X-Sequence-Number: 24429 Am 30.01.2007, 12:46 Uhr, schrieb Bottini : > Hi all > > Probably is a stupid question, > > > But I ‘m a newbie and I don’t want to destroy my server :-) > > > 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 > > > If the answer is affirmative,I think that I have to change 2 things :the > installation directory and the port. > > 1) I install postgres with the rpm command .I think that I have to use > the > option –relocate.But how? > > 2) In what’s file I can change the port? > > > Thanks a lot. > > > Gian Piero Bottini > > __________________________ > dott. Gian Piero Bottini > > ARPA Valle d'Aosta > Loc. Grande Charrière 44 > 11020 Saint Christophe - Aosta > Tel. 0165-278552 > > contatto skype gianpiero.bottini > _______________________________ > > > I think it should be possible to run 2 pg-servers on the same machine. They must use different datastores and listen to different ports. You can change the port in the postgresql.conf-file in the datastore. bye Uwe Seher _____________________________________ ingenieurbüro kauppert nebeniusstr. 34 d-76137 karlsruhe fon +49 721 3548969-3 fax +49 721 3548969-5 email uwe.seher@ib-kauppert.de web www.ib-kauppert.de _____________________________________ From tgl@sss.pgh.pa.us Tue Jan 30 15:03:11 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6BC8B9FB3DA for ; Tue, 30 Jan 2007 11:03:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 89580-08 for ; Tue, 30 Jan 2007 11:03:07 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id C03859FB3D0 for ; Tue, 30 Jan 2007 11:03:07 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l0UF34H9001893; Tue, 30 Jan 2007 10:03:05 -0500 (EST) To: "Bottini" cc: pgsql-admin@postgresql.org Subject: Re: postgres-two different version In-reply-to: <002101c74464$4d7eea50$ae05a8c0@arpavda.it> References: <002101c74464$4d7eea50$ae05a8c0@arpavda.it> Comments: In-reply-to "Bottini" message dated "Tue, 30 Jan 2007 12:46:34 +0100" Date: Tue, 30 Jan 2007 10:03:04 -0500 Message-ID: <1892.1170169384@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/274 X-Sequence-Number: 24430 "Bottini" 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 From gpatnude@hotmail.com Tue Jan 30 17:19:55 2007 Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B6E3D9FA312 for ; Tue, 30 Jan 2007 13:19:55 -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 61389-03-3 for ; Tue, 30 Jan 2007 13:19:48 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 1DB929FB421 for ; Tue, 30 Jan 2007 13:15:38 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.8/8.13.8) with ESMTP id l0UHFbVh065952 for ; Tue, 30 Jan 2007 13:15:37 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.8/8.13.8/Submit) id l0UH0kOd061075 for pgsql-admin@postgresql.org; Tue, 30 Jan 2007 13:00:46 -0400 (AST) (envelope-from news) From: "codeWarrior" X-Newsgroups: pgsql.admin Subject: Re: postgres-two different version Date: Tue, 30 Jan 2007 09:04:15 -0800 Organization: iDynaTECH, Inc. Lines: 37 Message-ID: References: <002101c74464$4d7eea50$ae05a8c0@arpavda.it> <1892.1170169384@sss.pgh.pa.us> Reply-To: "codeWarrior" X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/275 X-Sequence-Number: 24431 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" wrote in message news:1892.1170169384@sss.pgh.pa.us... > "Bottini" 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 > From nwalke@eldocomp.com Tue Jan 30 19:52:42 2007 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--