Re: PGXLOG variable worthwhile?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Curt Sampson <cjs(at)cynic(dot)net>, Justin Clift <justin(at)postgresql(dot)org>, PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PGXLOG variable worthwhile?
Date: 2002-09-16 02:49:01
Message-ID: 200209160249.g8G2n1c18660@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Curt Sampson <cjs(at)cynic(dot)net> writes:
> > On Thu, 12 Sep 2002, Justin Clift wrote:
> >> Am just wondering if we've ever considered adding a PGXLOG environment
> >> variable that would point to the pg_xlog directory?
>
> > IMHO, a much better way to support this is to put this information into
> > the config file. That way it can't easily change when you happen to, say,
> > start postgres in the wrong window.
>
> Yes. We rejected environment-variable-based xlog location for reasons
> that apply equally well to Windows. The xlog location *must* be stored
> in a physical file in the data directory; anything else is too unsafe.
> The current technology for that is a symlink.
>
> While it doesn't have to be a symlink as opposed to some sort of config
> file, I don't have the slightest problem with saying that we don't
> support relocation of xlog on older Windoid platforms.

Agreed. Win 4.X is pretty dead. I added this thread to TODO.detail.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Clift 2002-09-16 03:02:08 Re: PGXLOG variable worthwhile?
Previous Message Christopher Kings-Lynne 2002-09-16 02:10:05 Re: Proposal for resolving casting issues