I've changed postgres user password and we started getting error: db=postgres,user=postgres FATAL: password authentication failed for user "postgres"

It happens each second. Our log

I still can't figure it out which service tries to reach our SQL instance with this account. I tried to set a password we only have, which could be previous one, but it didn't help us.

Did anyone faced the similar situation? Who knows how to fix it?

Thanks in advance for any assistance.

Best regards, Alexey

CodePudding user response：

If your database is accessible to the internet, then people will try to log into it. That is how things are. You can't police the world.

Their attempts are failing. So you can just enjoy watching them beat their heads against a wall. If you don't like the log spam, or if you are afraid you will absent-mindedly set your password to 'b@seb@ll12' someday, you can change your firewall to block the attempts. You could probably configure logging to log ip addresses too (or, if it is already logged, then inspect that part of the log, which you don't seem to be doing now).

CodePudding user response：

Change pg_hba.conf auth-method in order to request the password, when set.