If you use Direct Connection method and run into this error "Could not connect to server: Connection refused", it's likely that you haven't configured your database to allow remote database connection.
If that is the case, please follow these steps:
postgresql.conf (usually in
/etc/postgresql/9.x/main/) and enable the following:
Also, add the following lines to
And restart your database to take effect:
my.conf and comment out
Then restart MySQL for the change to take effect:
If you are using SSH tunneling and your bastion server is the same as your DB host, then the steps above are not necessary since the DB connection will look like a local connection.