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

--_004_46AC8D44F3AE1F4888F137837D0DF63508853ED287INHYWEXMB2i nf_
Content-Type: multipart/alternative;
boundary="_000_46AC8D44F3AE1F4888F137837D0DF63508853ED287INH YWEXMB2inf_"

--_000_46AC8D44F3AE1F4888F137837D0DF63508853ED287INHYWEXMB2i nf_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable



________________________________
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 dat=
abase and also able to work on the DB by creating tables etc. When I am try=
ing to connect thru ODBC from windows machine to the database server instal=
led 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 =3D '*', 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 initiali=
ze 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=
ath@Infor.com|Q-City, 4th Floor | Nanakramguda Village, Serilingampally Man=
dal | Hyderabad-500032 | INDIA


--_000_46AC8D44F3AE1F4888F137837D0DF63508853ED287INHYWEXMB2i nf_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" xmlns=3D"http://ww=
w.w3.org/TR/REC-html40">




namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"countr=
y-region"/>
name=3D"PlaceType"/>
name=3D"PlaceName"/>
name=3D"place"/>