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 [at] 01CB243A.93CBEF30] =
| Tel: +91 40 4444 1000 Extn: 3458 | Mobile: +91 994 947 0774 | Sanjeeb.R=
ath [at] 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

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
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">

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<o:SmartTagType
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" name=3D"countr=
y-region"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceType"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceName"/>
<o:SmartTagType namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>

<style>

</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<o:p> </o:p>

<o:p> </o:p>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</div>

</div>

From: Ravi Kat=
kar 
Sent: Thursday, July 15, 201=
0 2:45
PM 
 


Hi List =
,<o:p></o:p>

<o:p> </o:p>

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 et=
c.
When I am trying to connect thru ODBC from windows machine to the database =
server
installed in Linux its giving the following error: <o:p></o:p></font=
>

<o:p> </o:p>

No connection could be made because th=
e
target machine actively refusedit.<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

<o:p> </o:p>

For resolving the same issue I changed the configurati=
on
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?<o:p></o:p>

<o:p> </o:p>

/etc/init.d/postgresql restart<o:p></o:p></font=
>

Stopping postgresql
service: &=
nbsp; &nbs=
p;
[FAILED]<o:p></o:p>

<o:p> </o:p>

/var/lib/pgsql/data is missing. Use "service
postgresql initdb" to initialize the cluster first.<o:p></o:p><=
/font>

 =

 &nb=
sp; =
 [FA=
ILED]<o:p></o:p>

<o:p> </o:p>

service postgresql initdb<o:p></o:p>

Initializing database: mkdir: cannot create directory
`/var/lib/pgsql/data/pg_log': File exists<o:p></o:p>

 =
 &nb=
sp; =
 &nb=
sp;
[FAILED]<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

<o:p> </o:p>

Thanks and regards, <o:p></o:p>

<o:p> </o:p>

Sanjeeb Rath | Technical Consultant
| <img width=3D65 height=3D17 id=3D"_x0000_i1025"
src=3D"cid:image001.jpg [at] 01CB243A.93CBEF30">| Tel: +91 40 4444 1000 Extn:
3458 | Mobile: +91 994 947 0774 | Sanjeeb.Rath [at] Infor.com|Q-City=
,
4th Floor | <U1:PLACENAME u2:st=3D"on"><U3:PLACENAME w:st=3D"on"><st1:=
PlaceName
w:st=3D"on">Nanakramguda</U3:PLACENAME></U1:PLACENAME></st1:PlaceName> <U1:=
PLACETYPE u2:st=3D"on"><st1:PlaceType
w:st=3D"on">Village</U1:PLACETYPE></st1:PlaceType>, Serilingampally
Mandal | Hyderabad-500032 | <U1:COUNTRY-REGION u2:st=3D"on">=
<U1:PLACE u2:st=3D"on"><U4:PLACE w:endInsDate=3D"2010-06-24T10:15:00Z" w:en=
dInsAuthor=3D"rganotra" w:insDate=3D"2010-06-24T10:15:00Z" w:insAuthor=3D"r=
ganotra"><U4:COUNTRY-REGION w:endInsDate=3D"2010-06-24T10:15:00Z" w:endInsA=
uthor=3D"rganotra" w:insDate=3D"2010-06-24T10:15:00Z" w:insAuthor=3D"rganot=
ra"><st1:place
w:st=3D"on"><st1:country-region w:st=3D"on">INDIA</U4:COUNTRY-REGION></U4:P=
LACE></U1:PLACE></U1:COUNTRY-REGION></st1:country-region></st1:place><o:p><=
/o:p>

<o:p> </o:p>

</div>

</body>

</html>

--_000_46AC8D44F3AE1F4888F137837D0DF63508853ED287INHYWEXMB2i nf_--

--_004_46AC8D44F3AE1F4888F137837D0DF63508853ED287INHYWEXMB2i nf_
Content-Type: image/jpeg; name="image001.jpg"
Content-Description: image001.jpg
Content-Disposition: inline; filename="image001.jpg"; size=1140;
creation-date="Thu, 15 Jul 2010 16:27:12 GMT";
modification-date="Thu, 15 Jul 2010 16:27:12 GMT"
Content-ID: <image001.jpg [at] 01CB243A.93CBEF30>
Content-Transfer-Encoding: base64

/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsL DBkSEw8UHRofHh0a
HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgN DRgyIRwhMjIyMjIy
MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/ wAARCAARAEEDASIA
AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAA AgEDAwIEAwUFBAQA
AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcY GRolJicoKSo0NTY3
ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKT lJWWl5iZmqKjpKWm
p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP0 9fb3+Pn6/8QAHwEA
AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQA AQJ3AAECAxEEBSEx
BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2 Nzg5OkNERUZHSElK
U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOk paanqKmqsrO0tba3
uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMB AAIRAxEAPwD3a/1C
z0uze8v7mO3tkKq0sjYUFmCjJ9yQPxqG81vS9P1C0sLy/t7e6u8/Z4pXCmXG Mhc9TyOKzPHOgXPi
fwheaRZyQxzzPCytMSFASVHOcAnop7daz/FXgW28W+JtLutSht7jS7a1uIZo ZCwcs+3ay46Y2nnI
IoA6i61Kysbi1gurqKGW7kMVujtgyNgnA98CvJtc8feI9Q8aJpmmWPibS7SK y854YdKgmuJHMhXf
h2IEeBgEHOc8VrL8NdasvE2hS23iKS90LTLk3CWuoEtND8pG1HA+Yc8A4wK6 tdAuR8RpPEXmQ/ZG
0lbER5O/eJmfOMYxgjvnPagBw8SaTokaafq2vwzX0ACzSSBVZmPTKqMAnI49 6vWfiDSL+0ubq21G
3kgtQTPJvwIgBnLZ6DHOawv7F8RWGrancacmizwXlwJlN35gkXgAg7QRxziq c3g/Wb7RvFkd3Lp8
d7rdssUaQs5hjKxlBklcgHI7Hv8ASs1KV9jrnSoqm5KWtl166XVradfuLv8A wtLwP/0Mtj/30f8A
CuqgnhureO4t5Y5oZVDxyRsGV1PIII4IPrXmT/CrVY/DP2O28X363i2giSNh H5AcLjGQm7bnjPXF
d94d0s6L4a0zSyEDWlrHC2xiy7lUA4JwSM57CtDkNOiiigAooooAKKKKACii igAooooAKKKKAP/Z

--_004_46AC8D44F3AE1F4888F137837D0DF63508853ED287INHYWEXMB2i nf_--