Restore data to postgresql database using commandprompt

Question

I have a .backup file in D:\test; I need to restore this backup using commandline. I used below command. but it is not working;

psql.exe -U username -d dbname -f "d:\backup\myfile.backup"

also I used below too

psql -h hostname -U username -d databasename -f "D:\backup\myfil.backup"

Answer 1

I guess, you are using Postgresql under Windows. Then you have to switch to the directory where your pg_restore.exe lies.

e.g. create a batch file:

set DBname=myDatabaseName
set filename=myfile.backup

cd PostgreSQL\9.5\bin\

pg_restore.exe --host localhost --port 5432 --username "postgres" --dbname "%DBname%" --verbose "F:\Backup_DB\%filename%"