Re: [HACKERS] Bug in WAL backup documentation

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, <pgsql-hackers(at)postgresql(dot)org>, "Bernd Helmle" <mailings(at)oopsware(dot)de>, <pgsql-patches(at)postgresql(dot)org>, "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
Subject: Re: [HACKERS] Bug in WAL backup documentation
Date: 2006-11-05 16:43:11
Message-ID: 1162744991.3587.916.camel@silverbirch.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

On Sun, 2006-11-05 at 11:10 -0500, Tom Lane wrote:
> "Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> > On Sat, 2006-11-04 at 13:29 -0500, Tom Lane wrote:
> >> Looking back in the archives, I note that one of the arguments for
> >> making the server use relative paths everywhere was so that it'd be
> >> robust against things like DBAs moving directories that contain live
> >> postmasters. If we provide a %P option, or otherwise encourage people
> >> to write scripts that depend on the absolute path of $PGDATA, we'd lose
> >> some of this robustness.
>
> > I think I can fulfil Bernd, Florian and Martijn's wishes by supplying an
> > additional substitutable parameter %d which is replaced by the DataDir.
>
> This fails to respond to the concern that DataDir might be out-of-date.

I'm not suggesting that the option is necessary, but I am suggesting
offering it to those who consider it useful.

Let's allow it, but document the concern about its use in certain
circumstances.

I'm pretty sure most people don't move live postmasters very frequently,
plus it isn't clear to me why we should support the people that want
that to do that, yet not the people who want the absolute-path option.

--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-11-05 16:49:36 Re: [HACKERS] Bug in WAL backup documentation
Previous Message mark 2006-11-05 16:30:14 Re: PostgreSQL 8.2 (from CVS devel) first impressions

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-11-05 16:49:36 Re: [HACKERS] Bug in WAL backup documentation
Previous Message Tom Lane 2006-11-05 16:34:59 Re: WIP patch for tuple freezing issues