How to create digitalocean firewall for postgresql

Posted May 12, 2021 714 views
FirewallPostgreSQLDigitalOcean Cloud Firewalls

I’m looking at how to create a digitalocean firewall for my docker container.

I know how to create a rule for TCP port 5432. However I still want to connect using pgadmin.

How can I only allow local connections, and two connections from the IP address of a couple of specific computers?

Example link

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Hi there @mkoopman11,

Rather than adding All IPv4 and All IPv6 in the sources box, you need to specify your own IP address. That way only the IP addresses specified in there would be able to access to the server on that port.

The way that you have it at the moment, you are basically allowing access to that port for all IP addresses.

For more information on how to add rules, I would recommend checking out the following link: