X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D940E9F9C10 for ; Thu, 4 May 2006 15:01:24 -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 98924-07 for ; Thu, 4 May 2006 15:01:05 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from he100.hostelement.com (unknown [64.246.26.51]) by postgresql.org (Postfix) with ESMTP id AEBDE9F9B76 for ; Thu, 4 May 2006 15:01:05 -0300 (ADT) Received: from [64.213.65.29] (helo=[127.0.0.1]) by he100.hostelement.com with esmtpa (Exim 4.52) id 1Fbi8K-0000eL-LH; Thu, 04 May 2006 14:01:00 -0400 Message-ID: <445A4159.2060707@oisinglynn.com> Date: Thu, 04 May 2006 14:00:57 -0400 From: Oisin Glynn User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: Catalin Pitis CC: pgsql-sql@postgresql.org Subject: Re: Connecting to Postgres from other machines (outside localhost) References: <63c4c13c0605041052q4212965bua0a3a376ba8abf3f@mail.gmail.com> In-Reply-To: <63c4c13c0605041052q4212965bua0a3a376ba8abf3f@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - he100.hostelement.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - oisinglynn.com X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/50 X-Sequence-Number: 25081 Catalin Pitis wrote: > Hello > > I installed PostgreSQL 8.0 on Windows and I can connect from localhost > only. How can I configure the server to allow connection from other > machines? > > Thank you > Catalin Under Start-> Programs->PostgreSQLXX->Configuration files postgresql.conf pg_hba.conf Are the 2 files I modified. Please be aware my settings are for a dev box and are WIDE OPEN AS SHOWN HERE this might allow alot more people connect than you want. postgresql.conf # - Connection Settings - listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost', '*' = all port = 5432 max_connections = 100 pg_hba.conf # TYPE DATABASE USER CIDR-ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 host all all 192.168.10.1/24 md5 # IPv6 local connections: #host all all ::1/128 md5