[pgadmin-support] Pb with CREATE DATABASE

[Yves Deschamps]

===================== Coordinateur O++ (tel 06 73 77 60 80) Cueep (tel 03 20 58 11 30) ----- Original Message ----- From: Yves Deschamps To: [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: 04 September 2003 15:36 To: [EMAIL PROTECTED] 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:    ...