From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: TODO list |
Date: | 2003-12-22 22:39:49 |
Message-ID: | 3FE772B5.7090302@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane wrote:
>"Andrew Dunstan" <andrew(at)dunslane(dot)net> writes:
>
>
>>Tom Lane said:
>>
>>
>>>On an implementation level, where are you thinking of enforcing this?
>>>
>>>
>
>
>
>>Without digging deeply at all I thought probably in the postmaster.
>>
>>
>
>Nah, that's a nonstarter, because the postmaster has basically no
>information about its children except for their PIDs and cancel keys.
>In particular it does not know which database or user each one is for,
>and really can't because the connection request packet is not input
>from the client connection until after fork().
>
>AFAICS there's really no other way to get this information than by
>looking in shared memory. The PGPROC array already has info about
>connected databases. I don't think it stores info about session user,
>but that would be an easy and cheap addition.
>
>
>
>>I'm not at all dogmatic about using pg_hba.conf - it just seemed similar
>>to the info we carry there.
>>
>>
>
>It's not necessarily a bad idea; we'd just need to adjust our theory
>about when the cached pg_hba.conf data can be freed.
>
>
>
Did we reach a concensus about how this should be done? From a config
file? If so, should it be pg_hba.conf? Or from a table?
cheers
andrew
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-12-22 22:41:54 | Re: [GENERAL] Temporary tables and miscellaneous schemas |
Previous Message | Bruce Momjian | 2003-12-22 22:04:50 | Re: [COMMITTERS] pgsql-server/doc/src/sgml Tag: REL7_4_STABLE |