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

From Scott Marlowe
Subject Re: statement timeout and pg_dump
Date
Msg-id dcc563d10807141217u7466d20bva7cf734bdc7ea2d0@mail.gmail.com
Whole thread Raw
In response to Re: statement timeout and pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: statement timeout and pg_dump
List pgsql-general
On Mon, Jul 14, 2008 at 1:02 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "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

Very cool.  I assume it's not in 8.3.3 then?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: statement timeout and pg_dump
Next
From: Decibel!
Date:
Subject: Re: Feature: FOR UPDATE SKIP LOCKED