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 database system 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. - 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