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