Skip to main content

Connection Issues

Can't connect to your database? Try running through the steps below to debug the issue.

Ensure PostgreSQL is running & accepting remote connections​

Though this may seem like an obvious issue, it’s worth while to quickly check. Log on to your server, and ensure that PostgreSQL is running. If it is, check if you’re accepting connections from remote hosts (the default is set to only accept local connections). We recommend you refer to this blog post to check/enable remote connections. Please also verify that the IP address/port are correct.

Is it a firewall issue?​

It could also be that there is a firewall preventing the connection from your computer to the server. This can be both a software, as well as a hardware firewall. On linux, check if you have UFW installed, and if you do, please check that it allows PostgreSQL connections (on port 5432). Please also check if your (Windows) firewall has any Inbound or Outbound rules blocking your project from connecting.

Using pgAdmin to test your connection​

If you’re still having issues, we recommend you download a tool like pgAdmin, an application that can be used to connect to/manage your database to rule out anything other than your project/NetDB.

Once you’ve opened up pgAdmin, right click Servers, and use Server -> Create to create a new server connection. Give it whatever name you want, and fill in your connection details in the Connection tab. Press save and double-click the server to attempt the connection.

Did it work? That must mean that there is an issue with your project. Please reach out to us for further support.

Did the connection in pgAdmin4 fail too? That means something is wrong with your PostgreSQL server, or the details you are using to connect to it. The error pgAdmin is giving you may help you isolate the issue further. Though you are free to reach out, please know that this is an issue with your server, and not NetDB, so we will do our best to help, but cannot guarantee we can resolve your issue.