Creating PostgreSQL databases and setting up the database server

This topic describes how to set up and configure PostgreSQL database for a TrueSight Network Automation - Data Warehouse installation. For information about the databases supported for use with Network Automation - Data Warehouse, see System-requirements.

While setting up the database described in these instructions, record the database parameter values. You are prompted for the database parameter values during the Network Automation - Data Warehouse installation.

To create the PostgreSQL database

1. On the database server, create a database (for example, BCAN_DWH) for the data warehouse.

   Warning

   Embedded PostgreSQL

   Do not create the database on a TrueSight Network Automation embedded PostgreSQL server. Database created on an embedded PostgreSQL server is not maintained (backed up or upgraded) during product upgrades.

   If the database must reside on an embedded PostgreSQL server, you must back up the database before upgrading Network Automation, and restore it after the upgrade is completed. Complete this backup and restore process before upgrading Network Automation - Data Warehouse.

   Use the following guidelines for the database name and password:

   Warning

   Important

   • If you are creating database with any other name, do not use any special characters in the name.
   • Database password cannot contain more than 16 characters.
   • Database password cannot contain any special characters, such as the following:
     • Exclamation mark (!)
     • Ampersand symbol (&)
     • Dollar symbol ($)
2. The user who connects to this database during the installation must have complete control of the database. Grant the user the following permissions:
   • create tables
   • drop
   • truncate
   • create views
   • create functions
   • create stored procedures
   • login
3. Verify that the user can log on to the database and perform these actions.

To verify the database server setup

Before beginning the installation, verify that the database server has enough space and meets the following requirements:

• The database server must be accessible from the reporting and application servers in your deployment.
• The HBA.config file must be configured correctly to have access to the servers used in your deployment.
• Ensure that there are no port conflicts.