X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 66EFA14B2806 for ; Wed, 11 Aug 2004 06:13:18 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07750-07 for ; Wed, 11 Aug 2004 09:13:09 +0000 (GMT) Received: from mpls-qmqp-03.inet.qwest.net (mpls-qmqp-03.inet.qwest.net [63.231.195.114]) by svr1.postgresql.org (Postfix) with SMTP id 16C6614B281C for ; Wed, 11 Aug 2004 06:13:07 -0300 (ADT) Received: (qmail 66904 invoked by uid 0); 11 Aug 2004 08:41:10 -0000 Received: from mpls-pop-11.inet.qwest.net (63.231.195.11) by mpls-qmqp-03.inet.qwest.net with QMQP; 11 Aug 2004 08:41:10 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-11.inet.qwest.net with SMTP; 11 Aug 2004 09:13:05 -0000 Date: Wed, 11 Aug 2004 03:14:32 -0600 Message-Id: <1092215672.2773.1.camel@localhost.localdomain> From: "Scott Marlowe" To: "Andrew J Delamare" Cc: pgsql-admin@postgresql.org Subject: Re: Adding multiple instances to 7.4 In-Reply-To: References: Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200408/73 X-Sequence-Number: 14468 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.