Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword

From: Damien Clermonté <damien(dot)clermonte(at)free(dot)fr>
To: pgsql-patches(at)postgresql(dot)org
Subject: Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword
Date: 2001-07-04 12:51:49
Message-ID: 3B431165.90203@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hi

New try, with a (probably bad english) documentation patch this time :)

This patch againsts postgresql 7.1.2 allows you to control access based on the
virtual host address only (virtualhost access type), or both the remote
address and the local address (connection access type).

For example:

connection all 192.168.42.0 255.255.255.0 192.168.1.42 255.255.255.255 trust

This patch also allows keyword "samehost", similar to "sameuser" but for
hosts.

For example:

virtualhost sameuser samehost.sql.domain.com 255.255.255.255 trust

will prevent you from doing 1 entry per user, all you need is a
(local) dns entry for each host (user foo needs foo.sql.domain.com).
If the dns entry is not found, the line is dropped, so rejecting with
samehost is not a good idea for the moment.

Any comments are welcome.
Please not that I'm not on the list.

---
Damien Clermonte

Attachment Content-Type Size
postgresql-7.1.2-hba.patch text/plain 16.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Colin Strickland 2001-07-04 13:28:46 CREATE TABLE .. PRIMARY KEY quirk
Previous Message Michel Soto 2001-07-04 12:12:51 Strange query execution time

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2001-07-04 15:07:52 Re: Patch to remove connection hook and JDK 1.3 dependencies
Previous Message Tom Lane 2001-07-03 19:45:59 Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword