I work through a Postgres DVD tutorial and run 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 as follows:
- Download the dvdrental.zip file
- Extract it to .tar using
tar czf dvd-database.tar.gz dvdrental.zip (I also tried to extract the zip to the folder first with the same result and also delete .gz) - Running
pg_restore -U postgres -d dvdrental ~[filepath]/dvd-database.tar as above.
I am currently using Postgres 9.5, which may cause a problem. Looking for an answer that indicates where I am making a mistake in this process, or how to update the archive of a Postgres database to 9.5.
source share