This is pgadmin II log
what about a postmaster log ?
----- Original Message -----
Sent: Thursday, January 23, 2003 10:06 AM
Subject: RE: [CYGWIN] Problem with PostgreSQL: unable to connect to database
2003-01-23 16:35:17 - *******************************************************************
2003-01-23 16:35:17 - Error(s)
2003-01-23 16:35:17 - *******************************************************************
2003-01-23 16:35:17 - Error in pgAdmin II:frmConnect.cmdConnect_Click: -2147467259 - Could not connect to the server;
Could not connect to remote socket.
2003-01-23 16:35:17 - Windows Version: Windows 2000 v5.0 build 2195 Service Pack 3
2003-01-23 16:35:17 - pgSchema Version: 1.4.12
2003-01-23 16:35:17 - MDAC Version: 2.5
2003-01-23 16:35:17 - cnPostgreSQL.State = adStateClosed
Ooops what is this?
initdb: The directory /usr/local/pgsql/data exists but is not empty.
If you want to create a new database system, either remove or empty the directory /usr/local/pgsql/data or run initdb with an argument other than /usr/local/pgsql/data.
This is the response that I see when I typed in initdb -D /usr/local/pgsql/data to initialize the database. I cant figure out what is wrong
Thanks again!
Regards,
Aiming
Did u try to delete /usr/local/pgsql/data and start initdb again?
Did u have this folders?
/usr/local/pgsql/data
- /usr/local/pgsql/data/base
- /usr/local/pgsql/data/base/1
- /usr/local/pgsql/data/base/16975 - or something like this
And take a look here - this is a windows console 4 PostgreSQL