Re: BUG #6252: After drop the default database 'postgres', I can not create a database by 'createdb.exe'

On 10/12/2011 02:48 PM, Can not create DB by 'createdb.exe' when DB
'postgres' is droped wrote:
>
> The following bug has been logged online:
>
> Bug reference:      6252
> Logged by:          Can not create DB by 'createdb.exe' when DB 'postgres'
> is droped
> Email address:      yanghui328@gmail.com
> PostgreSQL version: 9.0.5
> Operating system:   Windows XP SP2
> Description:        After drop the default database 'postgres', I can not
> create a database by 'createdb.exe'
> Details:
>
> 1.drop database 'postgres'
> 2.create a database by createdb.exe
> the follow error message will dispaly:
> Can not create DB by 'createdb.exe' when database 'postgres' is droped

Yep. You need to use a `CREATE DATABASE' command from psql to re-create
the `postgres' database after connecting to the "template1" database, eg:

template1=> CREATE DATABASE postgres WITH OWNER postgres;

--
Craig Ringer