Re: tablespaces inside $PGDATA considered harmful - Mailing list pgsql-hackers

From Andres Freund
Subject Re: tablespaces inside $PGDATA considered harmful
Date
Msg-id 20150423150514.GF3055@alap3.anarazel.de
Whole thread Raw
In response to Re: tablespaces inside $PGDATA considered harmful  (Bruce Momjian <bruce@momjian.us>)
Responses Re: tablespaces inside $PGDATA considered harmful
List pgsql-hackers
On 2015-04-23 11:00:43 -0400, Bruce Momjian wrote:
> On Thu, Apr 23, 2015 at 09:13:52AM -0400, Robert Haas wrote:
> > I think this is a good thing to do, but I sure wish we could go
> > further and block it completely.  That may require more thought than
> > we have time to put in at this stage of the release cycle, though, so
> > +1 for doing at least this much.
> 
> OK, good.  Thinking to 9.6, I am not sure how we could throw an error
> because we have allowed this in the past and pg_dump is going to be
> restored with a raw SQL CREATE TABLESPACE command.  

We could just document that you need to pre-create the tablespace and
ignore the resulting error. This isn't going to affect too many people.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Freeze avoidance of very large table.
Next
From: Jim Nasby
Date:
Subject: Re: Split the 'Server Programming' chapter into two?