Re: [GENERAL] remote connection refused

2012-11-19 Thread Yvon Thoraval
YES fine, thanks a lot ! it was left to default 'locahost'... 2012/11/19 Devrim GÜNDÜZ > > Hi, > > On Mon, 2012-11-19 at 13:08 +0100, Yvon Thoraval wrote: > > in such a situation what is your checklist in order to find what I've > > missed ? > > What is listen_addresses in postgresql.conf ? It

Re: [GENERAL] remote connection refused

2012-11-19 Thread Devrim GÜNDÜZ
Hi, On Mon, 2012-11-19 at 13:08 +0100, Yvon Thoraval wrote: > in such a situation what is your checklist in order to find what I've > missed ? What is listen_addresses in postgresql.conf ? It should be * or so. Also, I would make sure that there is not a firewall on the machine itself. Regard

Re: [GENERAL] remote connection refused

2012-11-19 Thread Martin French
stat -a | grep 5432) Cheers From: Yvon Thoraval To: "pgsql-general@postgresql.org" , Date: 19/11/2012 12:14 Subject: [GENERAL] remote connection refused Sent by:pgsql-general-ow...@postgresql.org I'd like to have a checklist upon what to do, what to

[GENERAL] remote connection refused

2012-11-19 Thread Yvon Thoraval
I'd like to have a checklist upon what to do, what to investigate, when an external connection is refused. if i connect by : psql -h localhost -p 5432 -U yt mydb it works as usual however even locally but using the LAN address : psql -h 192.168.0.20 -p 5432 -U yt mydb i got a : psql: could no