Select to view content in your preferred language

Increase or remove username field character limit for PostgreSQL

2358
6
12-09-2021 10:30 AM
Status: Open
Labels (1)
DavidMcDermott1
Occasional Contributor

When creating a database connection for PostgreSQL, the username field has a limit of 30 characters. This is particularly frustrating when trying to connect to PostgreSQL on Azure as the username format needs to be ‘user@host’. This limit needs to be increased or removed. 

6 Comments
TimMollison_infra

A similar constraint applies to the username for SQLServer connections using Azure Active Directory (available in ArcGIS Pro v3.0.0) where "@domain" is part of the username. Our domain is over 20 chars and usernames are in the form firstname.lastname and so only people with short names like 'john.doe' are able to connect.

BrianCunningham001

Is there a workaround for this?

CDischinger

Why are we still facing this issue?

LisaZygo

Please help get this issue resolved as we're facing it with Azure SQL

GerardoGarcia

I don't think this is just specific to PostgreSQL. It looks to be a limitation of Pro, which is disappointing to say the least. And this post has basically gone unanswered since 2021? A tool like SQL Server Management Studio works without this issue. Why is ESRI software still behind?

PaulSanders

We need this character limit to be addressed. Causes a huge problem for organizations utilizing cloud platform databases like Azure SQL.