ranyeli
2/16/2018 - 12:55 AM

Restore postgres database on windows

1. open cmd as administrator


2. C:\>cd C:\Program Files\PostgreSQL\9.5\bin

3, use the pg_restore tool to load data into the dvdrental database:
>pg_restore -U postgres -d dvdrental C:\temp\dvdrental.tar