Unable to Connect to PostgreSQL Database Externally Despite Access Control Configuration

1

I’m trying to connect to my PostgreSQL database from my local machine using pgAdmin and psql, but I’m getting the following error:

connection to server at "dpg-d0ifpqje5dus73dsdung-a.oregon-postgres.render.com", port 5432 failed: server closed the connection unexpectedly
This probably means the server terminated abnormally before or while processing the request.

Here’s what I’ve done:

  • I added my current public IP to the Access Control list in CIDR format (xxx.xxx.xxx.xxx/32)
  • I saved the configuration and waited several minutes
  • I confirmed firewall on my system is turned off
  • I’ve tried both pgAdmin and psql with SSL mode set to require
  • The database shows as Available, but connection still fails

Can you please help me to solve this problem please?

Thanks!

2

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.