Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group