Cannot connect to remote postgres database

From: Stephen Carville <scarville(at)lereta(dot)com>
To: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Cannot connect to remote postgres database
Date: 2013-07-03 20:11:35
Message-ID: 51D48577.9070202@lereta.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have been asked to evaluate Oracle, mysql and postgresql as a possible
replacement for our existing Oracle and MsSQL databases. Oracle and
mysql I pretty much have covered. Postgresql, OTOH, is somewhat less
cooperative.

I have the software (v 8.4.13) installed on 64 bit Centos 6. It is
listening on all available interfaces and netstat confirms this. I
created an additional user for the postgres db:

postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+-------------+-----------
postgres | Superuser | {}
: Create role
: Create DB
stephen | Superuser | {}
: Create role
: Create DB

I assigned passwords using "alter role etc.."

The problem is that no authentication method except trust seems to work.

in pg_hba.conf:

local all all trust
host all all 198.204.114.0/24 md5

I've tried both of the above users and get the same error each time:

psql: FATAL: password authentication failed for user "<username>"

I tried changing "md5" to "password" and "pam" without success. Onlt
"trust" works As near as I can tell by reading the documentation, it is
setup correctly but I have, obviously, done something wrong.

Any hints on where to start looking?

--
Stephen Carville
Apprentice Cook and Bottle Washer
Lereta LLC
1-800-537-3821 X1326

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Serodio (lists) 2013-07-03 20:30:19 Re: Cannot connect to remote postgres database
Previous Message David Johnston 2013-07-03 19:32:35 Feature Idea: Statement Echo in DO$$