From: Naomi Walker <nwalke@eldocomp.com>
To: codeWarrior <gpatnude@hotmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: postgres-two different version
Date: Tue, 30 Jan 2007 12:52:18 -0700
Message-ID: <45BFA1F2.5050301@eldocomp.com> (raw)
In-Reply-To: <epntjh$1ri3$1@news.hub.org>
References: <002101c74464$4d7eea50$ae05a8c0@arpavda.it>
<1892.1170169384@sss.pgh.pa.us>
<epntjh$1ri3$1@news.hub.org>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: nwalke@eldocomp.com, gpatnude@hotmail.com
Subject: Re: postgres-two different version
In-Reply-To: <45BFA1F2.5050301@eldocomp.com>
References: <002101c74464$4d7eea50$ae05a8c0@arpavda.it> <1892.1170169384@sss.pgh.pa.us> <epntjh$1ri3$1@news.hub.org> <45BFA1F2.5050301@eldocomp.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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