Skip to main content

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.

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.

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.

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: \l
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.

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.

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.

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

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.

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.

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

I