I don't see how this is much better than just pointing to different configuration file for each postmaster.
--------------------------------------------------------------------------- Mark Woodward wrote: > > One question I have is how this feature would be an improvement over > > just pointing pg_ctl at a postgresql.conf configuration file. That > > config file has the ability to specify most if not all server > > parameters. > > Like I have repeated a number of times, sometimes, there is more than one > database cluster on a machine. The proposed pg_clusters.conf, could look > like this: > > pg_clusters.conf>>>> > [GEO] > DATADIR=/vol01/pggeo > PORT=5435 > > [ICDMDB] > DATADIR=/vol01/pgicdmdb > PORT=5434 > > [TOMLANE] > DATADIR=/vol03/pg74 > PORT=5433 > POSTMASTER=/usr/local/pg7.4.1/bin/postmaster > > [POSTMASTER] > DATADIR=/vol02/pg90 > PORT=5432 > > # Virtual target starts all? > [ALL] > DB0=GEO > DB1=ICDMDB > DB2=TOMLANE > > <<<<<<<<< > > pg_ctl start > (Finds and starts the "POSTMASTER" entry) > > pg_ctl -S ICDMDB start > (Starts the ICDMDB cluster) > > pg_ctl startall > or > pg_ctl -S [*|all] start > or > pg_ctl startall > > > Or maybe even "start" will start a virtual target "ALL" > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
