4.2 Installing the PostgreSQL Database on a Windows Server

4.2.1 Minimum Requirements

  • Any of the following 64-bit multi-core processor servers:

    • Windows Server 2008 R2

    • Windows Server 2012

    • Windows Server 2012 R2

  • Minimum of 8 GB RAM

    Depending on the size and frequency of your scans, this amount might need to be significantly increased.

  • Disk space requirements:

    • Minimum 700 MB if the PostgreSQL database is installed on the same server as the NFR Engine

    • Minimum 350 MB if the PostgreSQL database is installed on a different server

    Depending on the size and frequency of your scans, these amounts might need to be significantly increased.

4.2.2 Installing and Configuring the PostgreSQL Database

  1. At the root of the NFR_2_6_0.iso image, double-click the PostgreSQL folder.

  2. Double-click the x86_64 folder.

  3. Double-click CC-PostgreSQL-9.4.1-1.exe.

  4. When you are asked if you want to run this file, click Run.

  5. Click Install.

  6. When you are notified that the setup was successful, click Run Configuration Utility.

  7. Click Next.

    An account ID and password are generated automatically. This ID and password are used by the PostgreSQL database service to log in to the local server with a restricted service account.

    You do not need to remember this ID and password because they are stored as a login credential on the server where you are installing the PostgreSQL database.

    You can generate a random password or specify your own password according to the password policies that are in effect on the server.

  8. Click Next.

  9. Create and verify a database superuser account name and password.

    You need to use this password later when you configure the NFR Engine and Web application.

  10. Leave the Host Address field setting at 0.0.0.0 so it uses all available network addresses.

  11. Unless there is a conflict, leave the port setting at 5432.

  12. Click Next.

  13. When you are notified that CC PostgreSQL has successfully been configured, click Finish.

  14. Do one of the following: