Postgres Pro
Downloads
Home   >   mailing lists

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

From Euler Taveira
Subject Re: BUG #16426: In active/hot standby mode, create database and droptemplate databases cause standby restart failed
Date
Msg-id CAH503wBfkgsVY7i3g_skJnHPdfsH_mFZ+GvWT2SOFqw9+8p=BQ@mail.gmail.com
Whole thread Raw
In response to BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed
Next
From: "David G. Johnston"
Date:
Subject: Re: Postgredb issue