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...
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
Ask me about Expert PostgreSQL & PostGIS Training Delivered Worldwide.
In response to
pgsql-admin by date
|Next:||From: Kasia Tuszynska||Date: 2008-01-30 18:33:13|
|Subject: monitoring fragmentation |
|Previous:||From: Kevin Grittner||Date: 2008-01-30 14:53:29|
|Subject: Re: connection from connection pool uses too muchmemory during the time|
pgsql-general by date
|Next:||From: Erik Jones||Date: 2008-01-30 15:19:30|
|Subject: Re: PGCon vs Postgresql Conference|
|Previous:||From: Peter Wilson||Date: 2008-01-30 13:52:55|
|Subject: Re: postgresql book - practical or something newer?|