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 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?
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 allow connections 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_DATA directory 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! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
