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

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mark Woodward <pgsql(at)mohawksoft(dot)com>
Cc: josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org, Martijn van Oosterhout <kleptog(at)svana(dot)org>
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....
Date: 2006-02-28 04:50:24
Message-ID: 200602280450.k1S4oOJ09150@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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. +

In response to

pgsql-hackers by date

Next:From: Mark WoodwardDate: 2006-02-28 04:52:43
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....
Previous:From: Mark WoodwardDate: 2006-02-28 04:34:20
Subject: Re: pg_config, pg_service.conf, postgresql.conf ....

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