Re: Fixing pg_basebackup with tablespaces found in $PGDATA - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Fixing pg_basebackup with tablespaces found in $PGDATA
Date
Msg-id 490A525B2C76BE74B763F97C@apophis.credativ.lan
Whole thread Raw
In response to Fixing pg_basebackup with tablespaces found in $PGDATA  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: Fixing pg_basebackup with tablespaces found in $PGDATA  (Michael Paquier <michael.paquier@gmail.com>)
Re: Fixing pg_basebackup with tablespaces found in $PGDATA  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers

--On 1. Januar 2014 23:53:46 +0100 Dimitri Fontaine 
<dimitri@2ndQuadrant.fr> wrote:

> Hi,
>
> As much as I've seen people frown upon $subject, it still happens in the
> wild, and Magnus seems to agree that the current failure mode of our
> pg_basebackup tool when confronted to the situation is a bug.
>
> So here's a fix, attached.

I've seen having tablespaces under PGDATA as a policy within several data 
centres in the past. The main reasoning behind this seems that they 
strictly separate platform and database administration and for database 
inventory reasons. They are regularly surprised if you tell them to not use 
tablespaces in such a way, since they absorbed this practice over the years 
from other database systems. So +1 for fixing this.

-- 
Thanks
Bernd



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: more psprintf() use
Next
From: Tom Lane
Date:
Subject: Re: preserving forensic information when we freeze