From: | mike(dot)blackwell(at)rrd(dot)com |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #9518: temporary login failure - "missing pg_hba entry" |
Date: | 2014-03-10 14:54:44 |
Message-ID: | 20140310145444.1230.51833@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
The following bug has been logged on the website:
Bug reference: 9518
Logged by: Mike Blackwell
Email address: mike(dot)blackwell(at)rrd(dot)com
PostgreSQL version: 9.3.3
Operating system: RHEL 6
Description:
The following sequence showed up in the error log recently:
2014-03-09 19:53:18 CDT [30632]: [2-1] username(at)databasename
10.17.x.y(53454)LOCATION: ClientAuthentication, auth.c:486
2014-03-09 19:53:18 CDT [30633]: [1-1] username(at)databasename
10.17.x.y(53455)FATAL: 28000: no pg_hba.conf entry for host "10.17.x.y",
user "username", database "databasename", SSL off
2014-03-09 19:53:18 CDT [30633]: [2-1] username(at)databasename
10.17.x.y(53455)LOCATION: ClientAuthentication, auth.c:486
2014-03-09 20:05:15 CDT [32505]: [1-1] username(at)databasename
10.17.x.y(54134)LOG: 00000: duration: 13641.600 ms execute dbdpg_p28498_2:
select ...;
2014-03-09 20:05:15 CDT [32505]: [2-1] username(at)databasename
10.17.x.y(54134)LOCATION: exec_execute_message, postgres.c:1991
The auth failure shows up seven times over a span of approximately six
seconds, with the one above being the last of the sequence.
This is on a server that has been running for quite a while. The last conf
reload was at the last Postgres restart on 3/1. The pg_hba.conf file
timestamps indicate no recent change as well.
This may not be a PostgreSQL bug but I'm running out of other explanations.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2014-03-10 14:58:59 | Re: BUG #9518: temporary login failure - "missing pg_hba entry" |
Previous Message | Jaime Casanova | 2014-03-10 14:54:15 | Re: [BUGS] BUG #9479: Perdida de información |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2014-03-10 14:58:59 | Re: BUG #9518: temporary login failure - "missing pg_hba entry" |
Previous Message | Andrew Dunstan | 2014-03-10 14:50:45 | Re: jsonb and nested hstore |