Creating an Information Services data source to PostgreSQL throws an error similar to: "Cause: FATAL: no pg_hba.conf entry for host "[HOST]", user "[USERNAME]", database "[DATABASE NAME]", SSL off".
Article ID: KB0083483
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All Versions |
Description
Unable to connect to data source "/shared/PostgreSQL_Test" at
"jdbc:postgresql://10.107.162.198:5432/public". Make sure the URL information, user name and password are correct. [datasrc-3961025]
Cause: FATAL: no pg_hba.conf entry for host "10.107.162.176", user "postgres", database "public", SSL off
======================
Note: This may also occur when using the Spotfire data connector for PostgreSQL, but this has not been tested using the data connector.
The following is an example of a typical error:
The user needs explicit access to the PostgreSQL database when it is accessed from remote machines.
Issue/Introduction
Resolution
Make the following changes to the PostgreSQL configuration files to address this behavior. If this is for a customer's environment, ensure that they discuss these options with their Database Administrators (DBAs) first.
============================
1). Add or edit the following line in your "postgresql.conf" file:
listen_addresses = '*'
2). Add the following line as the first line of your "pg_hba.conf" file. It allows access to all databases for all users with an encrypted password:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
host all all 0.0.0.0/0 md5
3). Once you have added these changes, restart the database server service.
============================
Additional Information
Feedback
