Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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: postgresql-7.1.2-hba.patch
Description: text/plain (16.6 KB)

In response to

Responses

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group