YES! Done - my listen addresses was the default. Thanks Richard! Nina -----Original Message----- From: Richard Huxton [mailto:dev@xxxxxxxxxxxx] Sent: September 19, 2008 11:57 To: Markova, Nina Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: [GENERAL] setting Postgres client Markova, Nina wrote: > > Thanks Richard. > > > I specified the host IP ( I use the default 5432 port), got error: > psql: could not connect to server: Connection refused > Is the server running on host "192.168.XX.XXX" and accepting > TCP/IP connections on port 5432? > > The only tcp lines in my postgres.conf are > #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; > # 0 selects the system default > #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; > # 0 selects the system default > #tcp_keepalives_count = 0 # TCP_KEEPCNT; > # 0 selects the system default > Should I change something here? Check "listen_addresses" and "port" look OK. You're probably only listening to localhost. You can test by telnet-ing to port 5432 or using lsof / netstat to see what connections you have open in that zone. -- Richard Huxton Archonet Ltd
