Skip site navigation (1) Skip section navigation (2)

Re: Running Multiple Postmasters

From: Jean-Marc Pigeon <jmp(at)safe(dot)ca>
To: John Allgood <john(at)turbocorp(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Running Multiple Postmasters
Date: 2004-02-27 15:28:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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(dot)Pigeon(at)safe(dot)ca
SAFE Inc.		    	Phone: (514) 493-4280  Fax: (514) 493-1946
       REGULUS,  a real time accounting/billing package for ISP
           REGULUS' Home base <"">

In response to


pgsql-admin by date

Next:From: scott.marloweDate: 2004-02-27 16:00:58
Subject: Re: Running Multiple Postmasters
Previous:From: scottDate: 2004-02-27 15:13:40
Subject: unsubscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group