Re: pg_upgrade if 'postgres' database is dropped

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: pg_upgrade if 'postgres' database is dropped
Дата
Msg-id 20111028024534.GF24234@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: pg_upgrade if 'postgres' database is dropped  (Bruce Momjian <bruce@momjian.us>)
Ответы Re: pg_upgrade if 'postgres' database is dropped
Список pgsql-hackers
* Bruce Momjian (bruce@momjian.us) wrote:
> I have not seen enough demand to make this a user-visible configuration.
> We can just tell them to create a postgres database.   Frankly, they
> would have had to _remove_ the postgres database after initdb for it not
> to be there, and they are instructed to change nothing about the new
> database.

Yes, they would have removed it because they didn't want it.  As I
recall, part of the agreement to create an extra database by default was
that it could be removed if users didn't want it.  Turning around and
then saying "but things won't work if it's not there" isn't exactly
supporting users who decide to remove it.

Regarding pg_dumpall and pg_restore, I'm pretty sure both of those can
be configured to connect to other databases instead, including for
globals.
Thanks,
    Stephen

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade if 'postgres' database is dropped
Следующее
От: Chris Redekop
Дата:
Сообщение: Re: Hot Standby startup with overflowed snapshots