Chapter 2. Manage
Prev	Up	Postgres Pro Shardman 14.15.2 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.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. Logging

2.10.1. PostgreSQL Logs
2.10.2. shardmand Logs
2.10.3. Getting Information on Backend Crashes

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

pdf