Re: limiting connections per user/database

Поиск
Список
Период
Сортировка
От Petr Jelínek
Тема Re: limiting connections per user/database
Дата
Msg-id 42BF77A6.1090707@parba.cz
обсуждение исходный текст
Ответ на Re: limiting connections per user/database  (Alvaro Herrera <alvherre@surnet.cl>)
Ответы Re: limiting connections per user/database  (Petr Jelínek <pjmodos@parba.cz>)
Список pgsql-patches
Alvaro Herrera wrote:

>Prepared transactions can be filtered out by checking the pid struct
>member.  I'm not sure if anybody would object to adding the
>authenticated user Id to ProcArray, but I don't see why not.
>
>
Very well, it seems to work this way (although the code for storing
userid in PGPROC isn't as clean as I hoped).

The problem now is that I am storing those limits in system catalog but
there is no ALTER DATABASE implementation which I could use to change
this - there are only RENAME, OWNER and SET implementations and those
are not usable for "normal" properties (SET is for guc variables only
which was the actual reason for me to use guc variables first time).
That said I think that I will have to implement some ALTER DATABASE
command for those purposes and I am not sure if I can handle it because
I am not familiar with bison (I have even problems to add new ALTER USER
property to existing implementation).

--
Regards
Petr Jelinek (PJMODOS)



В списке pgsql-patches по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: COPY FROM performance improvements
Следующее
От: "Luke Lonergan"
Дата:
Сообщение: Re: COPY FROM performance improvements