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 2AEFD14B287A for ; Wed, 11 Aug 2004 04:26:11 -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 75287-02 for ; Wed, 11 Aug 2004 07:26:05 +0000 (GMT) Received: from jais.jouy.inra.fr (jais.jouy.inra.fr [138.102.1.17]) by svr1.postgresql.org (Postfix) with ESMTP id CAD1514B2866 for ; Wed, 11 Aug 2004 04:25:59 -0300 (ADT) Received: from diamant.jouy.inra.fr (localhost [127.0.0.1]) by jais.jouy.inra.fr (8.10.1/8.10.1) with ESMTP id i7B7PxN24793 for ; Wed, 11 Aug 2004 09:25:59 +0200 (CEST) Received: from pc502jlo (pc502ljo [138.102.3.71]) by diamant.jouy.inra.fr (8.10.1/8.10.1) with SMTP id i7B7Px813832 for ; Wed, 11 Aug 2004 09:25:59 +0200 (CEST) Message-ID: <006c01c47f74$7399f520$4703668a@pc502jlo> From: "Jouneau Luc" To: References: Subject: Re: Adding multiple instances to 7.4 Date: Wed, 11 Aug 2004 09:26:00 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/72 X-Sequence-Number: 14467 > 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