pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jean-Marc Pigeon <jmp@safe.ca>
To: John Allgood <john@turbocorp.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Running Multiple Postmasters
Date: Fri, 27 Feb 2004 10:28:04 -0500
Message-ID: <20040227152804.GD12798@montreal.safe.ca> (raw)
In-Reply-To: <403EB796.2010502@turbocorp.com>
References: <403EB796.2010502@turbocorp.com>

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";
==========================================================================



view thread (4+ messages)  latest in thread

Message-ID: <20040227152804.GD12798@montreal.safe.ca>
Permalink:  ../20040227152804.GD12798@montreal.safe.ca/
Also on:    postgresql.org/message-id/20040227152804.GD12798@montreal.safe.ca

 · 

reply

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: jmp@safe.ca, john@turbocorp.com
  Subject: Re: Running Multiple Postmasters
  In-Reply-To: <20040227152804.GD12798@montreal.safe.ca>
  References: <403EB796.2010502@turbocorp.com> <20040227152804.GD12798@montreal.safe.ca>

* 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