pgsql: Force idle_in_transaction_session_timeout off in pg_dump and aut

Started by Tom Laneabout 10 years ago1 messagescomitters
Jump to latest
#1Tom Lane
tgl@sss.pgh.pa.us

Force idle_in_transaction_session_timeout off in pg_dump and autovacuum.

We disable statement_timeout and lock_timeout during dump and restore, to
prevent any global settings that might exist from breaking routine backups.
Commit c6dda1f48 should have added idle_in_transaction_session_timeout to
that list, but failed to.

Another place where these timeouts get turned off is autovacuum. While
I doubt an idle timeout could fire there, it seems better to be safe than
sorry.

pg_dump issue noted by Bernd Helmle, the other one found by grepping.

Report: <352F9B77DB5D3082578D17BB@eje.land.credativ.lan>

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/8383486f108c650b187358bfe811060627c751c9

Modified Files
--------------
src/backend/postmaster/autovacuum.c | 12 ++++++++----
src/bin/pg_dump/pg_backup_archiver.c | 7 ++++---
src/bin/pg_dump/pg_dump.c | 2 ++
3 files changed, 14 insertions(+), 7 deletions(-)

--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-committers