java - 无法连接到服务器：连接被拒绝 (0x0000274D/10061) PostgreSQL

问题描述

我使用 AWS 并想连接 postgresql 但我有问题

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?

在服务器停留 ubuntu 18.04 上，我安装了 postgres，使用了这个命令：

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

是的，我删除了“#”

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

从 pgAdmin4 连接我做错了什么？感谢您回答我是否使用了我显示的命令

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))

标签： javalinuxpostgresqlamazon-web-servicesnginx

java - 无法连接到服务器：连接被拒绝 (0x0000274D/10061) PostgreSQL

问题描述

解决方案

推荐阅读