> After takin a swig o' Arrakan spice grog, pgsql(at)mohawksoft(dot)com ("Mark
> Woodward") belched out:
>>> Mark Woodward wrote:
>> Like I have repeated a number of times, sometimes, there is more than
>> database cluster on a machine. The proposed pg_clusters.conf, could look
>> like this:
>> # Virtual target starts all?
>> pg_ctl start
>> (Finds and starts the "POSTMASTER" entry)
>> pg_ctl -S ICDMDB start
>> (Starts the ICDMDB cluster)
>> pg_ctl startall
>> pg_ctl -S [*|all] start
>> pg_ctl startall
>> Or maybe even "start" will start a virtual target "ALL"
> I can point at three things there that are distinctly wrong.
> - PORT should *never* be specified in that file, because it is already
> specified in each respective postgresql.conf file.
If one can specify a different port than the default on the command line,
why wouldn't a file designed to describe the server process include it. My
intention is to include all the options available via environment or
command lon in the file.
> - POSTMASTER is the wrong thing to point to; you should be pointing to
> a path, instead, and it must ALWAYS be specified.
I'm not sure I agree. I have been intending to let the system to use the
defaults when alternatves are not specified. The POSTMASTER entry was for
Tom Lane's suggestion that alternate postgresql versions be used.
I am open to a better cleaner way to accomplish Tom's request.
> - You provide no indication of where log files are to be stowed.
> In version 8, there are options for that to be specified in the
> postgresql.conf file, but not so, for earlier versions...
OK, I guess that comes along with all the command line or environment
> I'm not keen on the Windows .ini file style sectioning; that makes it
> look like a mix between a shell script and something else. It should
> be one or the other. It probably should be directly executable by
Hmm, while I agree that "ini" file is kind of ugly, it is fairly common in
the industry, human readable, and does what it needed.
> But having some central "registry" that consists of data directories
> and binary directories (and possibly log directories) seems reasonably
Oh, man, don't even get me started about registries and bottomless
directories. Let's just say I respectfully disagree :-)
In response to
pgsql-hackers by date
|Next:||From: Kevin Grittner||Date: 2006-02-28 17:36:28|
|Subject: Re: [PERFORM] temporary indexes|
|Previous:||From: Andrew Dunstan||Date: 2006-02-28 17:33:33|
|Subject: Re: new feature: LDAP database name resolution|