Re: [HACKERS] pg_dump vs. idle_in_transaction_session_timeout

[Tom Lane]

Bernd Helmle  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


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

[HACKERS] pg_dump vs. idle_in_transaction_session_timeout

[Bernd Helmle]

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


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