Re: [HACKERS] PGXLOG variable worthwhile?

From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, <shridhar_daithankar(at)persistent(dot)co(dot)in>, <Pgsql-hackers(at)postgresql(dot)org>, <Pgsql-general(at)postgresql(dot)org>
Subject: Re: [HACKERS] PGXLOG variable worthwhile?
Date: 2002-09-19 01:28:52
Message-ID: 20020918222157.P53125-100000@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Tue, 17 Sep 2002, Bruce Momjian wrote:

> Dave Page wrote:
> > Which in this case is what puzzles me. We are only talking about a
> > simple GUC variable after all - I don't know for sure, but I'm guessing
> > it's not a huge effort to add one?
>
> Can we get agreement on that? A GUC for pg_xlog location? Much cleaner
> than -X, doesn't have the problems of possible accidental use, and does
> allow pg_xlog moving without symlinks, which some people don't like?
>
> If I can get a few 'yes' votes I will add it to TODO and do it for 7.4.

Personally, I like the ability to define such at a command line level ...
*especially* as it pertains to pointing to various directories ... I am
against pulling the -X functionality out ... if you don't like it, don't
use it ... add the GUC variable option to the mix, but don't take away
functionality ...

Hell, take a look at what you are saying above: because someone might
forget to set -X, let's get rid of it in favor of a setting in a file that
someone might forget to edit?

Either format has the possibility of an error ... if you are so
incompetent as to make that sort of mistake on a production server, it
won't matter if its a GUC variable, environment variable or commnd line
argument, you will still make that mistake ...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-09-19 01:36:31 Re: [HACKERS] PGXLOG variable worthwhile?
Previous Message Martijn van Oosterhout 2002-09-19 00:45:26 Re: Boolean internal representation

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-09-19 01:36:31 Re: [HACKERS] PGXLOG variable worthwhile?
Previous Message Marc G. Fournier 2002-09-19 01:21:13 Restore from pre-v7.3 -> v7.3 (Was: Re: RPMS for 7.3 beta.)