On Sun, 28 Mar 2021 13:44:59 +0000
Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com> wrote:
Hi,
> But instead of using my
> applications role which I created in PostgreSQL it is trying to use my
> Linux user name "simon" and is failing authentication because of it.
> I'm just confused at the moment. At no point in time have I created a
> role called "simon" and I have never tried to connect to any of my
> databases using the role name "simon", so why is it trying to
> authenticate as "simon"?
Read this and check you're not in this case :
https://www.dbrnd.com/2016/12/postgresql-pg_ident-conf-to-map-operating-system-username-and-database-username-external-authentication-password/
Jean-Yves