Configuration

Suggest edits

Implementing Pure Storage FlashArray with EDB Postgres Advanced Server, EDB Postgres Extended Server or PostgreSQL Server requires the following components:

Note

The EDB Postgres Advanced Server, EDB Postgres Extended Server and PostgreSQL Server products will be referred to as Postgres Distribution. The specific Distribution type will be dependant upon customer need or preference.

  • An active Postgres Distribution.
  • Pure Storage FlashArray subscription.
  • Additional hardware as described in the Hardware Environment Requirements section of the Pure Storage Best Practices document.

Prerequisites

  • A running Postgres Distribution.
  • Linux or Windows File System Configuration as defined in the FlashArray Implementation and Best Practices documentation.
  • The hardware protocol for your instance.
  • The layout defined for where the FlashArray volumes will be mounted.

Configure Pure Storage FlashArray for Postgres Distribution

Configuring Pure Storage FlashArray for your Postgres Distribution requires the following steps to be taken.

  1. First you must select your OS (either Windows or Linux) and configure to your specifications according to the PostgreSQL on FlashArray Implementation and Best Practices document.

  2. Install your preferred Postgres Distribution.

  3. Initialize your Postgres Distribution.

There are best practices for both Linux and Windows servers for Flash Array and these can be found at Linux Recommended Settings and Validate Windows Server with Test-WindowsBestPractices Cmdlet respectively.

Selecting Pure Storage FlashArray Hardware Environment Requirements for Postgres Distribution

In order to access your block storage on Pure Storage FlashArray, you must first define which protocol is best for your environment and then set up that protocol. Listed below are the different types of protocols for FlashArray and their requirements.

FlashArrayHardwareRequirements

More information on these protocols and their requirements can be found in the PostgreSQL on FlashArray Implementation and Best Practices document.

Note

Note from Pure Storage: The recommendation for volumes from FlashArray is to mount a volume to the following locations with the correct permissions set before installing PostgreSQL:
Microsoft Windows - C:\Program Files\PostgreSQL\ Permissions - PostgreSQL service account - READ Permissions on all directories leading up to the service directory, WRITE permissions are required only on the data directory
Linux - /var/lib/pgsql (Permissions - user postgres, group postgres, drwx------)

For EDB Postgres Advanced Server instances the volumes mount points are as follows:
Windows- C:\Program Files/edb/as-"version"
Linux- /var/lib/edb/"version"

Could this page be better? Report a problem or suggest an addition!