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!