Re: pg_dump vs. idle_in_transaction_session_timeout - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump vs. idle_in_transaction_session_timeout
Date
Msg-id 16818.1465998006@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump vs. idle_in_transaction_session_timeout  (Bernd Helmle <mailings@oopsware.de>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: 10.0
Next
From: Amit Kapila
Date:
Subject: Re: Reviewing freeze map code