Skip site navigation (1) Skip section navigation (2)

Re: Can we have 2 databases on same server

From: "Gregory Williamson" <Gregory(dot)Williamson(at)digitalglobe(dot)com>
To: "Suresh Gupta VG" <suresh(dot)g(at)zensar(dot)com>,<pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Can we have 2 databases on same server
Date: 2008-01-30 07:32:16
Message-ID: 8B319E5A30FF4A48BE7EEAAF609DB233015E32B2@COMAIL01.digitalglobe.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
Suresh Gupta asked:

> 
> I have Solaris 9 machine with Pgsql 7.4 and want to upgrade to 8.2.5. I
> don't want to disturb the first version now. I want to install second
> one separately and need to test with my application. If it works fine, I
> will activate only the latest one and other version 7.4 will be
> discarded. This is my idea.
> 
> 1)       Can I please know, if we can run 2 databases on the same server
> with out any conflicts?

Absolutely. We have one server with 8.1.x, 8.2.x and 8.3RC2 one it. We don't push more than one of them hard at any given time though, but we probably could (disk contention would be the biggest issue). As others pointed out, make different directories for the software and data.

> 2)       If it is so, at what stage we are need to configure the 2
> databases? Pls provide links or docs if available.

Before firing up the new instance, make sure you have enough shared memory allocated for *both* instances. Read the relevant docs pointed out in another response and make sure you specify the correct directories and ports etc. when running initdb to create the new 8.2 database. Make sure you point the logs to different files as well.

<...>

HTH,


Greg Williamson
Senior DBA
GlobeXplorer LLC, a DigitalGlobe company

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

(My corporate masters made me say this.)


In response to

pgsql-admin by date

Next:From: Markus SchiltknechtDate: 2008-01-30 09:49:14
Subject: Re: how to create cluster(loadbanacing) of postgresql server
Previous:From: Brian ModraDate: 2008-01-30 06:59:11
Subject: Re: how to create cluster(loadbanacing) of postgresql server

pgsql-general by date

Next:From: Ow Mun HengDate: 2008-01-30 07:54:02
Subject: Re: postgresql book - practical or something newer?
Previous:From: Brian ModraDate: 2008-01-30 06:59:11
Subject: Re: how to create cluster(loadbanacing) of postgresql server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group