[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: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword
Date: 2001-07-03 15:17:08
Message-ID: 3B41E1F4.9030006@free.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Hi
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 8.6 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alex Pilosov 2001-07-03 15:20:33 Re: selecting from cursor
Previous Message Thomas Swan 2001-07-03 15:05:18 Re: New data type: uniqueidentifier

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2001-07-03 15:37:14 Re: encode in base code
Previous Message Marko Kreen 2001-07-03 06:55:29 Re: encode in base code