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