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