Restoring a Database Backup
Use the pg_restore program to restore a database backup previously created with the pg_dump program.
Extensive documentation for this program is located at: https://www.postgresql.org/docs/9.5/static/app-pgrestore.html.
Minimal steps to restore a database backup are listed below. It is assumed that the superuser for the database is postgres. The superuser for Xpress Insight will be the same as the Windows account that installed the software.
The following commands assume that the database receiving the restored data is a clean database installed by the
Xpress Insight installer program.
set PGBIN=%XPRESSDIR%\insight\db\pgsql\bin set PGUSER=Postgres set BKFILE=insight.backup %PGBIN%\pg_restore -c -d insightdb %BKFILE%