pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Chander Ganesan <chander@otg-nc.com>
To: Suresh Gupta VG <suresh.g@zensar.com>
Cc: pgsql-general@postgresql.org
Cc: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] Can we have 2 databases on same server
Date: Wed, 30 Jan 2008 10:06:06 -0500
Message-ID: <47A0925E.1070601@otg-nc.com> (raw)
In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0C0A57B5@ZENMAILHQ1.ind.zensar.com>
References: <3D5445983859B84B92669C0D883EA6FB0C0A57B5@ZENMAILHQ1.ind.zensar.com>

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.

view thread (4+ messages)

Message-ID: <47A0925E.1070601@otg-nc.com>
Permalink:  ../47A0925E.1070601@otg-nc.com/
Also on:    postgresql.org/message-id/47A0925E.1070601@otg-nc.com

 · 

reply

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 using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: chander@otg-nc.com, suresh.g@zensar.com, pgsql-general@postgresql.org
  Subject: Re: [GENERAL] Can we have 2 databases on same server
  In-Reply-To: <47A0925E.1070601@otg-nc.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