Restore via cmd

Restore via Script

"dbNome" = Nome do banco de dados criado no PostgresSQL

C:\Program Files\PostgreSQL\9.6\bin\

pg_restore -h 127.0.0.1 -p 5432 -U conttrade -Fc -j 8 -v -d "dbNome" C:\temp\dbCONTTRADE_Backup.dump

Outros exemplos de restore

D:\PostgreSQL\9.6\bin\
pg_restore -h 127.0.0.1 -p 5432 -U postgres -Fc -j 8 -v -d "dbPlugSales" C:\temp\dbPlugSales_Backup.dump

D:\PostgreSQL\9.6\bin\
pg_restore -h 127.0.0.1 -p 5432 -U postgres -Fc -j 8 -v -d "dbMec" C:\temp\dbMec_Backup.dump

Referências: TabNews WikiLivros

Last updated