Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id EE09D9F974F for ; Thu, 16 Aug 2007 00:09:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 48384-01 for ; Thu, 16 Aug 2007 00:09:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from servidor58.suempresa.com (servidor58.suempresa.com [201.130.79.68]) by postgresql.org (Postfix) with ESMTP id AFE319F973B for ; Thu, 16 Aug 2007 00:09:01 -0300 (ADT) Received: (qmail 28697 invoked from network); 15 Aug 2007 22:09:04 -0500 Received: from dsl-189-142-111-136.prod-infinitum.com.mx (HELO ?192.168.1.5?) (189.142.111.136) by servidor58.suempresa.com with SMTP; 15 Aug 2007 22:09:04 -0500 Subject: Re: Configure pg_hba.conf From: Julio Cesar =?ISO-8859-1?Q?S=E1nchez_Gonz=E1lez?= To: Peter Koczan Cc: "Alexander B." , "pgsql-admin@postgresql.org" In-Reply-To: <4544e0330708151139p7c7f8347uf0662b8fccdb8c99@mail.gmail.com> References: <46C33F64.7040303@yahoo.com.br> <4544e0330708151139p7c7f8347uf0662b8fccdb8c99@mail.gmail.com> Content-Type: text/plain; charset=utf-8 Date: Wed, 15 Aug 2007 22:08:51 -0500 Message-Id: <1187233731.6713.13.camel@andromeda> Mime-Version: 1.0 X-Mailer: Evolution 2.10.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.079 tagged_above=0 required=5 tests=AWL=0.264, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 200708/192 X-Sequence-Number: 26523 El mié, 15-08-2007 a las 13:39 -0500, Peter Koczan escribió: > 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? In the pg_hba.conf add some similar to: host all all 192.168.1.0/24 trust with the respective cidr address would you like to do. > > > > 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 > > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate -- Regards, Julio Cesar Sánchez González www.sistemasyconectividad.com.mx blog: http://darkavngr.blogspot.com --- Ahora me he convertido en la muerte, destructora de mundos. Soy la Muerte que se lleva todo, la fuente de las cosas que vendran.