pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Julio Cesar Sánchez González <knowhow@sistemasyconectividad.com.mx>
To: Peter Koczan <pjkoczan@gmail.com>
Cc: Alexander B. <burbello3000@yahoo.com.br>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Configure pg_hba.conf
Date: Wed, 15 Aug 2007 22:08:51 -0500
Message-ID: <1187233731.6713.13.camel@andromeda> (raw)
In-Reply-To: <4544e0330708151139p7c7f8347uf0662b8fccdb8c99@mail.gmail.com>
References: <46C33F64.7040303@yahoo.com.br>
	<4544e0330708151139p7c7f8347uf0662b8fccdb8c99@mail.gmail.com>

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. <burbello3000@yahoo.com.br> 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.




view thread (4+ messages)

Message-ID: <1187233731.6713.13.camel@andromeda>
Permalink:  ../1187233731.6713.13.camel@andromeda/
Also on:    postgresql.org/message-id/1187233731.6713.13.camel@andromeda

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: knowhow@sistemasyconectividad.com.mx, pjkoczan@gmail.com, burbello3000@yahoo.com.br
  Subject: Re: Configure pg_hba.conf
  In-Reply-To: <1187233731.6713.13.camel@andromeda>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox