Installing and Configuring Crunchy PostgreSQL For PCF

This topic describes how to install and configure Crunchy PostgreSQL for Pivotal Cloud Foundry (PCF).

Import the Tile to Ops Manager

  1. Download the product file from Pivotal Network.

  2. Navigate to the Ops Manager Installation Dashboard and click Import a Product to upload the product file.

  3. Click Add next to the uploaded Crunchy PostgreSQL for PCF tile in the Ops Manager Available Products view to add it to your staging area.

Configure the Service

Click the newly added Crunchy PostgreSQL tile on the Ops Manager Installation Dashboard to open the configuration panes. Configure each section as described below.

Crunchy PostgreSQL tile

Configure Availability Zones and Networks

To make Crunchy PostgreSQL highly available, you must balance the service across multiple availability zones.

  1. Click Assign AZs and Networks.
    Assign AZs and Networks pane

  2. Choose an availability zone to deploy singleton jobs.

  3. Choose extra availability zones to balance jobs. To maximize uptime, balance as many jobs as possible across multiple AZs.

  4. Choose the network to deploy Crunchy PostgreSQL to.

  5. Click Save.

PostgreSQL Configuration

You can tune Crunchy PostgreSQL in various ways to meet the demands of the apps that use it. This section provides guidance on how to tune these settings.

  1. Click PostgreSQL Configuration.
    PostgreSQL Configuration pane

  2. Enter an integer for the Max Connections setting for PostgreSQL. This setting is the maximum allowed concurrent connections to the database. For more information, see the official PostgreSQL documentation.

  3. Enter the amount of memory allowed for Shared Buffers. This sets the amount of memory the database server uses for operations. For more information, see the official PostgreSQL documentation.

  4. Enter the amount of memory allowed for Maintenance processes such as VACUUM and CREATE INDEX.
    For more information, see the official PostgreSQL documentation.

  5. Enter the number of WAL Segments that that are kept on the database servers, for replication of the write-ahead log (WAL). For more information, see the official PostgreSQL documentation.

  6. Enter the Max WAL Size before automatic WAL Checkpoint is activated.
    For more information, see the official PostgreSQL documentation.

  7. Enter the Max Worker Processes to specify how many concurrent processes the system can support. For more information, see the official PostgreSQL documentation.

  8. Enter the amount of memory allowed for WAL Buffers. This memory is used to store WAL that hasn’t been written to disk yet. For more information, see the official PostgreSQL documentation.

  9. Click Save.

Acceptance Tests Configuration

The Crunchy PostgreSQL tile deploys a test application to Cloud Foundry to verify the installation was successful. Perform the following steps to deploy the test application:

  1. Click Acceptance Tests Configuration.

  2. Enter an org name that already exists in Cloud Foundry. Use Apps Manager to find an org that already exists.

  3. Enter a space name that already exists in Cloud Foundry. Use Apps Manager to find a space that already exists.

  4. Click Save.

Resource Configuration

You can configure Crunchy PostgreSQL and its services to meet any application demand.
Choose VM types for the PostgreSQL servers that make sense for your requirements.

  1. Click Resource Config.
    Resource Config pane

  2. Review the pre-populated recommended server sizes and make any changes.

  3. Click Save.

Install the Tile

Return to the Ops Manager Installation Dashboard and click Apply Changes to install the Crunchy PostgreSQL for PCF tile.

Was this helpful?
What can we do to improve?
Create a pull request or raise an issue on the source for this page in GitHub