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 | | Tel: +91 40 4444 1000 Extn: 3458  | Mobile: +91 994 947 0774 |  Sanjeeb.Rath@Infor.com|Q-City, 4th Floor | Nanakramguda Village, Serilingampally Mandal | Hyderabad-500032 | INDIA