Re: Help with PostgreSQL Access - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Help with PostgreSQL Access
Date
Msg-id web-1830007@davinci.ethosmedia.com
Whole thread Raw
In response to Help with PostgreSQL Access  (Andrew Tuson <andy@forum.demon.co.uk>)
List pgsql-novice
Andrew,

> Connection to database failed
> could not connect to server: Connection refused
> Is the server running on host localhost and
> accepting TCP/IP connections on port 5432?

Was postmaster started with the "-i" option, allowing postgres to
accept connections via TCP/IP?   This is the usual cause for that
particular error message.

PSQL will work via UDP, but not PGAccess or PHPPgAdmin.  A quick test
would be to try to connect to your database from another machine using
PSQL; if you get the exact same message, you don't have "-i" set.

-Josh Berkus

pgsql-novice by date:

Previous
From: "Reshat Sabiq"
Date:
Subject: Re: Portability, was: using functions to generate custom error messages
Next
From: Oliver Elphick
Date:
Subject: Re: Help with PostgreSQL Access