Re: db connection fails - Mailing list pgsql-admin

From Nick Fankhauser
Subject Re: db connection fails
Date
Msg-id NEBBLAAHGLEEPCGOBHDGEEPDFDAA.nickf@ontko.com
Whole thread Raw
In response to db connection fails  (Mark Tessier <mt@open2web.com>)
Responses Re: db connection fails  (Mark Tessier <mt@open2web.com>)
List pgsql-admin
> > Have you tried doing a network connection with your "apache" user? (su -
> > apache; psql -h localhost group3.)
>
> Yes, I've tried it and get the following:
>
> psql: could not connect to server: Connection refused
>     Is the server running on host 192.168.1.2 and accepting
>     TCP/IP connections on port 5432?


This is a useful clue. It suggests that your code may be fine and that the
problem is in the networking or authentication setup. (You're using TCP/IP
even if you are on the same box.)

If you haven't already done so, take a look at your pg_hba.conf file. Info
on how to set it up can be found here:

http://www.postgresql.org/idocs/index.php?client-authentication.html

-Nick

--------------------------------------------------------------------------
Nick Fankhauser  nickf@ontko.com  Phone 1.765.935.4283  Fax 1.765.962.9788
Ray Ontko & Co.     Software Consulting Services     http://www.ontko.com/




pgsql-admin by date:

Previous
From: "Guthrie, John"
Date:
Subject: Re: pg_dumpall in crontab doesn't work
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall in crontab doesn't work