Managing a WarehousePG Cluster v7.4

This section describes basic system administration tasks performed by a WarehousePG cluster administrator.

• About the WarehousePG Release Version Number
  WarehousePG version numbers and the way they change identify what has been modified from one WarehousePG release to the next.
• Starting and Stopping WarehousePG
  In a WarehousePG DBMS, the database server instances (the coordinator and all segments) are started or stopped across all of the hosts in the system in such a way that they can work together as a unified DBMS.
• Accessing the Database
  This topic describes the various client tools you can use to connect to WarehousePG, and how to establish a database session.
• Configuring the WarehousePG cluster
  Server configuration parameters affect the behavior of WarehousePG.
• Enabling Compression
  You can configure WarehousePG to use data compression with some database features and with some utilities.
• Configuring Proxies for the WarehousePG Interconnect
  You can configure a WarehousePG cluster to use proxies for interconnect communication to reduce the use of connections and ports during query processing.
• Enabling High Availability and Data Consistency Features
  The fault tolerance and the high-availability features of WarehousePG can be configured.
• Backing Up and Restoring Databases
  This topic describes how to use WarehousePG backup and restore features.
• Expanding a WarehousePG cluster
  To scale up performance and storage capacity, expand your WarehousePG cluster by adding hosts to the system. In general, adding nodes to a WarehousePG cluster achieves a linear scaling of performance and storage capacity.
• Monitoring a WarehousePG cluster
  You can monitor a WarehousePG cluster using a variety of tools included with the system or available as add-ons.
• Monitoring Long-Running Operations
  You can monitor, at run time, the progress of certain SQL and utility commands.
• Routine System Maintenance Tasks
  To keep a WarehousePG cluster running efficiently, the database must be regularly cleared of expired data and the table statistics must be updated so that the query optimizer has accurate information.
• Recommended Monitoring and Maintenance Tasks
  This section lists monitoring and maintenance activities recommended to ensure high availability and consistent performance of your WarehousePG cluster.

Parent topic: WarehousePG Administrator Guide