Thread: pg_dump vs. idle_in_transaction_session_timeout

pg_dump vs. idle_in_transaction_session_timeout

From
Bernd Helmle
Date:
Currently pg_dump doesn't turn off idle_in_transaction_session_timeout.

Okay, the window of failure here is very narrow (on my machine it breaks
with an insane setting of 1ms only), but for the sake of reliable backups
and protection against over motivated DBA it looks better to me to turn
that off, no?

--
Thanks
Bernd



Re: pg_dump vs. idle_in_transaction_session_timeout

From
Tom Lane
Date:
Bernd Helmle <mailings@oopsware.de> writes:
> Currently pg_dump doesn't turn off idle_in_transaction_session_timeout.

Definitely an oversight, since it turns off other timeout settings.

> Okay, the window of failure here is very narrow (on my machine it breaks
> with an insane setting of 1ms only),

Probably if you were using parallel dump or restore, it could be a lot
more fragile, since an individual worker session might have nothing to
do for some period of time.

Will fix if no one beats me to it.
        regards, tom lane