Re: WAL file location

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Curt Sampson <cjs(at)cynic(dot)net>
Cc: Andrew Sullivan <andrew(at)libertyrms(dot)info>, PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: WAL file location
Date: 2002-08-01 03:20:35
Message-ID: 200208010320.g713KZQ24189@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Curt Sampson wrote:
> On Wed, 31 Jul 2002, Andrew Sullivan wrote:
>
> > Ok, how then would one set the location of the config file?
>
> Option on the command line. Works for lots of different servers out
> there already (BIND, apache, etc.).
>
> Whether we also want to emulate them using a compiled-in default if the
> command line option is not specified, I don't know. I would tend to
> prefer not, because that might change from system to system, and also
> if someone leaves the "default" config file around but isn't using it,
> you can accidently start up postgres with the wrong config. But I won't
> argue that point heavily.
>
> I hate environment variables for servers because the environment
> changes, is hard to detect on some systems (ps always shows you the
> command line unless you muck with it), etc.
>
> > And I presume this is all for the server only, right? Nobody is
> > talking about getting rid of (for instance) $PGPORT for clients,
> > right?
>
> I'm certainly not wanting to get rid of it on the client. I won't go
> into the reasons unless anybody really cares....

I am wondering why we even want to specify the WAL location anywhere
except as a flag to initdb. If you specify a location at initdb time,
it creates the /xlog directory, then symlinks it into /data.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2002-08-01 03:27:43 Re: Open 7.3 items
Previous Message Bruce Momjian 2002-08-01 03:17:45 Re: Open 7.3 items