[GENERAL] remote connection error:could not connect to server: Connection refused

2015-11-21 Thread Alex Luya
My postgresql 9.4 is installed in centos 6.7,and I have followed this: http://www.cyberciti.biz/faq/postgresql-remote-access-or-connection/ 1,cd /usr/pgsql-9.4/share/ 2,cp postgresql.conf.sample postgresql.conf 3,sudo vi postgresql.conf and add two lines,and save it: > *listen_addresses =

Re: [GENERAL] remote connection error:could not connect to server: Connection refused

2015-11-21 Thread Tom Lane
Alex Luya writes: > My postgresql 9.4 is installed in centos 6.7,and I have followed this: > http://www.cyberciti.biz/faq/postgresql-remote-access-or-connection/ > 1,cd /usr/pgsql-9.4/share/ > 2,cp postgresql.conf.sample postgresql.conf > 3,sudo vi postgresql.conf and