Re: BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed
Дата
Msg-id 3304.1589037048@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> In active/hot standby mod, doing likes the following:

> 1) using createdb to create a database 'test'
> 2) drop template0 and template1 database

Removing the template0 database is not a supported configuration.
There are emergency situations where it could make sense to do it,
perhaps, but only if you then recreate it (using some other database
as template); and even then you'd better be a guru who knows exactly
what he's doing, or you'll mess up the installation beyond repair.

It's certainly no surprise that dump/restore type activities will
fail with no template for CREATE DATABASE to source from.

> Is this a Bug?

No, it's Pilot Error.

            regards, tom lane



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

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: Postgredb issue
Следующее
От: Thusitha Maheepala
Дата:
Сообщение: Re: Postgredb issue