topic Re: PostGIS connection error in ArcGIS Pro Questions

PostGIS connection error

GuillermoDAngelo — Fri, 06 May 2022 19:55:30 GMT

I'm not able to connect to a PostGIS DB with ArcGIS Pro, event though I'm able to connect with QGIS, DBeaver and other clients, with same parameters and credentials. What's happening?

I receive this error:

Re: PostGIS connection error

Robert_LeClair — Fri, 06 May 2022 20:09:39 GMT

Is the database in question named with all capital letters? If so, recreate the database with the name all lower case and try to make the connection. What is the result?

Re: PostGIS connection error

GuillermoDAngelo — Wed, 11 May 2022 14:57:25 GMT

Thanks. I didn't try that but tried to connect to an all lowercase DB (the initial is camel case), and it connected without issues. How I can get ArcGIS Pro to connect to a Postgres DB with capital letter in its name?

Using double quotes also failed.

Re: PostGIS connection error

George_Thompson — Wed, 11 May 2022 15:05:02 GMT

It is not supported; https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/setup-geodatabase-postgresql-windows.htm

Under the "Create Enterprise Geodatabase" section:

Type the database name in lowercase; upper- and mixed-case object names are not supported for geodatabases in PostgreSQL. If you type a database name in upper or mixed case, ArcGIS converts it to lowercase.

Re: PostGIS connection error

GuillermoDAngelo — Wed, 11 May 2022 15:09:18 GMT

Thanks! Very weird though.

Re: PostGIS connection error

JoabelBarbieri — Tue, 13 May 2025 15:21:36 GMT

Same problem here. DB name was created in uppercase. No way I can recreate it. what to do?