Initializing help system before first use

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%
Parent Topic Using the PostgreSQL Database Tools

© 2001-2019 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.