X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A4FD59FBA6D for ; Fri, 25 Aug 2006 10:49:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 44206-07 for ; Fri, 25 Aug 2006 10:48:57 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id F172C9FBA69 for ; Fri, 25 Aug 2006 10:48:57 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k7PDmt6p023225; Fri, 25 Aug 2006 09:48:55 -0400 (EDT) To: Purusothaman A cc: pgsql-admin@postgresql.org Subject: Re: Is the server running on host "192.168.2.111" and accepting TCP/IP conn In-reply-to: <5982235.post@talk.nabble.com> References: <5982235.post@talk.nabble.com> Comments: In-reply-to Purusothaman A message dated "Fri, 25 Aug 2006 05:09:34 -0700" Date: Fri, 25 Aug 2006 09:48:55 -0400 Message-ID: <23224.1156513735@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.143 tagged_above=0 required=5 tests=AWL, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/286 X-Sequence-Number: 22829 Purusothaman A writes: > My system IP is 192.168.2.111, and client machine IP is 192.168.2.89. > I can connect to the PostgreSQL server with " psql -Uroot -h192.168.2.111" > from same system(192.168.2.111) > If I give the above command from 192.168.2.89, results > E:\Program Files\PostgreSQL\8.1\bin>psql -Uroot - h192.168.2.111 > psql: could not connect to server: Connection refused (0x0000274D/10061) > Is the server running on host "192.168.2.111" and accepting > TCP/IP connections on port 5432? I'm betting that you have some firewall software on that server that needs to be persuaded to let through nonlocal connections to port 5432. > I have read that we have to specify option "-i" while starting postmaster to > accept TCP/IP connections from other systems. (Is it right?) No, that's been superseded by listen_addresses, which you appear to have set correctly already. (If you modified that entry, you did restart the postmaster afterwards, right?) regards, tom lane