Chapter 2. Manage
Prev
Up
Postgres Pro Shardman Documentation
Home
Next
Chapter 2. Manage
Table of Contents
2.1. Cluster Services
2.2. Scaling the Cluster
2.3. Rebalancing the Data
2.3.1. Automatically Rebalancing the Data
2.3.2. Manually Rebalancing the Data
2.4. Analyzing and Vacuuming
2.4.1. Autovacuum Daemon
2.4.2. Analyzing the Whole Database
2.4.3. Analyzing Global Tables
2.4.4. Analyzing Sharded Tables
2.4.5. Vacuuming
2.5. Access Management
2.5.1. Cluster Initialization Settings Related to Access Management
2.5.2. Managing Users and Roles
2.5.3. Managing Permissions on Sharded Tables
2.6. Backup and Recovery
2.6.1. Cluster Backup with
pg_probackup
2.6.2. Cluster Restore from a Backup with
pg_probackup
2.6.3. Merging Backups with
pg_probackup
2.6.4. Deleting Backups with
pg_probackup
2.7. Configuring Secure Communications with
etcd
2.7.1. Generating SSL Certificates
2.7.2. Configuring
etcd
and
shardmand
Services
2.7.3. Using
Shardman
Tools
2.8. Upgrading a Cluster
2.8.1. Upgrade Packages
2.8.2. Restart
Shardman
Services and Database Instances
2.8.3. Upgrade the Extension
2.9. Fault Tolerance and High Availability
2.10. Disaster Recovery Cluster Requirements
2.10.1. Terms and Abbreviations
2.10.2. High-level Description of the DRC
2.10.3. Management
2.10.4.
etcd
Keys
2.10.5.
WAL-sync monitor
2.10.6. Replication Topology
2.10.7. Hardware and Network Requirements
2.10.8. Replication Mechanisms
2.10.9. Monitoring and Management
2.10.10. Security
2.10.11. QA and Rollback
2.10.12. Backup in Geografically Distributed System
2.10.13. Documentation and Regulations
2.11. Logging
2.11.1.
PostgreSQL
Logs
2.11.2.
shardmand
Logs
2.11.3. Getting Information on Backend Crashes