Re: pg_config, pg_service.conf, postgresql.conf ....

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. +