I'm trying to connect to a PostgreSQL database in an Ubuntu Server, which I have root access, but somehow I can't open port 5432 for remote access, just local. This is what happens when I use "nmap" command on the server (XXX.XXX.X.XX represents server's IP):
nmap -p 5432 localhost PORT STATE SERVICE 5432/tcp open postgresql nmap -p 5432 XXX.XXX.X.XX PORT STATE SERVICE 5432/tcp closed postgresql
I have already edited the files 'pg_hba.conf' and 'postgresql.conf' but it didn't work.
# IPv4 local connections: host all all all md5 # IPv6 local connections: host all all all md5
listen_addresses = '*'
And when i try to connect with pgAdmin III, this is what it shows me:
Server doesn't listen
could not connect to server: Connection refused (0x0000274D/10061) Is the server running on host "XXX.XXX.X.XX" and accepting TCP/IP connections on port 5432?
I have tried to open the port using "ufw" command but it didin't work as well.
Can anyone help me?