PostgreSQL OS authentification username mapping trouble

NicolasRacine — Mon, 16 Oct 2023 19:10:36 GMT

Hello everyone! I have installed PostgreSQL 14.6 directly from the ESRI website and am now currently configuring it to use the operating system authentification to connect to the databases. Both the install and OS users are on Windows so I use SSPI for authentification

My pg_hba config looks something like this:

TYPE	DATABASE	USER	ADDRESS	METHOD
host	all	all	::1/128	sspi map=root

And my pg_ident config looks like this:

MAPNAME	SYSTEM-USERNAME	PG-USERNAME
root	john.smith@domain.com	postgres

I want the OS user to be connected as user postgres when the OS authentification is successful. When connecting directly in pgAdmin it works, but I have ran into an issue when trying to do the same in ArcGIS Pro. When trying to connect using the operating system authentification it tries to authenticate using the following:

SYSTEM-USERNAME	PG-USERNAME
john.smith@domain.com	john.smith

Since this entry does not exist in pg_ident the authentification fails. So my question is the following, is there a way to tell ArcGIS to connect as the user postgres using the OS authentification or do I have to create a new user for every person that needs access to the install?

Thanks in advance!

topic PostgreSQL OS authentification username mapping trouble in ArcGIS Pro Questions

PostgreSQL OS authentification username mapping trouble