From: Ravi Katkar 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@xxxxxxxxx|Q-City,
4th Floor | |