I have installed Unbuntu on a droplet as well as a PostGresql server setup on it as well.
I was however, able to connect in the terminal on my droplet with this: psql -h [ip_address] -d [name_of_the_database] -U [username]…
I am unable to remotely connect to my Postgresql database(s) via pgAdmin4 or Azure Data Studio. I have been researching for the past week on what the issue is and still have not had any luck…
I have changed the required config files as suggested in many other topics exactly like mine.
I have a db user that has been granted all privileges to the database I want to dev on.
I have changed my pg_hba.conf file so that it accepts all IPs’ both for IPV4 and IPV6. For Example: 0.0.0.0/0 and ::/0
I have changed the postgresql.conf so that the listening addresses = ‘*’ (yes, its uncommented).
I have also ran the script for the firewall for port 5432.
When I try to connect to the database using Azure data studios I keep getting:
“Is the server running on host”..." and accepting TCP/IP connections on port 5432?"
or when I try to connect in pgAdmin4 it just says I am unable to connect
Thus, when I run netstat -nlt I can see that can’t be rue becasue of this:
tcp 0 0 0.0.0.0:5432 0.0.0.0: LISTEN*
Any ideas on whats going on here…?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
This sounds like your firewall is blocking the connections. If you run
sudo ufw status
do you see a rule allowing access on port5432
?If not, make sure to allow it with the following:
Also did you restart your PostgreSQL service after making those changes?