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

From Bruce Momjian
Subject Re: statement timeout and pg_dump
Date
Msg-id 200807142116.m6ELGuc06770@momjian.us
Whole thread Raw
In response to Re: statement timeout and pg_dump  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
Scott Marlowe wrote:
> 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?

No, because this is a functionality change, rather than a clear bug.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-general by date:

Previous
From: "Mason Hale"
Date:
Subject: vacuum taking an unusually long time
Next
From: "JD Wong"
Date:
Subject: plperl installation