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
Дата
в 14:24:51
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)
Список
Дерево обсуждения
BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed PG Bug reporting form <noreply@postgresql.org>
Re: BUG #16426: In active/hot standby mode, create database and droptemplate databases cause standby restart failed Euler Taveira <euler.taveira@2ndquadrant.com>
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
Дата:
Следующее
От: David G. Johnston
Дата:
Сообщение: Re: Postgredb issue
FAQ