且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在Windows中更改Postgresql侦听端口?

更新时间:2023-01-17 22:51:46

只需更改文件postgresql.conf中的设置(可以在数据目录中找到):

Just change the setting in the file postgresql.conf (can be found in the data directory):

port = 5433             # (change requires restart)

可以通过更改 pg_hba.conf来提供远程访问. ,只需添加ip地址.您还必须编辑postgresql.conf:

Remote access can be given by changing pg_hba.conf, just add the ip-address. You also have to edit postgresql.conf:

listen_addresses = '*'