topic Re: PostGIS 14 connection error in ArcGIS Pro Questions

PostGIS 14 connection error

schelm9871 — Tue, 25 Jul 2023 17:16:43 GMT

When I try to connect to my PostGIS-Database, I always get error messages.

Information

- ArcGIS Pro Version: 3.1.2
- Postgres Version: 14.7
- PostGIS Version: 3.3
- The database is not a registered Enterprise database. I just want to read data.
- The database is hosted here: https://www.cloudclusters.io
- Connecting to the database from QGIS/pgAdmin works
- I tried to connect with a superuser and a read-only-user
- the database-name consists of only lowercase letters (see https://community.esri.com/t5/arcgis-pro-questions/postgis-connection-error/m-p/1171653 )

In the Instance Field I tried with this schema: Server="serveradress";Port="port" which returned the error "Server Machine not Found"

When I try with this schema "serveradress";"port" I get the error shown in the picture: "Invalid Connection Property"

Any ideas where the problem could be?

Re: PostGIS 14 connection error

schelm9871 — Tue, 25 Jul 2023 17:26:24 GMT

Sorry for the misleading title, "Postgres 14 connection error" would have been correct.

Re: PostGIS 14 connection error

David_McRitchie — Wed, 26 Jul 2023 11:52:54 GMT

Hey can we just confirm if the following documentation has been used? From checking this it could maybe be the instance name not being enclosed in square brackets if an ivp6 address is being used.

David

Re: PostGIS 14 connection error

schelm9871 — Wed, 26 Jul 2023 16:12:27 GMT

As a matter of fact I did not read it properly. Changing the ; to a , solved the issue.