From: | Stephen Carville <scarville(at)lereta(dot)com> |
---|---|
To: | "Daniel Serodio (lists)" <daniel(dot)lists(at)mandic(dot)com(dot)br> |
Cc: | Postgresql General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Cannot connect to remote postgres database |
Date: | 2013-07-03 22:17:36 |
Message-ID: | 51D4A300.3020908@lereta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/03/2013 01:30 PM, Daniel Serodio (lists) wrote:
> Stephen Carville wrote:
>> 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:
> If you want to evaluate PostgreSQL, you should evaluate v9.2. 8.4 is
> pretty ancient and lacks lots of cool features so your comparison won't
> be "fair" to PostgreSQL.
I figured it out.
I used tshark to capture the traffic. When I looked at the packets I
could see that I was asking for the wrong database!
This does not work:
# psql -h scadev02.lereta.com -U stephen
This does:
# psql -h scadev02.lereta.com -U stephen postgres
I guess it's always easy once you know the answer.
>> 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.."
> Which exact ALTER ROLE did you use? Feel free to redact the actual
> password, of course.
>> 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.
> "md5" is the standard. "password" is plain text (which you don't want)
> and "pam" will try to authenticate against OS users, which is probably
> not what you want.
>> Any hints on where to start looking?
> Is there any NAT happening between the client and the server? Check the
> server's log for a "LOG: connection received: host=x.x.x.x" message so
> you can check which IP is reaching the server.
>
> Regards,
> Daniel Serodio
>
>
--
Stephen Carville
Apprentice Cook and Bottle Washer
Lereta LLC
1-800-537-3821 X1326
From | Date | Subject | |
---|---|---|---|
Next Message | Ben Chobot | 2013-07-03 22:23:28 | async streaming and recovery_target_timeline=latest |
Previous Message | Stephen Carville | 2013-07-03 22:17:32 | Re: Cannot connect to remote postgres database |