Question 277546 in Debian Question posted in
The oficial documentation can be found here.

Debian – pg_restore: error: unsupported version (1.15) in file header

I am trying to restore my backup that is in .backup format to vercel but i keep getting this error

pg_restore: error: unsupported version (1.15) in file header

pg_dump --version
pg_dump (PostgreSQL) 15.4 (Ubuntu 15.4-1.pgdg22.04+1)


psql --version 
psql (PostgreSQL) 15.4 (Ubuntu 15.4-1.pgdg22.04+1)

According pgAdmin
vercel is also runing this version of postgress

PostgreSQL 15.4 on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

i installed latest version of postgress but it is not working

Tags:

2

Answers


  1. 0

    Archive version 1.15 was introduced in PostgreSQL v16 to support different compression algorithms. The dump was taken with PostgreSQL v16, so you can only restore it with v16 or better.

    Login or Signup to reply.
  2. 0

    the extension must be .dump

    pg_dump -v -Fc -f /full/file/path/backup_file_name.dump db_name

    or

    pg_dump --file "/full/file/path/backup_file_name.dump" --host "db_host" --port "db_port" --username "db_user" --password --format=c --encoding "UTF8" --no-owner --verbose "db_name"
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search