Installing and upgrading WarehousePG v7.4
This section is adapted from the WarehousePG v7.x documentation
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 thegpadminuser, 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-sourcedcontribmodules 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 theiptablesfirewall 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.