Re: Help with PostgreSQL Access

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Andrew Tuson <andy(at)forum(dot)demon(dot)co(dot)uk>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Help with PostgreSQL Access
Date: 2002-11-17 22:48:36
Message-ID: web-1830007@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2002-11-18 00:52:49 Re: Help with PostgreSQL Access
Previous Message Reshat Sabiq 2002-11-17 22:07:04 Re: Portability, was: using functions to generate custom error messages