Installing and upgrading WarehousePG v7.4

Information about installing, configuring, and upgrading WarehousePG software and configuring WarehousePG host machines.

• Platform Requirements
  This topic describes the WarehousePG 7 platform and operating system software requirements.
• Estimating Storage Capacity
  To estimate how much data your WarehousePG cluster can accommodate, use these measurements as guidelines. Also keep in mind that you may want to have extra space for landing backup files and data load files on each segment host.
• Configure Operating System
  Describes how to prepare your operating system environment for WarehousePG software installation.
• Installing WarehousePG
  Describes how to install the WarehousePG software binaries on all of the hosts that will comprise your WarehousePG cluster, how to enable passwordless SSH for the gpadmin user, and how to verify the installation.
• Creating the Data Storage Areas
  Describes how to create the directory locations where WarehousePG data is stored for each coordinator, standby, and segment instance.
• Validating the WHPG Cluster
  Validate your hardware and network performance.
• Initializing WarehousePG
  Describes how to initialize a WarehousePG database system.
• Installing Optional Extensions
  Information about installing optional WarehousePG extensions and packages, such as the Procedural Language extensions and the Python and R Data Science Packages.
• Installing Extensions
  The WarehousePG distribution includes several PostgreSQL- and WarehousePG-sourced contrib modules that you have the option to install.
• Configuring Timezone and Localization Settings
  Describes the available timezone and localization features of WarehousePG.
• Important Changes Between WHPG 6 and WHPG 7 Describes the changes between WarehousePG 6 and WarehousePG 7 that could potentially affect your existing 6 application when you move to 7.
• Performing a minor upgrade
  Explains how to upgrade to a newer version of WarehousePG 7.x.
• Upgrading from whpg 6 to whpg 7
  Explains how to upgrade from WarehousePG 6 to WarehousePG 7.
• Migrating Partition Maintenance Scripts to the New WarehousePG 7 Partitioning Catalogs Provides guidance on migrating partition maintenance scripts that you may have written for WarehousePG 6 to use the new partitioning system catalogs in WarehousePG 7.
• Enabling iptables (Optional)
  On Linux systems, you can configure and enable the iptables firewall to work with WarehousePG.
• Installation Utilities Reference
  References for the command-line management utilities used to install and initialize a WarehousePG cluster.
• WarehousePG Environment Variables
  Reference of the environment variables to set for WarehousePG.
• Example Ansible Playbook A sample Ansible playbook to install a Greenplum Database software release onto the hosts that will comprise a Greenplum Database system.