Install PPM with PostgreSQL (Beta)

You can install PPM with a PostgreSQL database.

Note: This feature is introduced at Beta level. It is not field-tested enough. Do not use it in production environment.

Before you install

Before you install PPM with a Postgre SQL database, you must have the following ready:

  • You have installed a PostgreSQL database. The PostgreSQL version 11 is supported. For instructions, see the PostgreSQL documentation.

    Caution: In a server cluster configuration, each cluster must have its own database. Do not share a PostgreSQL database among clusters. However, you can create multiple databases in one PostgreSQL server.

  • You have installed the latest version of the orafce extension. For instructions, see https://github.com/orafce/orafce.

  • (Windows systems only) Make sure you have a UNIX emulator (such as Cygwin) installed. For information about the UNIX emulator and how to install it, see cygwin.com.

Back to top

Install PPM

Follow the steps below to install PPM with a PostgreSQL database:

  1. Obtain the installation bundle for PostgreSQL: ppm_10.0_install_PostgreSQL.zip from the Software Licenses and Downloads Portal.

  2. Extract the ppm_10.0_install_PostgreSQL.zip package.

    The extraction creates the ppm-1000-install-pg directory.

  3. Open the ppm.env file in the ppm-1000-install-pg directory, and edit the values for the following parameters:

    Parameter Description
    PPM_HOME The folder where your PPM file system is to be installed.
    PGHOST The host of the server where the PostgreSQL database is installed.
    PGPORT

    The port of the server where the PostgreSQL database is installed.

    PPM_DB_NAME Name of the PostgreSQL database that PPM uses.
    PG_SYSTEM Superuser username for the PostgreSQL database.
    PG_SYSTEM_PASSWORD Superuser password for the PostgreSQL database.
    PPM_DB_USER User name for the PPM Center database.
    PPM_DB_PASSWORD Password for the PPM Center database.
    LOCAL_IP The IP or hostname of the server where PPM is to be installed.
    HTTP_PORT PPM server HTTP port.
    RMI_PORT PPM server RMI port.
    JMS_PORT PPM server JMS port.
  4. In the ppm-1000-install-pg directory, run the sh kInstall.sh file.

  5. (Optional) Configure the server.conf parameters in PPM. For details, see Server Configuration Parameters.

  6. In the <PPM_Home>/bin directory, run the kUpdateHtml.sh to deploy the configurations.

  7. Install the license file by running the kLicenseInstall.sh command.

  8. Start the PPM server by running the kStart.sh script.

Back to top

Limitations

Using PPM with a PostgreSQL database has the following limitations:

  • Only the fresh installation is supported.

  • Only the English language is supported.

  • The following modules, special commands, and reports are tested. They can work in most scenarios, but may not be fully stable.

    Modules
    • Demand Management

    • Project Management

    • Program Management

    • Time Management

    • Portfolio Management

    • Resource Management

    • Financial Management

    • User Administration

    • Dashboard

    Special commands
    • ksc_comment

    • ksc_create_baseline

    • ksc_create_project

    • ksc_run_sql

    • ksc_set

    • ksc_set_staffing_profile_status

    • ksc_take_snapshot

    • ksc_update_program_status

    • ksc_update_project_status

    • ksc_update_workplan_status

    • ksc_create_baseline_staffing_profile

    Reports
    • Import Users

    • Requested Detail Report

    • Notification History Report

    • Run License Usage Report

    • Delinquent Time Sheets

    Note: Other modules, special commands, and reports that are not listed above are not verified.

  • The following PPM-supplied portlets do not work with PostgreSQL:

    • Portfolio by Category

    • Project Current Cost Metrics

    • Financial Summary to Financial Data Comparison

    • Financial Comparison

    • Operational Report

  • What-if Analysis does not work with PostgreSQL.

Back to top