我已经在远程服务器上设置了PostgreSQL，由于某些原因，即使打开端口，停用防火墙等，我也无法连接到服务器上的5432端口
- 。
lister_addresses ='*'：
postgresql.conf ：
show lister_addresses ：
- 更改了pg_hba.conf：
- 检查该端口号5432是打开的，并随
NetStat -NLP | GREP 5432
- 检查防火墙是否与sudo
ufw status
在操作中删除错误消息。
nc -v [ip_address] 5432
watch "nc -v [ip_address] 5432"
，并且在执行两者之后，我仍然会 来自外部网络的服务器？
I have set up Postgresql on a remote server, and for some reason I cannot connect to the 5432 port on the server even after opening up the port, deactivating firewall, etc.
- I have checked that the database is listening to all addresses with
listen_addresses = '*':
postgresql.conf:
SHOW listen_addresses:
- changed pg_hba.conf:
- checked that port number 5432 is open and listening with
netstat -nlp | grep 5432
- checked that firewall is inactive with sudo
ufw status
and still I get Operation timed out error message after performing both
nc -v [ip_address] 5432
watch "nc -v [ip_address] 5432"
Can anyone tell me what I can do to enable connection to the remote server from external network?
发布评论