From: Peter Koczan <pjkoczan@gmail.com>
To: 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 13:39:30 -0500
Message-ID: <4544e0330708151139p7c7f8347uf0662b8fccdb8c99@mail.gmail.com> (raw)
In-Reply-To: <46C33F64.7040303@yahoo.com.br>
References: <46C33F64.7040303@yahoo.com.br>
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
>
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: pjkoczan@gmail.com, burbello3000@yahoo.com.br
Subject: Re: Configure pg_hba.conf
In-Reply-To: <4544e0330708151139p7c7f8347uf0662b8fccdb8c99@mail.gmail.com>
References: <46C33F64.7040303@yahoo.com.br> <4544e0330708151139p7c7f8347uf0662b8fccdb8c99@mail.gmail.com>
* 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