From: | "Dave Fry" <dave(at)davefry(dot)net> |
---|---|
To: | "Jeff Davis" <pgsql(at)j-davis(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: statement_timeout by host? |
Date: | 2008-10-21 21:34:58 |
Message-ID: | b1845180810211434n46736a15y7cbc295532d0555f@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)j-davis(dot)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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Guy Rouillier | 2008-10-21 23:32:09 | Re: Annoying Reply-To |
Previous Message | Merlin Moncure | 2008-10-21 21:23:12 | Re: text array accumulate to multidimensional text array |