Re: question about client/server version mismatches

2019-08-12 Thread Michael Paquier
On Tue, Aug 13, 2019 at 12:45:35PM +1000, raf wrote: > Since the backup itself was from a 9.5.12 server, it > seems that the 9.6 parameter, idle_in_transaction_session_timeout, > must have been set by the 9.6 client even though it was > connected to a 9.5 server. Is that expected behaviour? Yes, t

question about client/server version mismatches

2019-08-12 Thread raf
Hi, macos-10.11.6 postgresql-9.5.16 (server) postgresql-9.6.12 (client) I've just rebooted my macos laptop for the first time in months and have started having a problem loading database backups there. I get this error output: pg_restore: [archiver (db)] Error while INITIALIZING: pg_restore: