Re: Application trying to use wrong user when logging into the database

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Sunday, March 28th, 2021 at 15:00, Bzzzz <lazyvirus@gmx.com> wrote:

> On Sun, 28 Mar 2021 13:44:59 +0000
> 

> Simon Connah simon.n.connah@protonmail.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

Thank you for your reply. My pg_ident.conf file is completely empty (well all commented out at least). Do you really need to map a Linux system user to a PostgreSQL role to get this to work? Seems like a bit of a hack to me. I'm probably missing something simple again. I don't need external access to the database at the moment, although it is helpful knowledge to have for the future.

This is all on my local machine so I've set pg_hba.conf to md5 for 127.0.0.1/32 which I assumed would just make it work.

Simon.