Installing and Upgrading WarehousePG v6.27.4

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

• Platform Requirements
  This topic describes the WarehousePG 6 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 the WarehousePG Software
  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 Your Systems
  Validate your hardware and network performance.
• Initializing WarehousePG
  Describes how to initialize a WarehousePG database system.
• Installing Optional Extensions (WarehousePG)
  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.
• Upgrading to WarehousePG 6
  This topic identifies the upgrade paths for upgrading a WarehousePG 6.x release to a newer 6.x release.
• Migrating WarehousePG from Enterprise Linux 7 to 8 or 9 This topic describes how to migrate a WarehousePG installation from Enterprise Linux (EL) version 7 to Enterprise Linux 8 or Enterprise Linux 9, while maintaining your existing version of WarehousePG.
• Enabling iptables (Optional)
  On Linux systems, you can configure and enable the iptables firewall to work with WarehousePG.
• Installation Management Utilities
  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 WarehousePG software release onto the hosts that will comprise a WarehousePG cluster.