]> granicus.if.org Git - postgresql/commit
Force idle_in_transaction_session_timeout off in pg_dump and autovacuum.
authorTom Lane <tgl@sss.pgh.pa.us>
Wed, 15 Jun 2016 14:52:53 +0000 (10:52 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Wed, 15 Jun 2016 14:53:03 +0000 (10:53 -0400)
commit8383486f108c650b187358bfe811060627c751c9
tree5099b3ef0a08fcad5a73cf2ecce24688d463c9dd
parentf0688d6e6c595cdceef3ad218b86f064f4909b4c
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>
src/backend/postmaster/autovacuum.c
src/bin/pg_dump/pg_backup_archiver.c
src/bin/pg_dump/pg_dump.c