Re: statement timeout and pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: "Pgsql General list" <pgsql-general(at)postgresql(dot)org>
Subject: Re: statement timeout and pg_dump
Date: 2008-07-14 19:02:04
Message-ID: 149.1216062124@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-07-14 19:17:39 Re: statement timeout and pg_dump
Previous Message Tom Lane 2008-07-14 18:52:27 Re: UPDATE runs slow in a transaction