nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Does ArcGIS Pro 2.7 support operating system authentication with PostgreSQL?

JesseTemplin2

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!

Find more posts tagged with

Geodatabase

Desktop

Accepted answers

Robert LeClair

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.

All comments

Marcelo Marques

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

soniadickerson1

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.

soniadickerson1

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!

JesseTemplin2

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

Robert LeClair

George Thompson

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

JesseTemplin2

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?

danretired

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)

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.