Re: Postgres errors in Drupal install.

On Sunday, June 26, 2011 12:36:59 pm Dave Coventry wrote:
> I'm having huge problems with a Drupal install using Postgres 8.4.8.
>
> I'm getting the following error:
>
> PDOException: SQLSTATE[08006] [7] could not connect to server:
> Connection refused Is the server running on host "localhost" and
> accepting TCP/IP connections on port 5432? in lock_may_be_available()
> (line 164 of /var/www/includes/lock.inc).
>
> The Site is under minimal load with possibly two or three people on it at
> once.
>
> Can anyone tell me why I get the error every hour or so?

A user or machine is not authorized in pg_hba.conf?

>
> And what steps I could take to remedy this?

Look at pg_hba.conf.  Look at the Drupal/Postgres logs to try to see who or what
is trying to connect at those times.

>
> Many thanks,
>
> Dave Coventry

--
Adrian Klaver
adrian.klaver@gmail.com