Pb with CREATE DATABASE

=====================
Coordinateur O++ (tel 06 73 77 60 80)
Cueep (tel 03 20 58 11 30)

----- Original Message -----
From: Yves Deschamps
To: pgadmin-support(at)postgresql(dot)org
Sent: Friday, September 05, 2003 10:15 AM
Subject: Pb with CREATE DATABASE

Hi Dave,

I try this in psql (no parser error):
CREATE DATABASE BDE8IP WITH TEMPLATE = template1 ENCODING = 'LATIN1';
and I have this error:
CREATE DATABASE: could not initialize database directory; delete failed as well...
May be a problem of file system with XP ?
Thank you for your help...

______________
Hi,

Please use the pgadmin-support(at)postgresql(dot)org mailing list for future support requests.

Does the following work in psql?

CREATE DATABASE "BDE8IP" WITH TEMPLATE = template1 ENCODING = 'LATIN1'

Regards, Dave.
-----Original Message-----
From: Yves Deschamps [mailto:yves(dot)deschamps(at)univ-lille1(dot)fr]
Sent: 04 September 2003 15:36
To: dpage(at)pgadmin(dot)org
Subject: Pb with CREATE DATABASE

Hello,
When I try to create a new database, I have this msg:
ERROR: CREATE DATABASE: could not initialize database directory; delete failed as well
with this logs:
----------------------------------------
2003-09-04 16:24:19 - SQL (template1): SELECT version()
2003-09-04 16:24:19 - SQL (template1): SELECT datlastsysoid FROM pg_database WHERE datname = 'template1'
2003-09-04 16:24:19 - SQL (template1): SELECT oid, datname, datpath, datallowconn, pg_encoding_to_char(encoding) AS serverencoding, pg_get_userbyid(datdba) AS datowner FROM pg_database ORDER BY datname
2003-09-04 16:24:19 - SQL (template1): SELECT * FROM pg_group ORDER BY groname
2003-09-04 16:24:19 - SQL (template1): SELECT * FROM pg_user ORDER BY usename
2003-09-04 16:24:19 - SQL (template1): SELECT datname, procpid, usename, current_query FROM pg_stat_activity
2003-09-04 16:24:23 - SQL (template1): SELECT objoid, objsubid, description FROM pg_description
2003-09-04 16:24:23 - SQL (template1): SELECT datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit FROM pg_stat_database ORDER BY datname
2003-09-04 16:24:26 - SQL (template1): SELECT oid, * FROM pg_language ORDER BY lanname
2003-09-04 16:24:26 - SQL (template1): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc WHERE oid = 0::oid
2003-09-04 16:24:26 - SQL (template1): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc WHERE oid = 0::oid
2003-09-04 16:24:26 - SQL (template1): SELECT oid, *, pg_get_userbyid(proowner) as funcowner FROM pg_proc WHERE oid = 0::oid
2003-09-04 16:24:26 - SQL (template1): SELECT numbackends, xact_commit, xact_rollback, blks_read, blks_hit FROM pg_stat_database WHERE datname = 'template1'
2003-09-04 16:24:30 - SQL (template1): SELECT numbackends, xact_commit, xact_rollback, blks_read, blks_hit FROM pg_stat_database WHERE datname = 'template1'
2003-09-04 16:24:46 - SQL (template1): CREATE DATABASE "BDE8IP" WITH TEMPLATE = template1 ENCODING = 'LATIN1'

2003-09-04 16:24:46 - *******************************************************************
2003-09-04 16:24:46 - Error(s)
2003-09-04 16:24:46 - *******************************************************************
2003-09-04 16:24:46 - Error in pgAdmin II:frmDatabase.cmdOK_Click: -2147467259 - ERROR: CREATE DATABASE: could not initialize database directory; delete failed as well
2003-09-04 16:24:46 - The following error(s) have been logged:

...