Re: create tablespace fails silently, or succeeds improperly
From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Bruce Momjian <bruce(at)momjian(dot)us>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Dave Cramer <pg(at)fastcrypt(dot)com>,
PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: create tablespace fails silently, or succeeds improperly
Date:
2010-10-18 19:02:15
Message-ID:
23800.1287428535@sss.pgh.pa.us (view raw or flat )
Thread:
2010-10-18 15:23:40 from Dave Cramer <pg(at)fastcrypt(dot)com>
2010-10-18 15:31:12 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-10-18 18:20:02 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-18 18:35:21 from Dave Cramer <pg(at)fastcrypt(dot)com>
2010-10-18 18:39:47 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-18 18:44:09 from Dave Cramer <pg(at)fastcrypt(dot)com>
2010-10-18 18:56:03 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-18 18:57:11 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-18 15:37:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-18 17:24:58 from Dave Cramer <pg(at)fastcrypt(dot)com>
2010-10-18 18:17:31 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-18 18:19:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-18 18:29:15 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-18 19:02:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-18 19:03:08 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-18 19:05:04 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-18 19:07:16 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-18 19:16:35 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-18 19:21:26 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-18 19:29:20 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-10-18 19:50:58 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-18 20:02:01 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-12-10 20:26:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 22:54:23 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-10 23:01:44 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-10 23:08:38 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-12-11 03:33:16 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-11 03:41:18 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-11 04:17:21 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-12-11 15:56:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-11 18:15:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-11 18:20:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-11 18:23:10 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-11 18:38:28 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-12-12 01:56:40 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-12-12 22:04:11 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2010-12-12 23:10:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-18 19:04:14 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-18 18:26:32 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-18 18:59:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-18 19:03:22 from Bruce Momjian <bruce(at)momjian(dot)us>
Lists:
pgsql-hackers
Bruce Momjian <bruce(at)momjian(dot)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
In response to
Responses
pgsql-hackers by date
Next :From: Robert HaasDate: 2010-10-18 19:03:08Subject : Re: create tablespace fails silently, or succeeds improperlyPrevious :From : Robert HaasDate : 2010-10-18 19:01:06Subject : Re: Floating-point timestamps versus Range Types
