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

From Tom Lane
Subject Re: BUG #16426: In active/hot standby mode, create database and drop template databases cause standby restart failed
Date
Msg-id 3304.1589037048@sss.pgh.pa.us
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
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 by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Postgredb issue
Next
From: Thusitha Maheepala
Date:
Subject: Re: Postgredb issue