Re: statement timeout and pg_dump - Mailing list pgsql-general

From Tom Lane
Subject Re: statement timeout and pg_dump
Date
Msg-id 149.1216062124@sss.pgh.pa.us
Whole thread Raw
In response to statement timeout and pg_dump  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: statement timeout and pg_dump
List pgsql-general
"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> I just got hoisted by my own petard when a pg_dump failed due to
> statement timeout and I didn't notice because I was running the dump
> nohup and didn't read the nohup.out file to see the errors.  It wasn't
> a big deal, the data wasn't critical operational data or anything.

> But it got me to thinking that maybe pg_dump should disable
> statement_timeout when it runs.

You mean like this?

http://archives.postgresql.org/pgsql-committers/2008-05/msg00026.php

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: UPDATE runs slow in a transaction
Next
From: "Scott Marlowe"
Date:
Subject: Re: statement timeout and pg_dump