Thread: Unable to create a Postgre Datasource from windows With Database installed in RHEL 5.3
Unable to create a Postgre Datasource from windows With Database installed in RHEL 5.3
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 | | Tel: +91 40 4444 1000 Extn: 3458 | Mobile: +91 994 947 0774 | Sanjeeb.Rath@Infor.com|Q-City, 4th Floor | Nanakramguda Village, Serilingampally Mandal | Hyderabad-500032 | INDIA
Attachment
Re: Unable to create a Postgre Datasource from windows With Database installed in RHEL 5.3
On 15 Jul 2010, at 12:57, Ravi Katkar wrote: > 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 creatingtables etc. When I am trying to connect thru ODBC from windows machine to the database server installed in Linuxits 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 = ‘*’, butthe problem is I am unable to restart the server. Getting the below errors, Can anyone help me regarding this? That's only half of the solution. It is listening to TCP/IP connections now, but you didn't edit pg_hba.conf yet to allowconnections from your windows machine. I don't think this has anything to do with ODBC (hence I removed the recipient). > > /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 Did you run those commands as a user with sufficient privileges (usually root)? The script obviously knows where the PG_DATAdirectory is supposed to be, and according to initdb it is there - which is why I think you don't have access. It looks like postgres failed to stop (probably due to lack of permissions for you to do so). Is it indeed still running? Alban Hertroys -- Screwing up is an excellent way to attach something to the ceiling. !DSPAM:737,4c3eed06286219829316871!