Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Postgres issue - password authentication failed

Not applicable

Hi all. We have an issue with portgres. Here are the facts:

  • Recent traffic data is not appearing in the dashboard (older data, however, is)
  • We have a postgres master/slave setup
  • All Qpid and postgres components are up and running
  • On the first postgres node, the logs show an error: password authentication failed (full detail below)
  • As a test, I created a connection to postgres manually, and entered the password. It worked fine.

Does anyone have any idea why there is a message complaining about password authenticaton (which may be related to missing dashboard data), but the password seems accepted if input manually?

Thanks,

Stewart

Full log lines:

2017-09-07 13:24:36 UTC [19348]: [1-1] user=apigee db=apigee host=10.141.136.4 FATAL: password authentication failed for user "apigee"

2017-09-07 13:24:36 UTC [19348]: [2-1] user=apigee db=apigee host=10.141.136.4 DETAIL: Connection matched pg_hba.conf line 84: "host all all 0.0.0.0/0 md5"

1 4 1,772
4 REPLIES 4