statement timeout and pg_dump
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.
Any opinions on this?
"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
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?
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. +