CODEWITHSUNDEEP
pgadmin
Shruti Rawat
Shruti Rawat

Reputation: 697

Data dump restore though pgAdmin

I have backup file in *.backup format. When I am trying to restore i through pgAdmin in postgres db it's giving me error - pg_restore: [archiver] input file does not appear to be a valid archive.

No sure how to restore the dump. In pgAdmin I am just right clicking on dg and selecting restore and then browsing the path of backup file.

Upvotes: 0

Views: 1473

Answers (1)

João Costa
João Costa

Reputation: 2355

I've managed to do it by importing the backup using psql:

psql --host localhost --port 5432 --username "username" --dbname "database"  < backup.backup

Upvotes: 2

Related Questions