Adding multiple instances to 7.4

[Andrew J Delamare]

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



---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Peter Eisentraut]

Post by Andrew J Delamare
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.

[Jouneau Luc]

Post by Andrew J Delamare
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


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Scott Marlowe]

Post by Andrew J Delamare
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.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings