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!
