topic Re: Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL? in ArcGIS Pro Questions

Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL?

JesseTemplin2 — Wed, 03 Feb 2021 03:39:57 GMT

I have found an older post and documentation for Dasktop10.2, indicating it is unsupported or not recommended. The menu option is available in ArcGIS Pro, but I haven't been able to get it to connect. It's quite possible I'm doing something wrong. But before I spin my wheels too much, can anyone confirm or deny that OS authentication is fully supported for PostgreSQL?

Thanks!

Re: Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL?

DanPatterson — Wed, 03 Feb 2021 04:19:34 GMT

don't use it so I don't know, but your links are for old help topics, but PostgreSQL has lots of links.

Did you see these?

Database connections in ArcGIS Pro—ArcGIS Pro | Documentation

Connect to PostgreSQL from ArcGIS—ArcGIS Pro | Documentation

Search Result | Documentation (arcgis.com)

Re: Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL?

JesseTemplin2 — Wed, 03 Feb 2021 19:41:02 GMT

Thanks for the newer info. No mention of OS authentication in the first two links though. They just say choose database authentication (in bold). Should I interpret that to mean do not choose operating system authentication?

Re: Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL?

George_Thompson — Wed, 03 Feb 2021 20:23:17 GMT

I would contact Esri Technical support to see if there is any updated information or an enhancement for this capability.

Re: Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL?

Robert_LeClair — Wed, 03 Feb 2021 20:35:01 GMT

From what I've read internally is that OS authentication is not supported when connected to PostgreSQL databases. There is ENH-000132328 to update the documentation to be more explicit about what's supported/not supported. And ENH-000119762 to enable fully support of OS authentication on PostgreSQL databases, such as allowing OS login name contains special characters. Hope this helps.

Re: Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL?

JesseTemplin2 — Wed, 03 Feb 2021 20:46:23 GMT

Thanks Robert! Not the answer I was hoping for, but at least I can focus my attention elsewhere now.

Re: Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL?

soniadickerson1 — Mon, 24 Jan 2022 23:53:47 GMT

Regarding special characters in the login name, do you know if using mapping in the postgresql pg_ident.conf would work? I see some examples in some recordings like this one ( https://www.youtube.com/watch?v=GWb7t8J73Fc ) and have attempted it but can't get it to work yet.

Example of a mapping in pg_ident:

# MAPNAME SYSTEM-USERNAME PG-USERNAME

SSPI XWikiDBOwner@youraddress postgres

Then a reference is placed in the pg_hba.conf file

host all postgres 127.0.0.1/32 sspi map=SSPI

Thanks for any insight!

Re: Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL?

soniadickerson1 — Tue, 25 Jan 2022 22:32:08 GMT

I was able to get this to work for postgresql 13 - had to look in the postgresql log files to see what the actual domain was. Then once it was added to the pg_ident file, I was able to connect using operating system authentication. Grants and permissions needed to be handled via a sql script but it does work.

Re: Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL?

MarceloMarques — Fri, 15 Dec 2023 22:10:46 GMT

FYI: community.esri.com - white paper - How to Configure Windows Authentication for the PostgreSQL Enterprise Geodatabase. - Esri Community