Adding multiple instances to 7.4

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.

Any information is appreciated.

Regards
--
Andrew Delamare
The Cloud Networks Ltd

Andrew J Delamare wrote:
> 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.

Just start the postmaster several times with different data directories
(so they serve different data) and different ports (so you can address
them separately). An alternative might be to run only one instance but
put each of your separate databases into its own PostgreSQL database
under the same instance.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

You could either put them in the same instance or create with initdb 4
different database cluster locations and launch 4 postmasters listening on
different port (set PGDATA and PGPORT to distinct values before to launch
each postmater).

Jouneau Luc

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.