Thread: BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header
BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header
From
PG Bug reporting form
Date:
The following bug has been logged on the website: Bug reference: 16973 Logged by: Piotr F Email address: frankaen@gmail.com PostgreSQL version: 10.16 Operating system: Ubuntu 20.04 LTS Description: Hello, Full dump created on April 12, 2021, default Ubuntu 18.04 LTS, cannot be restored on April 19, with the current output: psql --version psql (PostgreSQL) 10.16 (Ubuntu 10.16-1.pgdg20.04+1) pg_restore returns: pg_restore: [archiver] unsupported version (1.14) in file header PostgreSQL server installed all along with the OpenProject installation. Sorry for being brief, I am not a developer, if needed, I will be happy to provide with more info, just let me know which one, and how to get the necessary output. Cheers, Piotr
Re: BUG #16973: Backward compatibility: pg_restore: [archiver] unsupported version (1.14) in file header
From
Tom Lane
Date:
PG Bug reporting form <noreply@postgresql.org> writes: > Full dump created on April 12, 2021, default Ubuntu 18.04 LTS, cannot be > restored on April 19, with the current output: > psql --version > psql (PostgreSQL) 10.16 (Ubuntu 10.16-1.pgdg20.04+1) > pg_restore returns: > pg_restore: [archiver] unsupported version (1.14) in file header The most obvious explanation for this is that you made the dump with a v12-or-later pg_dump, and are now trying to restore it with a pre-v12 pg_restore. If so, the failure is expected. regards, tom lane