Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EFD4A9F97E8 for ; Wed, 15 Aug 2007 15:39:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42120-08 for ; Wed, 15 Aug 2007 15:39:31 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from rv-out-0910.google.com (rv-out-0910.google.com [209.85.198.184]) by postgresql.org (Postfix) with ESMTP id 1D2479F9478 for ; Wed, 15 Aug 2007 15:39:31 -0300 (ADT) Received: by rv-out-0910.google.com with SMTP id c24so7613rvf for ; Wed, 15 Aug 2007 11:39:31 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=A+ZRK92gOxdVAcqEp+SXcoXHTSZe8rfkTSGt1Od9uuoyVbDb6jWNNG8uwE+p443y3JE2Fico4Row3hlrzCUipzGgeHQF1m1Fm0vm33HDjnAVBGen0c0ZqXfYE7s60JgBKySqoQxaCFOM1VzuaepuJzFhbocn5UrYN6dDPRDLe4k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=FydUErctHeE+3iHmPBHQ89gYrbbbzPlau+BMWpgeEi1NnbCDZqBUbFBZtPsXmFwewWjnt2HN0i3rsyKeysOaDOs1ffwxksYtVPyRHxXiXWXN2xyDRV1G/NCWRfZTL6aN1HAAVbZ10U7UifWx22Wmo7I4ZcMWk7UOPJaySYLGSX0= Received: by 10.114.59.1 with SMTP id h1mr921665waa.1187203170853; Wed, 15 Aug 2007 11:39:30 -0700 (PDT) Received: by 10.114.197.19 with HTTP; Wed, 15 Aug 2007 11:39:30 -0700 (PDT) Message-ID: <4544e0330708151139p7c7f8347uf0662b8fccdb8c99@mail.gmail.com> Date: Wed, 15 Aug 2007 13:39:30 -0500 From: "Peter Koczan" To: "Alexander B." Subject: Re: Configure pg_hba.conf Cc: "pgsql-admin@postgresql.org" In-Reply-To: <46C33F64.7040303@yahoo.com.br> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <46C33F64.7040303@yahoo.com.br> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/185 X-Sequence-Number: 26516 A few notes. postgres looks through pg_hba.conf until it finds the *first* entry that matches and tries to authenticate and connect using that method. There's no fallback, so order of entries is important. If you just want to have any IP connect using one particular authentication method, put something like this as the last line in your pg_hba.conf: host all all 0.0.0.0 0.0.0.0 md5 Keep in mind that *anyone* from *any computer* can try to connect to your database server. (i.e. caveat emptor) If you want to do something different for other subnets or restrict access to specific users, you should put those lines in *before* that so that postgres will see them. Check here for more details: http://www.postgresql.org/docs/8.2/interactive/client-authentication.html Peter On 8/15/07, Alexander B. wrote: > Hi people, > > I would like to configure pg_hba for any IP. > I have several network mask, .... some times 192..., or 10...., or 190 > ..., ... ... > > How can I configure for any IP? > > Thanks > Alexander > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >