pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
postgres-two different version
5+ messages / 5 participants
[nested] [flat]

* postgres-two different version
@ 2007-01-30 11:46 Bottini <g.bottini@arpa.vda.it>
  2007-01-30 12:15 ` Re: postgres-two different version Uwe Seher <uwe.seher@googlemail.com>
  2007-01-30 15:03 ` Re: postgres-two different version Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 5+ messages in thread

From: Bottini @ 2007-01-30 11:46 UTC (permalink / raw)
  To: pgsql-admin

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 
_______________________________ 

 

 

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: postgres-two different version
  2007-01-30 11:46 postgres-two different version Bottini <g.bottini@arpa.vda.it>
@ 2007-01-30 12:15 ` Uwe Seher <uwe.seher@googlemail.com>
  1 sibling, 0 replies; 5+ messages in thread

From: Uwe Seher @ 2007-01-30 12:15 UTC (permalink / raw)
  To: Bottini <g.bottini@arpa.vda.it>; pgsql-admin

Am 30.01.2007, 12:46 Uhr, schrieb Bottini <g.bottini@arpa.vda.it>:

> 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
_____________________________________



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: postgres-two different version
  2007-01-30 11:46 postgres-two different version Bottini <g.bottini@arpa.vda.it>
@ 2007-01-30 15:03 ` Tom Lane <tgl@sss.pgh.pa.us>
  2007-01-30 17:04   ` Re: postgres-two different version codeWarrior <gpatnude@hotmail.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Tom Lane @ 2007-01-30 15:03 UTC (permalink / raw)
  To: Bottini <g.bottini@arpa.vda.it>; +Cc: pgsql-admin

"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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: postgres-two different version
  2007-01-30 11:46 postgres-two different version Bottini <g.bottini@arpa.vda.it>
  2007-01-30 15:03 ` Re: postgres-two different version Tom Lane <tgl@sss.pgh.pa.us>
@ 2007-01-30 17:04   ` codeWarrior <gpatnude@hotmail.com>
  2007-01-30 19:52     ` Re: postgres-two different version Naomi Walker <nwalke@eldocomp.com>
  0 siblings, 1 reply; 5+ messages in thread

From: codeWarrior @ 2007-01-30 17:04 UTC (permalink / raw)
  To: pgsql-admin

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
> 





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: postgres-two different version
  2007-01-30 11:46 postgres-two different version Bottini <g.bottini@arpa.vda.it>
  2007-01-30 15:03 ` Re: postgres-two different version Tom Lane <tgl@sss.pgh.pa.us>
  2007-01-30 17:04   ` Re: postgres-two different version codeWarrior <gpatnude@hotmail.com>
@ 2007-01-30 19:52     ` Naomi Walker <nwalke@eldocomp.com>
  0 siblings, 0 replies; 5+ messages in thread

From: Naomi Walker @ 2007-01-30 19:52 UTC (permalink / raw)
  To: codeWarrior <gpatnude@hotmail.com>; +Cc: pgsql-admin

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)
----------------------------------------------------------------------------


-- CONFIDENTIALITY NOTICE --

Information transmitted by this e-mail is proprietary to MphasiS and/or its Customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this e-mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailmaster@mphasis.com and delete this mail from your records.

^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2007-01-30 19:52 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-30 11:46 postgres-two different version Bottini <g.bottini@arpa.vda.it>
2007-01-30 12:15 ` Uwe Seher <uwe.seher@googlemail.com>
2007-01-30 15:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-01-30 17:04   ` codeWarrior <gpatnude@hotmail.com>
2007-01-30 19:52     ` Naomi Walker <nwalke@eldocomp.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox