Initializing help system before first use

Using the PostgreSQL Database Tools

By default, Xpress Insight uses a PostgreSQL 11.8 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