Обсуждение: statement_timeout by host?

Поиск
Список
Период
Сортировка

statement_timeout by host?

От
"Dave Fry"
Дата:
Hello.   Is it possible to set a statement_timeout by host, such that requests from only that host will be limited?

Re: statement_timeout by host?

От
Jeff Davis
Дата:
On Mon, 2008-10-20 at 17:22 -0700, Dave Fry wrote:
> Hello.   Is it possible to set a statement_timeout by host, such that
> requests from only that host will be limited?
>

Can you set it by user instead, and have different hosts connect using
different users?

ALTER USER foo SET statement_timeout='2s';

Regards,
    Jeff Davis


Re: statement_timeout by host?

От
"Dave Fry"
Дата:
That's definitely an option, and that's what I had slated to use as my backup plan.  But I wanted to make sure there wasn't the ability to do it by host before I went down that path, as it would be a somewhat cleaner fit in our setup.

Thanks!
Dave

On Tue, Oct 21, 2008 at 1:57 PM, Jeff Davis <pgsql@j-davis.com> wrote:
On Mon, 2008-10-20 at 17:22 -0700, Dave Fry wrote:
> Hello.   Is it possible to set a statement_timeout by host, such that
> requests from only that host will be limited?
>

Can you set it by user instead, and have different hosts connect using
different users?

ALTER USER foo SET statement_timeout='2s';

Regards,
       Jeff Davis