pg_restore works with zip file?

database postgresql pg-restore
Artem Fedotov picture Artem Fedotov · Oct 13, 2017 · Viewed 7.9k times · Source

Just trying to restore tutorial database from resource: http://www.postgresqltutorial.com/load-postgresql-sample-database/

so, after this code

pg_restore -U postgres -d dvdrental /Users/fedotarte/Downloads/dvdrental.zip

i got current message:

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

what should i do to restore database successfully?

Thank you in advance!

Answer

Artem Fedotov picture Artem Fedotov · Oct 13, 2017

.tar is also triggered as a invalid input file, after unzip dvdrental.zip i typed next command(pointed the folder):

pg_restore -U postgres -d dvdrental /Users/fedotarte/Downloads/dvdrental

And now it works correctly!

P.S.

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

Sorry about that....

Related questions

Backup and Restore option not available in pgAdmin III

I have to take backup of my database but when I right click DB and then backup The button for backup is disabled. Similarly in existing database ,not able to restore because the Restore button too disabled. I was working …

Read More
How to select the nth row in a SQL database table?

I'm interested in learning some (ideally) database agnostic ways of selecting the nth row from a database table. It would also be interesting to see how this can be achieved using the native functionality of the following databases: SQL Server …

Read More
What is this Javascript "require"?

I'm trying to get Javascript to read/write to a PostgreSQL database. I found this project on github. I was able to get the following sample code to run in node. var pg = require('pg'); //native libpq bindings = `var pg = …

Read More