When doing a dump+restore upgrade, it's commonly recommended to use the later
version of pg_restore:
https://www.postgresql.org/docs/current/static/upgrading.html
"It is recommended that you use the pg_dump and pg_dumpall programs from the
newer version of PostgreSQL, to take advantage of enhancements that might have
been made in these programs. Current releases of the dump programs can read
data from any server version back to 7.0."
In the immediate case, I was loading data from PG95 dumps into PG95 server (not
an upgrade), using P96 pg_restore, and getting:
ERROR: unrecognized configuration parameter "idle_in_transaction_session_timeout"
I can't see anybody has raised that issue before. Should pg_restore check the
remote server version and avoid sending commands not expected to be understood?
(Yes, I know and use pg_upgrade, however I'm currenting migrating a DB between
servers and this procedure will allow doing so with ~30min
downtime...pg_upgrade to 9.6 will be done afterwards, which is why PG96
pg_upgrade is installed).
Thanks,
Justin