I using AWS and want to connect postgresql but i have the problem
Unable to connect to server:
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "xx.xxx.x.x" and accepting
TCP/IP connections on port 5432?
On server stay ubuntu 18.04, i installed postgres used this command:
sudo sh -c 'echo "local all all trust" >> /etc/postgresql/12/main/bg_hba.conf'
sudo sh -c 'echo "host all all 127.0.0.1/32 trust" >> /etc/postgresql/12/main/bg_hba.conf'
sudo sh -c 'echo "host all all 0.0.0.0/0 trust" >> /etc/postgresql/12/main/bg_hba.conf'
sudo nano /etc/postgresql/12/main/postgresql.conf
listen_addresses = '*'
sudo service postgresql restart
Yes i deleted '#'
ubuntu@ip-xxxxxxxxxx:~$ sudo netstat -ltpn
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 0.0.0.0:80 0.0.0.0:* LISTEN 6462/nginx: master
tcp 0 0 127.0.0.53:53 0.0.0.0:* LISTEN 629/systemd-resolve
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 1040/sshd
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 20516/postgres
tcp 0 0 127.0.0.1:5433 0.0.0.0:* LISTEN 20539/postgres
tcp 0 0 0.0.0.0:25 0.0.0.0:* LISTEN 16863/master
tcp 0 0 0.0.0.0:5434 0.0.0.0:* LISTEN 20517/postgres
tcp6 0 0 :::80 :::* LISTEN 6462/nginx: master
tcp6 0 0 :::8080 :::* LISTEN 5975/java
tcp6 0 0 :::22 :::* LISTEN 1040/sshd
tcp6 0 0 :::25 :::* LISTEN 16863/master
tcp6 0 0 :::5434 :::* LISTEN 20517/postgres
Connecting from pgAdmin4 What i didn't right? Thanks for answering if i used commands i showed
ubuntu@ip-xxxxxxxx:~$ sudo -i -u postgres
postgres@ip-xxxxxxxx:~$ psql
psql (12.2 (Ubuntu 12.2-2.pgdg18.04+1), server 10.12 (Ubuntu 10.12-0ubuntu0.18.04.1))
Have you validated the security groups for your RDS instance? Is the RDS instance in a public or private subnet? Is it a internal or external RDS instance.
Need some additional network setup to accurately identify, however, from the information provided it cannot connect.
Nice