Re: BUG #16308: pg_restore: [archiver (db)] could not execute query: ERROR: unrecognized configuration parameter "i

> On 18 Mar 2020, at 13:12, PG Bug reporting form <noreply(at)postgresql(dot)org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 16308
> Logged by: Chandra
> Email address: chandu_munnu(at)yahoo(dot)com
> PostgreSQL version: 9.5.15
> Operating system: Linux
> Description:
>
> pg_restore: [archiver (db)] Error while PROCESSING TOC:
> pg_restore: [archiver (db)] Error from TOC entry 3796; 0 0 SEARCHPATH
> SEARCHPATH
> pg_restore: [archiver (db)] could not execute query: ERROR: unrecognized
> configuration parameter "idle_in_transaction_session_timeout"
> Command was: SET idle_in_transaction_session_timeout = 0;
>

idle_in_transaction_session_timeout only exist starting with 9.6, so it sounds
like you are restoring a dump made by a newer version of pg_dump. You should
be using the version of pg_dump which match the server version you are
restoring into.

On that note, it seems that the 9.4 and 9.5 release notes reference the GUC in
question, even though the commit message correctly states the GUC is only in
9.6 and newer. To avoid confusion, I suggest that we remove the reference in
the back-branches as per the attached.

cheers ./daniel