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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bchen90(at)163(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed
Date: 2020-05-09 15:10:48
Message-ID: 3304.1589037048@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Thusitha Maheepala 2020-05-09 15:38:59 Re: Postgredb issue
Previous Message Rod Taylor 2020-05-09 15:09:10 Re: Postgredb issue