Unable to Update Plugin Due to 'FATAL no pg_hba.conf entry' in PostgreSQL
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
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
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.
pg_hba.conf file and add an entry to the Confluence server IP:
# 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