Installing and Upgrading WarehousePG v6.27.4
This section is adapted from the WarehousePG v6.x documentation
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 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 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-sourcedcontribmodules 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 theiptablesfirewall 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.