Chapter 2. Developer Guide

Table of Contents

2.1. Limitations of Shardman
2.1.1. ALTER TABLE Limitations
2.1.2. CREATE TABLE Limitations
2.1.3. DROP TABLE Limitations
2.1.4. CREATE INDEX CONCURRENTLY Limitations
2.1.5. UPDATE Limitations
2.1.6. Limitations of Managing Global Roles
2.1.7. ALTER SCHEMA Limitations
2.1.8. DROP SERVER Limitations
2.1.9. Other Limitations
2.2. Shardman Architecture
2.2.1. Cluster Structure
2.2.2. Cluster Services
2.2.3. Shardman Extension
2.3. Consistency Model
2.4. Access Management
2.4.1. Cluster Initialization Settings Related to Access Management
2.4.2. Managing Users and Roles
2.4.3. Managing Permissions on Sharded Tables
2.5. Backup and Recovery
2.5.1. Cluster backup with pg_basebackup
2.5.2. Cluster recovery from a backup using pg_basebackup
2.5.3. Cluster backup with pg_probackup
2.5.4. Cluster restore from a backup with pg_probackup
2.6. Configuring Secure Communications with etcd
2.6.1. Generating SSL Certificates
2.6.2. Configuring etcd and shardmand Services
2.6.3. Using Shardman Tools