Unable to Update Plugin Due to 'FATAL no pg_hba.conf entry' in PostgreSQL
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
Unable to update any plug-in using Universal Plugin Manager with the message: "An unexpected error occurred. Please refer to the logs for more information."
The following appears in the atlassian-confluence.log:
1
2
3
ERROR [http-8080-3] [atlassian.config.bootstrap.DefaultAtlassianBootstrapManager] getTestDatabaseConnection Could not successfully test your database:
-- referer: http://localhost:8080/setup/setupstandarddb-start.action?database=postgresql | url: /setup/setupstandarddb.action | userName: anonymous | action: setupstandarddb
org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host "xxx.xxx.xxx.xxx", user "confluence", database "confluence", SSL off
Cause
PostgreSQL has a list of allowed IP (configured in pg_hba.conf) that allow access to the database server. There is a missing entry for the host.
Resolution
Edit the pg_hba.conf file and add an entry to the Confluence server IP:
1
2
3
4
5
6
7
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
host confluence confluence xxx.xxx.xxx.xxx md5
# IPv6 local connections:
host all all ::1/128 md5
Was this helpful?