| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Edson Richter <edsonrichter(at)hotmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Statement timeout |
| Date: | 2016-01-29 16:51:50 |
| Message-ID: | 56AB98A6.703@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 01/29/2016 07:00 AM, Edson Richter wrote:
> I've set statement timeout in postgresql.conf to 300s.
> Now, I have a schema update procedure at application startup I would
> like to run without timeout, or with significant larger timeout (let's
> say, 10000s).
>
> It is possible to change statement timeout at runtime before issuing the
> command (for one connection only) without changing postgresql.conf?
Yes, use SET
SET statement_timeout TO '$duration';
JD
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2016-01-29 19:18:27 | Re: BSD initdb without ICU support and switch later |
| Previous Message | Adrian Klaver | 2016-01-29 16:00:14 | Re: import plpy |