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

From Andres Freund
Subject Re: tablespaces inside $PGDATA considered harmful
Date
Msg-id 20150423195742.GK3055@alap3.anarazel.de
Whole thread Raw
In response to Re: tablespaces inside $PGDATA considered harmful  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: tablespaces inside $PGDATA considered harmful
List pgsql-hackers
On 2015-04-23 15:46:20 -0400, Robert Haas wrote:
> Well, we've made backward-incompatible changes before.  Not to this
> specific thing, but in general.  I don't think there's anything
> preventing us from doing so here, except that we don't want to annoy
> too many users.

I think the number of users that have done this, and haven't yet
(knowing or unknowningly) been bitten by it is pretty low. In that
scenario it seems much better to break compatibility given that it's
pretty easy to fix during restore (just precreate the tablespace).  It's
not something you have to retest a whole application for.

If you want to avoid that one error you can still do pg_dumpall
--globals, edit and run that script, and only then restore the the
actual databases.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [BUGS] Failure to coerce unknown type to specific type
Next
From: Andres Freund
Date:
Subject: Re: INSERT ... ON CONFLICT IGNORE (and UPDATE) 3.0