Re: pg_basebackup for streaming base backups - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_basebackup for streaming base backups
Date
Msg-id 1905.1295488388@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_basebackup for streaming base backups  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: pg_basebackup for streaming base backups  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
Fujii Masao <masao.fujii@gmail.com> writes:
> On Thu, Jan 20, 2011 at 2:21 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Fujii Masao <masao.fujii@gmail.com> writes:
>>> What I'm worried about is the case where a tablespace is created
>>> under the $PGDATA directory.

>> What would be the sense of that? �If you're concerned about whether the
>> code handles it correctly, maybe the right solution is to add code to
>> CREATE TABLESPACE to disallow it.

> I'm not sure why that's the right solution. Why do you think that we should
> not create the tablespace under the $PGDATA directory? I'm not surprised
> that people mounts the filesystem on $PGDATA/mnt and creates the
> tablespace on it.

No?  Usually, having a mount point in a non-root-owned directory is
considered a Bad Thing.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Noah Misch
Date:
Subject: Re: ALTER TABLE ... REPLACE WITH
Next
From: Robert Haas
Date:
Subject: Re: ALTER TABLE ... REPLACE WITH