Re: tablespaces inside $PGDATA considered harmful

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: tablespaces inside $PGDATA considered harmful
Дата
Msg-id 20150423195742.GK3055@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: tablespaces inside $PGDATA considered harmful  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: tablespaces inside $PGDATA considered harmful  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: [BUGS] Failure to coerce unknown type to specific type
Следующее
От: Andres Freund
Дата:
Сообщение: Re: INSERT ... ON CONFLICT IGNORE (and UPDATE) 3.0