Hello good people I have this error if someone can assist.
Service check errored with exception 'InternalError('PL/Proxy function public.delete_blob_meta(1): [commcarehq_p1] PQconnectPoll: connection to server at "127.0.0.1", port 6432 failed: FATAL: password authentication failed
Please also refer to attached screenshot.
I have checked /etc/pgbouncer/userlist.txt and all the users in the list are able to connect to pgbouncer. I am trying to find where the blobdb is getting its credentials to connect to pgbouncer but I am not able to find it please assist on where to check or how to sort the problem out I am seriously missing out something.
Your assistance will be greatly appreciated.