pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Can we have 2 databases on same server
4+ messages / 4 participants
[nested] [flat]

* Can we have 2 databases on same server
@ 2008-01-30 06:38  Suresh Gupta VG <suresh.g@zensar.com>
  0 siblings, 3 replies; 4+ messages in thread

From: Suresh Gupta VG @ 2008-01-30 06:38 UTC (permalink / raw)
  To: pgsql-general@postgresql.org; pgsql-admin

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?

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

3)       If we had a front end application and have the options like
switching the database, the 2 databases are compulsory, right?(Thinking
only one server is available.) 

 

Can you pls advice on this.

 

Regards,

G. V. Suresh Gupta

------------------------------------------------------------------------
---------------------------------------------------------

Innovative Technology Solutions(ITS), Zensar Technologies 

Zensar Knowledge Park, Plot#5, MIDC IT Tower, 

Kharadi, Off Nagar Road, Pune - 411014

Landline :  +91-20-66453471           | +91-9890898688                 

Email     :   suresh.g@zensar.com    | website:  www.zensar.com
<http://www.zensar.com/; 

 

 

 

 

 

 

            



DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails. 

Attachments:

image001.jpg (image/jpeg, 3.1K) download view image
^ permalink raw reply [nested|flat] 4+ messages in thread

* Re: [GENERAL] Can we have 2 databases on same server
@ 2008-01-30 06:56  Chris <dmagick@gmail.com>
  parent: Suresh Gupta VG <suresh.g@zensar.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Chris @ 2008-01-30 06:56 UTC (permalink / raw)
  To: Suresh Gupta VG <suresh.g@zensar.com>; +Cc: pgsql-general@postgresql.org; pgsql-admin


> 1)       Can I please know, if we can run 2 databases on the same server 
> with out any conflicts?

You can as long as they are installed in separate locations.

That is:

db1: /usr/local/pgsql/7.4
db2: /usr/local/pgsql/8.1

The main reason is so your app doesn't pick up the wrong binary and use 
that and cause all sorts of weird and wonderful errors :)

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

http://www.postgresql.org/docs/8.2/static/install-procedure.html (look 
at the --prefix stuff).

http://www.postgresql.org/docs/8.2/static/creating-cluster.html

and
http://www.postgresql.org/docs/8.2/static/install-upgrading.html

for how to copy your data into the new system.


They will also need to run on different ports. Edit the postgresql.conf 
file on the new install and change the port=5432 line to another 
(unused) number.

-- 
Postgresql & php tutorials
http://www.designmagick.com/



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Can we have 2 databases on same server
@ 2008-01-30 07:32  Gregory Williamson <Gregory.Williamson@digitalglobe.com>
  parent: Suresh Gupta VG <suresh.g@zensar.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Gregory Williamson @ 2008-01-30 07:32 UTC (permalink / raw)
  To: Suresh Gupta VG <suresh.g@zensar.com>; pgsql-general@postgresql.org; pgsql-admin

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.)

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: [GENERAL] Can we have 2 databases on same server
@ 2008-01-30 15:06  Chander Ganesan <chander@otg-nc.com>
  parent: Suresh Gupta VG <suresh.g@zensar.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Chander Ganesan @ 2008-01-30 15:06 UTC (permalink / raw)
  To: Suresh Gupta VG <suresh.g@zensar.com>; +Cc: pgsql-general@postgresql.org; pgsql-admin

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.

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2008-01-30 15:06 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-01-30 06:38 Can we have 2 databases on same server Suresh Gupta VG <suresh.g@zensar.com>
2008-01-30 06:56 ` Chris <dmagick@gmail.com>
2008-01-30 07:32 ` Gregory Williamson <Gregory.Williamson@digitalglobe.com>
2008-01-30 15:06 ` Chander Ganesan <chander@otg-nc.com>

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