How to resolve the error 'Exception while connecting Error' while connecting to PostgreSQL Database

Troubleshooting ‘Exception while connecting Error’ in Bold BI

When attempting to connect to a PostgreSQL database server in Bold BI, you might encounter the error message: ‘Exception while connecting Error’. This article outlines the potential causes of this error and troubleshooting to resolve it.

Issue

The error ‘Exception while connecting Error’ occurs while connecting to a database server in Bold BI.

Possible Causes

1. Server may not be reachable: The server hosting the database might be down or not accessible from the network.
2. Invalid server/port: The server address or port number provided might be incorrect.

Solutions

1. Check IP Type

Private IP

• Network Configuration: If you are using a private IP or local IP to connect, ensure that both the Bold BI deployment and your database server are within the same network. Private IPs are only reachable within the same network.

Public IP

• Use Public IP: If the private IP is not reachable, try connecting using the public IP of the database server. Public IPs are accessible over the internet, provided there are no firewall or network restrictions.

2. Verify Server and Port

• Server Address: Double-check the server address to ensure it is correct.
• Port Number: Verify that the port number specified is the correct one for the database server.

3. Network Connectivity

• Ping Test: Perform a ping test to the server to check if it is reachable.
• Firewall Settings: Ensure that there are no firewall rules blocking the connection to the database server.

4. Database Server Status

• Server Uptime: Confirm that the database server is up and running.
• Service Status: Check that the database service is active and listening on the specified port.

Additional References

• Bold BI Documentation
• Bold BI support