________________________________ 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.jpg@01CB243A.93CBEF30] |
Tel: +91 40 4444 1000 Extn: 3458 | Mobile: +91 994 947 0774 |
sanjeeb.r...@infor.com|Q-City, 4th Floor | Nanakramguda Village,
Serilingampally Mandal | Hyderabad-500032 | INDIA
<<inline: image001.jpg>>
