pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <smarlowe@qwest.net>
To: Andrew J Delamare <andrew.delamare@amadeo.co.uk>
Cc: pgsql-admin@postgresql.org
Subject: Re: Adding multiple instances to 7.4
Date: Wed, 11 Aug 2004 03:14:32 -0600
Message-ID: <1092215672.2773.1.camel@localhost.localdomain> (raw)
In-Reply-To: <E1Bu79E-000LiG-0V@anchor-post-31.mail.demon.net>
References: <E1Bu79E-000LiG-0V@anchor-post-31.mail.demon.net>

On Mon, 2004-08-09 at 04:12, Andrew J Delamare wrote:
> Hi there,
> 
> I'm a little new to postgres but I am wondering (as it doesn't seem to be in
> the in site documentation) how to add multiple instances to a 7.4 Postgres
> installation.
> 
> The scenario is that I have 4 Databases all on separate systems at the
> moment that are core the business and the thought was that we could put them
> all onto one high availability machine as instances under 1 postgres
> install.
> 
> Is there any documented way of doing that or does anyone have experience of
> doing that they would like to share with me.

Unless you have some out of the ordinary requirements, you should be
able to just createdb dbname the databases you need.  It is possible to
set up multiple clusters, each listening on a different port, but this
means each postmaster has its own shared_memory requirements, and
generally places a heavier load on the server than running the databases
out of the same cluster.




view thread (4+ messages)

Message-ID: <1092215672.2773.1.camel@localhost.localdomain>
Permalink:  ../1092215672.2773.1.camel@localhost.localdomain/
Also on:    postgresql.org/message-id/1092215672.2773.1.camel@localhost.localdomain

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: smarlowe@qwest.net, andrew.delamare@amadeo.co.uk
  Subject: Re: Adding multiple instances to 7.4
  In-Reply-To: <1092215672.2773.1.camel@localhost.localdomain>
  References: <E1Bu79E-000LiG-0V@anchor-post-31.mail.demon.net> <1092215672.2773.1.camel@localhost.localdomain>

* 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