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