ArcGIS Enterprise: Geodatabase Connection Properties: Bad login user

Error Message

Attempting to connect to a PostgreSQL database in ArcGIS Pro fails with the following error message returned:

Error:
Geodatabase Connection Properties: Bad login user [ ]

Cause

The pg_hba.conf file is not modified to allow other client machines, such as the client machine running ArcGIS Pro, to connect with the PostgreSQL database machine.

Solution or Workaround

1. On the server machine with the PostgreSQL database installed, navigate to the default PostgreSQL installation folder location:

C:\Program Files\PostgreSQL\<PostgreSQL version>\data\ pg_hba.conf

2. Add the client machine's IP address in the ADDRESS parameter to allow access to the PostgreSQL database. The following is an example:

#TYPE  DATABASE     USER    ADDRESS            METHOD

host   all          all     122.22.222.222/32   md5

Note:
On the IP address entry, add /32 at the end of the IP address if PostgreSQL cannot restart the services.

3. Restart the PostgreSQL Windows service to reflect the changes made on the machine. In the Windows search bar, search for and open Services.
4. Right-click the postgresql-x64-<version> - PostgreSQL Server <version> service, and click Restart.