I am trying to register a PostgreSQL database with our ArcGIS Server v. 10.7. I get the following error message: "The connection property set was missing a required property or the property value was unrecognized. Instance not available on the server".
I can connect to the database fine from ArcCatalog on client machines, but I also get an error when I try and connect via ArcCatalog on the server: "Connection timed out. Is the server running on hose <postgresql db servername> and accepting TCP/IP connections on port 5432? SQLSTATE="
I have updated the pg_hba.conf to include the IP address of both the arcgis server and also the portal machine that has the web adaptor installed (our server is federated with Portal). I also confirmed that the postgreSQL login user that I am connecting with has the correct privileges and is the owner of a schema in the database, as per the ESRI documentation.
What am I missing that is preventing me from registering the database with the arcgis server?