statement_timeout and pg_dump

From: "Ivan Zolotukhin" <ivan(dot)zolotukhin(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: statement_timeout and pg_dump
Date: 2006-05-18 11:04:08
Message-ID: 751e56400605180404r3cf4f401u2b23c7db0c936a5b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I've recently set up statement_timeout setting in postgresql.conf to
terminate long running queries from web clients. When I run long
maintance queries (that should not be terminated) like VACUUM FULL in
psql client, I can specify per session setting like `SET
statement_timeout TO 0` not to let it fail because of the above
timeout.

But it seems that it's not possible to do long running pg_dump in this
situation because it obviously fails when reaches timeout time. So are
there any ways to increase timeout time for the dump procedure?

Thanks,
Ivan Zolotukhin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-05-18 11:13:13 Re: table variables
Previous Message Kenneth Downs 2006-05-18 10:56:02 Re: Announce: GPL Framework centered on Postgres