Chapter 2. Manage
Prev	Up	Postgres Pro Shardman 14.19.1 Documentation	Home	Next

Chapter 2. Manage

Table of Contents

2.1. Cluster Services

2.2. Scaling the Cluster

2.2.1. Adding and Removing a Node

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_basebackup
2.6.2. Cluster Recovery from a Backup Using pg_basebackup
2.6.3. Cluster Backup with pg_probackup
2.6.4. Cluster Restore from a Backup with pg_probackup
2.6.5. Merging Backups with pg_probackup
2.6.6. 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.9.1. Timeouts

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

Prev	Up	Next
1.3. Quickstart Guide	Home	2.1. Cluster Services

epub pdf