Skip site navigation (1) Skip section navigation (2)

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

From: Ravi Katkar <Ravi(dot)Katkar(at)infor(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>,"'pgsql-odbc(at)postgresql(dot)org'" <'pgsql-odbc(at)postgresql(dot)org'>
Subject: Unable to create a Postgre Datasource from windows With Database installed in RHEL 5.3
Date: 2010-07-15 10:57:11
Message-ID: 46AC8D44F3AE1F4888F137837D0DF63508853ED287@INHYWEXMB2.infor.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc

________________________________
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(dot)jpg(at)01CB243A(dot)93CBEF30] | Tel: +91 40 4444 1000 Extn: 3458  | Mobile: +91 994 947 0774 |  Sanjeeb(dot)Rath(at)Infor(dot)com|Q-City, 4th Floor | Nanakramguda Village, Serilingampally Mandal | Hyderabad-500032 | INDIA

Responses

pgsql-odbc by date

Next:From: Alban HertroysDate: 2010-07-15 11:11:47
Subject: Re: Unable to create a Postgre Datasource from windows With Database installed in RHEL 5.3
Previous:From: Hiroshi InoueDate: 2010-07-09 13:13:30
Subject: Re: [GENERAL] 'default nextval()' loses schema-qualification in dump ?

pgsql-general by date

Next:From: Alban HertroysDate: 2010-07-15 11:11:47
Subject: Re: Unable to create a Postgre Datasource from windows With Database installed in RHEL 5.3
Previous:From: Tim LandscheidtDate: 2010-07-15 10:23:10
Subject: Re: coalesce seems to give strange results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group