@canf113378ba95d

If it’s not enabled, connections shouldn’t be blocked, so the next option would be to get in touch with Name.com’s support team and see if they are blocking outgoing connections to any specific ports (i.e. 5432). In the support ticket, ask them if they are blocking specific outgoing ports and if you’re allowed to connect to external servers (not all shared hosting providers will allow it).

If you can connect to your Droplet using the applications noted in your first post, the issue most likely will be related to their servers.

That being said, in regards to the firewall, for security, yes, it should be enabled. Ideally, you want to enable ufw and set it up with a deny all policy, then add rules that allow only the ports you specify to be accessed.

The most simple way of doing this would be (copy and paste to terminal):

sudo ufw default deny \
&& sudo ufw allow 22/tcp \
&& sudo ufw allow 5432/tcp \
&& sudo ufw enable

What this does is set the default policy to deny all connections, then make an exception to allow port 22 (SSH) and port 5432 (PQSql), and finally enable the firewall. This configuration will deny access to all other ports (80, 443, etc), so if you want to extend the ports that are open for connection, you would simply add a new rule. For instance, port 80 is HTTP, so to add it you’d run:

sudo ufw allow 80/tcp

and port 80 can now be accessed.