Initializing help system before first use

Using the PostgreSQL Database Tools

By default, Xpress Insight uses a PostgreSQL 9.5 database server included with the distribution.

In addition to understanding the notes in this section, for enterprise-class deployments of Xpress Insight, system administrators should be proficient in the use of the PostgreSQL command line tools for the backup and restoration of PostgreSQL database. Additionally, an enterprise-class backup system should include a backup rotation policy. Such further guidance is outside the scope of this document.

Note The following instructions assume that PostgreSQL user authentication is disabled. If enabled, the following steps will need to be modified to incorporate the password of the PostgreSQL user account - this can be achieved by setting the PGPASSWORD environment variable.

Extensive options for PostgreSQL backup are described in the online documentation for the database: https://www.postgresql.org/docs/9.5/static/backup-dump.html.

The following steps describe the actions necessary to implement backup and restore using the pg_dump and pg_restore utilitity tools provided. FICO is unable to provide support for alternative methods of backing up and restoring the PostgreSQL database.

Covered Topics
  • Creating a Database Backup
    Use the pg_dump program to create a backup file from the PostgreSQL database.
  • Restoring a Database Backup
    Use the pg_restore program to restore a database backup previously created with the pg_dump program.
  • Tuning the Mirror Database
    The default configuration settings for the mirror database are appropriate when data volumes are relatively small or infrequently mirrored. When a lot of scenario data is being mirrored, the size of the database on disk can grow to be much larger than the actual amount of mirrored data being stored.
Parent Topic Backing up and Restoring the Repository

© 2001-2020 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.