下载地址
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
一直下一步安装就行。
问题1
navicat 连接报错:
authentication method 10 not supported
修改:
D:\soft\postgresql-13.1-1\data\postgresql.conf
listen_addresses = '*' # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to 'localhost'; use '*' for all
# (change requires restart)
修改:
D:\soft\postgresql-13.1-1\data\pg_hba.conf
# IPv4 local connections:
#host all all 127.0.0.1/32 scram-sha-256
host all all 127.0.0.1/32 password
host all all 0.0.0.0/0 password
