Securely Manage Remote PostgreSQL Servers with pgAdmin/ssh
Hi -- followed guide to "How to Install PostgreSQL on Ubuntu 16.04" and successfully connected to database with putty using "How to Access PostgreSQL Database Remotely Using pgAdmin on Windows" guide but I'm getting a "could not connect to server: Connection refused (0x0000274D/10061)" error trying to connect thru pgAdmin 4. Ideally I'd also like to be able to use bash to ssh in and just run terminal commands without using putty.
I edited the hba.conf to include my local IP and the postgresql.conf to listen for '*'.
Many thanks in advance
If you'd like to access your Linode without using PuTTY, you could try using Lish:
It provides out of band access and doesn't rely on SSH.
As for the "connection refused" error, I'd recommend first checking to see whether PostgreSQL is listening to the public internet. You can do so with:
That'll list all processes on your Linode listening to the internet, and which ports they're using.
From there, check your Linode's firewall to make sure the port isn't blocked. If you're using iptables you can run the following command to list all firewall rules:
iptables -L -nv --line-numbers