mjhjmtu

BACKGROUND

Hey guys, hopefully this is an easy fix. I've done all the basic troubleshooting and am still not finding any luck.

I'm using an Ubuntu 16.04 Google Compute Engine server and am not able to open port 5432 for PostgreSQL.

ufw is enabled, and I can tell other ports are open via

nc -zv ipAddress 80,
nc -zv ipAddress 22, etc.

nc -zv ipAddress 5432 just times out. pgAdmin4 can't connect to the server via port 5432 either.

ALREADY TRIED

sudo ufw allow 5432/tcp

sudo ufw allow 5432 (just thought I'd give it a try)

In /etc/postgresql/9.5/main/postgresql.conf

listen_addresses = '*'

In /etc/postgresql/9.5/main/pg_hba.conf

host all all 0.0.0.0/0 md5
host all all ::0/0 md5

ALSO TRIED

host all all 0.0.0.0/0 trust
host all all ::0/0 trust

ACTUAL FILES

Here are the current versions of the relevant parts of the aforementioned files:

postgresql.conf

listen_addresses = '*' # what IP address(es) to listen on;
 # comma-separated list of addresses;
 # defaults to 'localhost'; use '*' for all
 # (change requires restart)
port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
#superuser_reserved_connections = 3 # (change requires restart)
unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories

pg_hba.conf

# Database administrative login by Unix domain socket
local all postgres peer

# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
# All connections
host all all 0.0.0.0/0 md5
host all all ::0/0 md5