X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7E1E5D1DF80 for ; Fri, 27 Feb 2004 15:29:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 07064-07 for ; Fri, 27 Feb 2004 11:29:09 -0400 (AST) Received: from rome.safe.ca (mx02.safe.ca [206.123.20.82]) by svr1.postgresql.org (Postfix) with ESMTP id B7F58D1DA39 for ; Fri, 27 Feb 2004 11:28:38 -0400 (AST) Received: from mentor (localhost.localdomain [127.0.0.1]) by rome.safe.ca (8.12.8/8.12.8) with SMTP id i1RFSV7V021079 for ; Fri, 27 Feb 2004 10:28:32 -0500 Received: from No_Helo (montreal.safe.ca [192.219.254.53]) by pt02.safe.ca (mentor-1.2-237) with SMTP (version=TLSv1/SSLv3 cipher=AES256-SHA bits=256 verify=NO) id Fri Feb 27 10:28:07 2004 Date: Fri, 27 Feb 2004 10:28:04 -0500 From: Jean-Marc Pigeon To: John Allgood Cc: pgsql-admin@postgresql.org Subject: Re: Running Multiple Postmasters Message-ID: <20040227152804.GD12798@montreal.safe.ca> References: <403EB796.2010502@turbocorp.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <403EB796.2010502@turbocorp.com> User-Agent: Mutt/1.4.1i X-Mentor-Virus-checker: Clamav-0.66 (virlib:2004-02-26 14:22:38 EST5EDT) X-DCC-sonic.net-Metrics: rome.safe.ca 1117; Body=2 Fuz1=2 Fuz2=2 X-Mentor-Version: 1.2-237 X-Mentor-ID: X-Mentor-Level: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/380 X-Sequence-Number: 12553 Bonjour John Allgood, > Hello > > I am building a server to run 9 databases. Can I run a seperate > postmaster for each of the 9 databases. I would be setting the port > number to a different value for each db of course. The reason I wish to > do this is so that I can install about three databases on a seperate > disk and put the other on seperate disk as well. I want to be able to > build scripts to shutdown and start each database individually. Example > below. I would also put the WAL on seperate disk as well which I will do > with links. I this something I can do. No problem to do this, we are doing the same (each designer getting its own data-base) for test purpose. command like: /usr/bin/postmaster -D //regulus/reg2/dbm -p 1622 -B512 -o -S2048 where -D and -p parameter are different for each data-base. (we are starting postmater from inside the application itself such we are sure application is working on the proper base and port) Be sure to create a full data-base structure in the proper area. -- A bientot ========================================================================== Jean-Marc Pigeon Internet: Jean-Marc.Pigeon@safe.ca SAFE Inc. Phone: (514) 493-4280 Fax: (514) 493-1946 REGULUS, a real time accounting/billing package for ISP REGULUS' Home base <"http://www.regulus.safe.ca"> ==========================================================================