PostGIS 14 connection error

[schelm9871]

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?

[schelm9871]

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

[David_McRitchie · Accepted solution]

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

[schelm9871]

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