Re: [HACKERS] PGXLOG variable worthwhile?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
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-17 22:22:47
Message-ID: 200209172222.g8HMMl427686@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Nigel J. Andrews wrote:
> 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.
>
> GUC instead of -X or PGXLOG : yes.
>
> However, how is that going to work if tablespaces are introduced in 7.4. Surely
> the same mechanism for tablespaces would be used for pg_xlog. As the tablespace
> mechanism hasn't been determined yet, as far as I know, wouldn't it be best to
> see what happens there before creating the TODO item for the log?

Good point. How about:

Allow pg_xlog to be moved without symlinks

That is vague enough. Added to TODO.

--
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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-09-17 22:28:58 Re: Copy Users?
Previous Message Justin Clift 2002-09-17 22:14:17 Re: [HACKERS] PGXLOG variable worthwhile?

Browse pgsql-hackers by date

  From Date Subject
Next Message Rod Taylor 2002-09-17 22:34:08 Re: PGXLOG variable worthwhile?
Previous Message Justin Clift 2002-09-17 22:14:17 Re: [HACKERS] PGXLOG variable worthwhile?