Running Multiple Postmasters - Mailing list pgsql-admin

From John Allgood
Subject Running Multiple Postmasters
Date
Msg-id 403EB796.2010502@turbocorp.com
Whole thread Raw
Responses Re: Running Multiple Postmasters
Re: Running Multiple Postmasters
List pgsql-admin
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.

Disk 1

DB1    postmaster 5432
DB2          *          5433
DB3          *          5434

Disk 2

DB4          *          5435
DB5          *          5436
DB6          *          5437

Disk 3


Thanks
John Allgood - ESC
Systems Administrator
770.535.5049

pgsql-admin by date:

Previous
From: Anthony Raj
Date:
Subject: How to Recover From Accidental Deletes ?
Next
From: Tom Lane
Date:
Subject: Re: pg_hba.conf and user files