Re: [GENERAL] PGXLOG variable worthwhile? - Mailing list pgsql-hackers

From Greg Copeland
Subject Re: [GENERAL] PGXLOG variable worthwhile?
Date
Msg-id 1032443235.3268.343.camel@mouse.copelandconsulting.net
Whole thread Raw
In response to Re: [GENERAL] PGXLOG variable worthwhile?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: [GENERAL] PGXLOG variable worthwhile?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-hackers
I think Marc made a pretty good case about the use of command line
arguments but I think I have to vote with Tom.  Many of the command line
arguments you seem to be using do sorta make sense to have for easy
reference or to help validate your runtime environment for each
instance.  The other side of that is, I completely agree with Tom in the
it's a very dangerous option.  It would be begging for people to shoot
themselves with it.  Besides, just as you can easily parse the command
line, you can also parse the config file to out that information.  Plus,
it really should be a very seldom used option.  When it is used, it's
doubtful that you'll need the same level of dynamic control that you get
by using command line options.

As a rule of thumb, if an option is rarely used or is very dangerous if
improperly used, I do think it should be in a configuration file to
discourage adhoc use.

Let's face it, specify XLOG location is hardly something people need to
be doing on the fly.

My vote is config file it and no command line option!

Greg


On Wed, 2002-09-18 at 23:50, Bruce Momjian wrote:
> Marc G. Fournier wrote:
> > On Wed, 18 Sep 2002, Bruce Momjian wrote:
> >
> > > Yea, but you aren't going to be needing to know the xlog directory that
> > > way, will you?
> >
> > Why not?  Who are you to tell me how my scripts work, or how they get
> > their information?  I have a script that runs to tell me how much disk
> > space each instance is using up, that parses the ps output for the -D
> > argument ... having -X there would allow me to parse for that as well and,
> > if it was in the ps output, add that appropriately into the calculations
> > ...
> >
> > My point is, the functionality is there, and should be documented properly
> > ... encourage ppl to use the GUC setting in postmaster.conf, but just
> > because you can't grasp that some of us *like* to use command line args,
> > don't remove such functionality ...
>
> You ask for a vote and see if you can get votes to add -X.  We had that
> vote once already.  We do make decisions on what people should use.  If
> not, we would be as hard to manage as Oracle.
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: The TODO List (Was: Re: Open 7.3 items)
Next
From: Tom Lane
Date:
Subject: Re: Proposal for resolving casting issues