Pb with CREATE DATABASE - Mailing list pgadmin-support
| From | Yves Deschamps |
|---|---|
| Subject | Pb with CREATE DATABASE |
| Date | |
| Msg-id | 002d01c3738a$3faed790$5883ce86@pccompta88 Whole thread Raw |
| List | pgadmin-support |
=====================
Coordinateur O++ (tel 06 73 77 60 80)
Cueep (tel 03 20 58 11 30)
Coordinateur O++ (tel 06 73 77 60 80)
Cueep (tel 03 20 58 11 30)
----- Original Message -----
From: Yves Deschamps
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@postgresql.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.deschamps@univ-lille1.fr]
Sent: 04 September 2003 15:36
To: dpage@pgadmin.org
Subject: Pb with CREATE DATABASEHello,When I try to create a new database, I have this msg:ERROR: CREATE DATABASE: could not initialize database directory; delete failed as wellwith 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:...
pgadmin-support by date: