我目前有一个在端口 1486 上运行的已安装 pgsql 实例.我想把这个端口改成5433,我该怎么做?
I have currently an installed pgsql instance that is running on port 1486. I want to change this port to 5433, how should I proceed for this?
推荐答案postgresql.conf 文件中应该有一行内容是:
There should be a line in your postgresql.conf file that says:
port = 1486改变它.
文件的位置可能因您的安装选项而异.在基于 Debian 的发行版上,它是 /etc/postgresql/8.3/main/
The location of the file can vary depending on your install options. On Debian-based distros it is /etc/postgresql/8.3/main/
在 Windows 上是 C:\Program Files\PostgreSQL\9.3\data
On Windows it is C:\Program Files\PostgreSQL\9.3\data
不要忘记 sudo service postgresql restart 以使更改生效.
Don't forget to sudo service postgresql restart for changes to take effect.
更多推荐
更改 pgsql 端口
发布评论