Re: One Database per Data File? - Mailing list pgsql-general

From Doug McNaught
Subject Re: One Database per Data File?
Date
Msg-id 87u0u4apkk.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: One Database per Data File?  (Randy Yates <yates@ieee.org>)
List pgsql-general
Randy Yates <yates@ieee.org> writes:

> Ahh, ok. So how does this answer my question or help me achieve
> my goal of one database per "initdb file set?" You also have not
> answered whether or not postmaster can have multiple instances
> running, each pointing to a different initdb file set.

You definitely can.  Each one needs a different value of PDGATA and
PGPORT.  You also need to make sure shared memory limits, semaphores
etc are beefy enough to handle all the instances.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Storing birthday data
Next
From: Doug McNaught
Date:
Subject: Re: PL/pgSQL Function Problem