Re: Problem with PostgreSQL: unable to connect to database

This is pgadmin II log
what about a postmaster log ?
----- Original Message -----
From: Cheah Ai Meng
To: Igor Georgiev ; Pgsql-Cygwin
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 can't 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
http://gborg.postgresql.org/project/winmaster/projdisplay.php