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

Поиск
Список
Период
Сортировка
От Euler Taveira
Тема Re: BUG #16426: In active/hot standby mode, create database and droptemplate databases cause standby restart failed
Дата
Msg-id CAH503wBfkgsVY7i3g_skJnHPdfsH_mFZ+GvWT2SOFqw9+8p=BQ@mail.gmail.com
обсуждение исходный текст
Ответ на 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
Дерево обсуждения
On Sat, 9 May 2020 at 10:19, PG Bug reporting form <noreply@postgresql.org> wrote:

1) using createdb to create a database 'test'
2) drop template0 and template1 database
3) using 'pt_ctl stop -mi' to stop the standby db
4) restart the standby db, start failed

How are you removing template databases? I got an error while dropping a template database.

postgres=# drop database template1;
2020-05-09 11:07:56.094 -03 [6304] ERROR:  cannot drop a template database
2020-05-09 11:07:56.094 -03 [6304] STATEMENT:  drop database template1;
ERROR:  cannot drop a template database
postgres=# drop database template0;
2020-05-09 11:07:59.127 -03 [6304] ERROR:  cannot drop a template database
2020-05-09 11:07:59.127 -03 [6304] STATEMENT:  drop database template0;
ERROR:  cannot drop a template database


--
Euler Taveira                 http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Postgredb issue