From: John Allgood <john@turbocorp.com>
To: Jean-Marc Pigeon <jmp@safe.ca>
To: pgsql-admin@postgresql.org
Subject: Re: Running Multiple Postmasters
Date: Fri, 27 Feb 2004 11:11:06 -0500
Message-ID: <403F6C1A.8030804@turbocorp.com> (raw)
In-Reply-To: <20040227152804.GD12798@montreal.safe.ca>
References: <403EB796.2010502@turbocorp.com>
<20040227152804.GD12798@montreal.safe.ca>
Jean-Marc Pigeon wrote:
>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.
>
Hello Again
What I have done is modified the basic startup script on redhat and
change the PGDATA and PGPORT to the corresponding port number and db
path. For my other startup parameters I have modified the
postgresql.conf in each database structure file this way I can start and
stop the databases easily. Just curious are you running the databases
from servers or workstations.
Thanks
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: john@turbocorp.com, jmp@safe.ca
Subject: Re: Running Multiple Postmasters
In-Reply-To: <403F6C1A.8030804@turbocorp.com>
References: <403EB796.2010502@turbocorp.com> <20040227152804.GD12798@montreal.safe.ca> <403F6C1A.8030804@turbocorp.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox