Re: tablespaces and non-empty directories - Mailing list pgsql-hackers

From Zeugswetter Andreas DCP SD
Subject Re: tablespaces and non-empty directories
Date
Msg-id E1539E0ED7043848906A8FF995BDA5799A521C@m0143.s-mxs.net
Whole thread Raw
In response to tablespaces and non-empty directories  (Philip Yarra <philip@utiba.com>)
Responses Re: tablespaces and non-empty directories  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > This is because lost+found exists. Since lost+found would be a
> > reasonably common directory to find at a mount-point on Unix-like
> > OSs*, would it make sense for CREATE TABLESPACE to ignore it if
present?

> No.  There is no reason to use a volume's root directory as a
tablespace;
> especially so since the root directory ought to be owned by root

That is not so on AIX. Only the moint point (the dir in the parent) is
root.
Once mounted it can have (and preserves) any permission you want.
But on AIX the workaround is to remove the directory after mounting and
before
creating the tablespace.

Andreas


pgsql-hackers by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: MERGE vs REPLACE
Next
From: "Zeugswetter Andreas DCP SD"
Date:
Subject: Re: MERGE vs REPLACE