PostgreSQL
How to Troubleshoot your PostgreSQL Connection?
A comprehensive guide to diagnosing and resolving common PostgreSQL connection issues while connecting PostgreSQL and Google Sheets using Superjoin.
Network Connection Refused
Network Connection Refused
Error Message: Please make sure that your database is running and you have whitelisted our IP address 34.100.193.122
Action Steps
1
Verify DB is running
Check Database Server: Ensure that your PostgreSQL server is actively running.
2
IP Whitelisting
Modify your PostgreSQL settings to include the IP address 34.100.193.122 in the whitelist, which may involve adjusting the pg_hba.conf file or firewall settings. More information on whitelisting here
3
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
Network Connection Not Found
Network Connection Not Found
Error Message: Unable to connect to the database, please make sure that your database URL is correct.
Action Steps
1
Verify
Double-check the database URL in your connection settings to ensure it is correct and properly formatted.
2
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
Incorrect Database Credentials
Incorrect Database Credentials
Error Message: Incorrect database credentials. Please verify the username and password.
Action Steps
1
Verify
Make sure that the username and password in your connection settings are accurate and correspond to what is configured on your PostgreSQL server.
2
Reset password
If necessary, reset the password for the user in PostgreSQL and update it in your connection settings.
3
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
Database Does Not Exist
Database Does Not Exist
Error Message: Database does not exist. Please verify the database name.
1
Verify db name
Confirm that the database name in your connection settings matches an existing database on your PostgreSQL server. This common issue occurs when the database name is misspelled or the database was not created. Here’s the command:
\l2
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
Connection Attempt Timed Out
Connection Attempt Timed Out
Error Message: Connection attempt timed out. Please try again later.
Action Steps
1
Verify liveness
Check if the PostgreSQL server is operational and not undergoing maintenance or downtime which could impede connections.
2
Whitelist IP
Ensure that the IP address 34.100.193.122 is added to the whitelist in your PostgreSQL settings, which may include modifying the pg_hba.conf file or adjusting firewall settings to allow the connection.
3
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
Connection Timeout Exceeded
Connection Timeout Exceeded
Error Message: Connection timeout exceeded. Please verify the host and port details.
Action Steps
1
Verify host & port
Double-check that the host and port information in your connection settings are correct and that the PostgreSQL server is actively listening on that host and port.
2
Firewall settings
Check to see if any firewall configurations are blocking the connection to the specified port.
3
IP Whitelisting
Confirm that the IP address 34.100.193.122 is whitelisted within your PostgreSQL settings, possibly requiring changes to the pg_hba.conf file or firewall configurations.
4
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
Maximum Connection Limit Reached
Maximum Connection Limit Reached
Error Message: Maximum connection limit reached. Please try again later
Action Steps
1
Close Unused Connections
Review the current connections to your PostgreSQL server and close any that are unused or stale to free up space for new connections.
2
Increase Max Connections
Consider adjusting the max_connections setting in your postgresql.conf file to increase the number of allowable concurrent connections, ensuring your server is equipped to handle the additional load.
3
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
IP Not Whitelisted
IP Not Whitelisted
Error Message: Unable to connect to the database. Please make sure that you have whitelisted our IP address 34.100.193.122
Action Steps
1
IP Whitelisting
Double-check your PostgreSQL configurations to ensure the IP address 34.100.193.122 is properly whitelisted. This may require adjustments in the pg_hba.conf file or firewall settings to allow the connection. More on this here
2
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
Unknown Error
Unknown Error
Error Message: An unknown error occurred while connecting to the database
Action Steps
1
Review Error Logs
Examine the PostgreSQL server logs for any clues or additional details regarding the error.
2
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
Incorrect Database URL
Incorrect Database URL
Error Message: Unable to connect to the database. Please make sure that your database URL is correct
Action Steps
1
Correct Host
Double-check the host entered in your connection settings to ensure it matches the server where your PostgreSQL database resides.
2
Reach Out for Support
If you’ve tried the above steps and still facing issues, don’t hesitate to contact us at support@superjoin.ai. We will respond immediately.
Summarising all the errors that you could face while connecting to your PostgreSQL DB
