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:      [email protected]
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

--
Sent via pgsql-bugs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
  • [BUGS] BU... Can not create DB by 'createdb.exe' when DB 'postgres' is droped
    • Re: ... Kevin Grittner
      • ... John R Pierce
    • Re: ... Craig Ringer

Reply via email to