From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_basebackup for streaming base backups |
Date: | 2011-01-20 02:06:53 |
Message-ID: | AANLkTinOk1sKBwT=xgEB-teT76fNjYtYAetCi-UemChT@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Jan 20, 2011 at 10:53 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> 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.
Hmm.. but ISTM we can have a root-owned mount point in $PGDATA
and create a tablespace there.
$ su -
# mkdir $PGDATA/mnt
# mount -t tmpfs tmpfs $PGDATA/mnt
# exit
$ mkdir $PGDATA/mnt/tblspcdir
$ psql
=# CREATE TABLESPACE tblspc LOCATION '$PGDATA/mnt/tblspcdir';
CREATE TABLESPACE
Am I missing something?
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2011-01-20 02:09:35 | Re: psql: Add \dL to show languages |
Previous Message | Dan Ports | 2011-01-20 02:06:17 | Re: SSI and Hot Standby |