Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Postgres Tutorial: pg_restore: [archiver] input file does not appear to be a valid archive

I'm working through the Postgres DVD tutorial and am running into issues importing their sample database.

Running pg_restore -U postgres -d dvdrental ~[filepath]/dvd-database.tar.gz gives me pg_restore: [archiver] input file does not appear to be a valid archive.

My process so far has been the following:

  1. Download the dvdrental.zip file
  2. Extract it to a .tar using tar czf dvd-database.tar.gz dvdrental.zip (I've also tried extracting the zip to a folder first with the same result, as well as dropping the .gz)
  3. Running pg_restore -U postgres -d dvdrental ~[filepath]/dvd-database.tar as stated above.

I'm currently using Postgres 9.5, which may be causing the issue. Looking for an answer that points out where I'm going wrong in this process or how to update an archive of a Postgres database to 9.5.

like image 421
Charlie Weems Avatar asked Feb 06 '16 21:02

Charlie Weems


1 Answers

Per comments above, the solution was simple.

Extracting the dvdrental.zip file to an uncompressed .tar is not necessary as suggested in the tutorial instructions. pg_restore will work if pointed to the directory where the database dump was extracted:

pg_restore -U <username> -d dvdrental <your/path/to/extracted/dir>/dvdrental

like image 89
Charlie Weems Avatar answered Nov 15 '22 23:11

Charlie Weems