Seeing "no pg_hba.conf entry for host" errors in Postgres and they come from an IP address that I don't recognize #26282
Locked
sudayavarman
announced in
Troubleshooting
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
"FATAL: no pg_hba.conf entry for host" errors indicate that there was a failed authentication attempt to the database, so the connection couldn't be established.
The authentication failed because the user/password credentials were invalid:
(user "xxxx", database "yyyy")
. This could happen if you're trying to connect to the database using wrong or revoked credentials. These errors indicate a failed login attempt was made to your database, meaning the connection wasn't established.It is common to see failed connection attempts that use default usernames (such as
user "pgbouncer"
,database "postgres"
). Being on the public internet means some level of unauthorized access attempts are possible. These are very unsophisticated attempts that usually involve trying combinations like root, psql, test and postgres usernames.Supabase takes security seriously and works diligently to ensure the safety of your data.
Beta Was this translation helpful? Give feedback.
All reactions