昨天我在远程连接postgres数据库时遇到这样的错误:
psql: could not connect to server: Connection refused
Is the server running on host "my host name" (IP) and accepting
TCP/IP connections on port 5432?
于是我修改了postgresql.conf:
listen_addresses = '*'
在pg_hba.conf, 添加了我的IP,如下:
#for n/w access
host all c2d 10.147.16.0/24 md5
后来查了些资料才知道要修改postgresql.conf,修改listen_addresses = '*' 对所有的地址都监听,同时修改缓存为7G,restart postgres后又遇到了一些错误:
2015-05-14 09:39:00 CST FATAL: could not create shared memory segment: Invalid