Date: Sun, 28 Mar 2021 16:00:04 +0200
From: Bzzzz <lazyvirus@gmx.com>
To: pgsql-novice@lists.postgresql.org
Cc: Simon Connah <simon.n.connah@protonmail.com>
Subject: Re: Application trying to use wrong user when logging into the
 database
Message-ID: <20210328160004.58d5426d@msi.defcon1.lan>
In-Reply-To: 
 <Wt5eqfXFsGBGpT6_-YFFDGuTpOheH21XUc2vodexpEarm11iuomdcCPCOhtJvUnMg35WVoWz72d7tpMmyvdJN-3WGqayIThKQlAFyxVrKRU=@protonmail.com>
References: 
 <Wt5eqfXFsGBGpT6_-YFFDGuTpOheH21XUc2vodexpEarm11iuomdcCPCOhtJvUnMg35WVoWz72d7tpMmyvdJN-3WGqayIThKQlAFyxVrKRU=@protonmail.com>
Organization: Anyone, anywhere BUT in banana demokratik republik of france
 and UERSS.
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/20210328160004.58d5426d%40msi.defcon1.lan>
Precedence: bulk

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