laptop and a wrench

Bug

The primary portal and the standby portal are no longer accessible after the pg_hba.conf entries are commented out.

Last Published: November 21, 2019 Portal for ArcGIS
Bug ID Number BUG-000126198
SubmittedOctober 22, 2019
Last ModifiedFebruary 14, 2023
Applies toPortal for ArcGIS
Version found10.7.1
Version Fixed10.8.1
StatusFixed

Workaround

1.On primary Portal, open the pg_hba.conf and uncomment out the entries (Ex. C:\arcgisportal\db\pg_hba.conf). See below:

 

# IPv4 local connections:

host  all       portaladmin       127.0.0.1/32      md5

host  replication   portaladmin       127.0.0.1/32      md5

# IPv6 local connections:

host  all       portaladmin       ::1/128         md5

host  replication   portaladmin       ::1/128         md5)

 

host gwdb portaladmin portalPrimary.domain.com md5

host gwdb portaladmin portalStandby.domain.com md5

 

host gwdb portaladmin 10.151.10.25 md5

host gwdb portaladmin 10.151.10.26 md5

 

2. Reload Portal for ArcGIS database with the following command, in an administrator command prompt.

  • cd C:\Program Files\ArcGIS\Portal\framework\runtime\pgsql\bin
  • pg_ctl.exe reload -D C:\arcgisportal\db

 

3. Stop and start Portal for ArcGIS' internal database.

  • pg_ctl.exe stop -D C:\arcgisportal\db
  • pg_ctl.exe start -D C:\arcgisportal\db

 

4. You should now be able to access the primary Portal for ArcGIS.

 

5. Repeat Steps 1 through 3 for the standby Portal for ArcGIS.

Steps to Reproduce

Bug ID: BUG-000126198

Software:

  • Portal for ArcGIS

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic