pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Configure pg_hba.conf
4+ messages / 4 participants
[nested] [flat]

* Configure pg_hba.conf
@ 2007-08-15 18:01  Alexander B. <burbello3000@yahoo.com.br>
  0 siblings, 2 replies; 4+ messages in thread

From: Alexander B. @ 2007-08-15 18:01 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Configure pg_hba.conf
@ 2007-08-15 18:06  Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
  parent: Alexander B. <burbello3000@yahoo.com.br>
  1 sibling, 0 replies; 4+ messages in thread

From: Andy Shellam (Mailing Lists) @ 2007-08-15 18:06 UTC (permalink / raw)
  To: Alexander B. <burbello3000@yahoo.com.br>; +Cc: pgsql-admin

Hi Alexander,

Use 0.0.0.0/0.  You can of course add multiple lines to match all your 
ranges (e.g. 192.168.0.0/24, 10.0.0.0/8 etc.)

Regards,

Andy.

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
>
> !DSPAM:37,46c33ff9107509519219121!
>
>
>
>   




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Configure pg_hba.conf
@ 2007-08-15 18:39  Peter Koczan <pjkoczan@gmail.com>
  parent: Alexander B. <burbello3000@yahoo.com.br>
  1 sibling, 1 reply; 4+ messages in thread

From: Peter Koczan @ 2007-08-15 18:39 UTC (permalink / raw)
  To: Alexander B. <burbello3000@yahoo.com.br>; +Cc: pgsql-admin

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?
>
> 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
>



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Configure pg_hba.conf
@ 2007-08-16 03:08  Julio Cesar Sánchez González <knowhow@sistemasyconectividad.com.mx>
  parent: Peter Koczan <pjkoczan@gmail.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Julio Cesar Sánchez González @ 2007-08-16 03:08 UTC (permalink / raw)
  To: Peter Koczan <pjkoczan@gmail.com>; +Cc: Alexander B. <burbello3000@yahoo.com.br>; pgsql-admin

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.




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2007-08-16 03:08 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-15 18:01 Configure pg_hba.conf Alexander B. <burbello3000@yahoo.com.br>
2007-08-15 18:06 ` Andy Shellam (Mailing Lists) <andy.shellam-lists@mailnetwork.co.uk>
2007-08-15 18:39 ` Peter Koczan <pjkoczan@gmail.com>
2007-08-16 03:08   ` Julio Cesar Sánchez González <knowhow@sistemasyconectividad.com.mx>

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