On 05/25/2015 01:21 PM, Tom Lane wrote:
> And from the other direction, where exactly is it written that
> distros/users will only create problematic files at the top level of
> $PGDATA? I'd have zero confidence in such an assertion applied to
> tablespace directories, for sure.
Yes, absolutely.
For example: Cstore_FDW now puts its files in a subdirectory of the
tablespace directory, which for a really large cstore table, the user
will want to symlink somewhere else, or might create as a mount. Such a
user might then, for example, annotate this with a README.txt which
happens to be root/root perms.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com