Re: create tablespace fails silently, or succeeds improperly

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <bruce@momjian.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Dave Cramer <pg@fastcrypt.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-10-18T19:02:15Z
Lists: pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Robert Haas wrote:
>> Perhaps we should fix the behavior rather than the documentation.

> We can't fix the behavior because we have to allow an old cluster to
> keep its tablespace files during a pg_upgrade.  They are given a script
> to delete those files later, if they want.

The new *layout* of the files may be forced by pg_upgrade
considerations, but I don't think that proves much of anything about
ownership and permissions settings --- especially not the fact that we
are now enforcing settings that were designed for the data directory
itself on what is effectively one level up from that.

			regards, tom lane