Re: statement_timeout by host? - Mailing list pgsql-general

From Dave Fry
Subject Re: statement_timeout by host?
Date
Msg-id b1845180810211434n46736a15y7cbc295532d0555f@mail.gmail.com
Whole thread Raw
In response to Re: statement_timeout by host?  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Nikolas Everett"
Date:
Subject: Re: partitioning a table containing millions of records
Next
From: Alvaro Herrera
Date:
Subject: Re: Annoying Reply-To