Skip to main content

postgresql开启远程登录

· One min read

步骤一修改pg_hba.conf文件​

# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
host    all             all             0.0.0.0/0               md5

步骤二修改postgresql.conf文件​

# - Connection Settings -
listen_addresses = '*'          # what IP address(es) to listen on;

步骤三重启​

sudo systemctl restart postgresql