Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 84A572E009D for ; Wed, 30 Jan 2008 11:06:11 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 89257-10 for ; Wed, 30 Jan 2008 11:06:01 -0400 (AST) Received: from smtp162.iad.emailsrvr.com (smtp162.iad.emailsrvr.com [207.97.245.162]) by postgresql.org (Postfix) with ESMTP id B7FE62E019F for ; Wed, 30 Jan 2008 11:06:01 -0400 (AST) Received: from relay6.relay.iad.emailsrvr.com (localhost [127.0.0.1]) by relay6.relay.iad.emailsrvr.com (SMTP Server) with ESMTP id 2C491702621; Wed, 30 Jan 2008 10:06:00 -0500 (EST) Received: by relay6.relay.iad.emailsrvr.com (Authenticated sender: chander-AT-otg-nc.com) with ESMTP id B6E27702798; Wed, 30 Jan 2008 10:05:59 -0500 (EST) Message-ID: <47A0925E.1070601@otg-nc.com> Date: Wed, 30 Jan 2008 10:06:06 -0500 From: Chander Ganesan User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: Suresh Gupta VG CC: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: [GENERAL] Can we have 2 databases on same server References: <3D5445983859B84B92669C0D883EA6FB0C0A57B5@ZENMAILHQ1.ind.zensar.com> In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0C0A57B5@ZENMAILHQ1.ind.zensar.com> Content-Type: multipart/alternative; boundary="------------080001060302000002080901" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/287 X-Sequence-Number: 28061 This is a multi-part message in MIME format. --------------080001060302000002080901 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hello Suresh, Suresh Gupta VG wrote: > > Hi Team, > > > > 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? > It looks like you already got the answer on this one.. however, your terminology is a bit off. Unlike Oracle (where we think in terms of "databases"), in PostgreSQL we think in terms of "clusters", where a cluster (often used interchangeably with the word "server") is a collection of databases. A cluster listens on a single port, has a single "data" directory, and manages a single list of roles (accounts and groups) that span all of the databases that are managed by the cluster. Hope that helps. When you read the documentation you will see references to "Clusters", not databases... -- Chander Ganesan Open Technology Group, Inc. One Copley Parkway, Suite 210 Morrisville, NC 27560 919-463-0999/877-258-8987 http://www.otg-nc.com Ask me about Expert PostgreSQL & PostGIS Training Delivered Worldwide. --------------080001060302000002080901 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hello Suresh,

Suresh Gupta VG wrote:

Hi Team,

 

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?

It looks like you already got the answer on this one.. however, your terminology is a bit off.  Unlike Oracle (where we think in terms of "databases"), in PostgreSQL we think in terms of "clusters", where a cluster (often used interchangeably with the word "server") is a collection of databases.  A cluster listens on a single port, has a single "data" directory, and manages a single list of roles (accounts and groups) that span all of the databases that are managed by the cluster.

Hope that helps.  When you read the documentation you will see references to "Clusters", not databases...
-- 
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
919-463-0999/877-258-8987
http://www.otg-nc.com
Ask me about Expert PostgreSQL & PostGIS Training Delivered Worldwide.
--------------080001060302000002080901--