Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 42CD32E003D for ; Tue, 19 Feb 2008 05:27:13 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 53525-06 for ; Tue, 19 Feb 2008 05:27:04 -0400 (AST) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.237]) by postgresql.org (Postfix) with ESMTP id 39D452E0044 for ; Tue, 19 Feb 2008 05:27:04 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id r21so1647223wxc.28 for ; Tue, 19 Feb 2008 01:27:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; bh=yqWgPbV02b6AZ9q0+sdevtUwTjGlOEFBiWFwbmh/zbA=; b=ZGxBAP3u6yT4Qj/OaysCuIV5pQDuzzbPrPqCHFQd51TS/3sbcK+7OUPWYg78mQ4Cel4m76uAGnJ9/apGPE67XCvrt3JX6P5mFoOa7Bda5QBBA3MMVDo33vDkH/qhEUMSqJ3FrovfCWNH3L/0H0pek9hHgvVzKpU63F9IEGNNh90= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=br1U9ONG5ku6oS9HeLioxMpvIiULHwStNS+yZ4v7Ds4M0zuLB59L4ugGpJYlegJua8EgfVTg3b0/XrMYYZ930nxDfwxXXni1CIsuBRshxARLF9zYHnC12G0gphzwIvp4t9nSimAE97HHixSsEEHklPsRo3tY6WbkmBfWJ4ptQfs= Received: by 10.70.29.7 with SMTP id c7mr1397386wxc.77.1203413222805; Tue, 19 Feb 2008 01:27:02 -0800 (PST) Received: by 10.70.13.8 with HTTP; Tue, 19 Feb 2008 01:27:02 -0800 (PST) Message-ID: Date: Tue, 19 Feb 2008 04:27:02 -0500 From: "Dan King" To: pgsql-admin@postgresql.org Subject: Can't connect from computer on network. MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8518_31905575.1203413222797" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 200802/203 X-Sequence-Number: 28277 ------=_Part_8518_31905575.1203413222797 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi list, I am using postgresql 8.2 on Ubuntu Gutsy. I am attempting to connect to my database on one computer from another computer on my network. I can connect to the database if I have: listen_addresses = '*' in my postgresql.conf file. But I can't connect if I have: listen_addresses = 'localhost, 192.168.2.102' in my postgresql.conf file. The computer that is assigned 192.168.2.102 is the computer I am attempting to connect from that works with the * but not with an assigned IP address. I understand that having a * allows all connections but I am attempting to restrict this so only a certain computer can access the database. Does anyone know why I can't connect to the database from another computer when specifying the IP address in 'listen_addresses' and how to fix my problem? Thanks a lot for the help. Dan ------=_Part_8518_31905575.1203413222797 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi list,

I am using postgresql 8.2 on Ubuntu Gutsy. I am attempting to connect to my database on one computer from another computer on my network. I can connect to the database if I have:

listen_addresses = '*'

in my postgresql.conf file. But I can't connect if I have:

listen_addresses = 'localhost, 192.168.2.102'

in my postgresql.conf file. The computer that is assigned 192.168.2.102 is the computer I am attempting to connect from that works with the * but not with an assigned IP address. I understand that having a * allows all connections but I am attempting to restrict this so only a certain computer can access the database.

Does anyone know why I can't connect to the database from another computer when specifying the IP address in 'listen_addresses' and how to fix my problem?

Thanks a lot for the help.

Dan
------=_Part_8518_31905575.1203413222797--