Unable to create a Postgre Datasource from windows With Database installed in RHEL 5.3

________________________________
From: Ravi Katkar
Sent: Thursday, July 15, 2010 2:45 PM

Hi List ,

I have installed PostgreSQL server in RHEL 5.3. I can able to start the database and also able to work on the DB by creating tables etc. When I am trying to connect thru ODBC from windows machine to the database server installed in Linux its giving the following error:

No connection could be made because the target machine actively refusedit.

For resolving the same issue I changed the configuration file by adding the host machine and listen_address = '*', but the problem is I am unable to restart the server. Getting the below errors, Can anyone help me regarding this?

/etc/init.d/postgresql restart
Stopping postgresql service: [FAILED]

/var/lib/pgsql/data is missing. Use "service postgresql initdb" to initialize the cluster first.
[FAILED]

service postgresql initdb
Initializing database: mkdir: cannot create directory `/var/lib/pgsql/data/pg_log': File exists
[FAILED]

Thanks and regards,

Sanjeeb Rath | Technical Consultant | [cid:image001(dot)jpg(at)01CB243A(dot)93CBEF30] | Tel: +91 40 4444 1000 Extn: 3458 | Mobile: +91 994 947 0774 | Sanjeeb(dot)Rath(at)Infor(dot)com|Q-City, 4th Floor | Nanakramguda Village, Serilingampally Mandal | Hyderabad-500032 | INDIA