psql refused 处理
时间:2010-01-12 来源:huixiangtao
[root@SJSWT-63:~]# telnet xx.xx.xx.57 5432
telnet: connect to address xx.xx.xx.57: Connection refused
telnet: Unable to connect to remote host: Connection refused
vim postgresql.conf
listen_addresses = ‘*’ # what IP address(es) to listen on;
# comma-separated list of addresses;
# defaults to ‘localhost’, ‘*’ = all
# (change requires restart)
port = 5432 # (change requires restart)
[postgre@TJSJHL-57 data]$ netstat -lnpt
tcp 0 0 0.0.0.0:5432 0.0.0.0:* LISTEN 26147/postgres
[postgre@TJSJHL-57 ~]$ /usr/local/pgsql/bin/pg_ctl -D ./data stop
[postgre@TJSJHL-57 ~]$ /usr/local/pgsql/bin/pg_ctl -D ./data start