Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

> 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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group