25.2. Administration #
All administartion of BiHA cluster is managed by shardmand and shardmanctl like any Postgres Pro Shardman cluster, with its parameters defined under sdmspec.
25.2.1. Managing SSL #
You can enable or disable SSL only when creating a new cluster with shardmanctl. Once enabled, SSL cannot be disabled, and a new no-SSL cluster must be created.
25.2.2. Roles #
When you initialize the high-availability cluster, the biha_db database is created as well as the BiHA extension is created in the biha scheme of the biha_db database. Besides, the following roles are created and used:
biha_replication_useris the main role, explicitly specified insdmspec. It is a member of theBIHA_REPLICATION_ROLEandBIHA_CLUSTER_MANAGEMENT_ROLEroles and can request both client and replication connections.BIHA_CLUSTER_MANAGEMENT_ROLEallows execution of all BiHA extension functions.BIHA_REPLICATION_ROLEis used when running pg_rewind and pg_probackup.
25.2.3. Restoring the Node from the NODE_ERROR State #
In case of the NODE_ERROR state, reinitialize the nodes with errors, e.g.:
shardmactl shard -s shard-2 replicas reinit -n follower2
This error, like any other, is displayed when running shardmanctl cluster topology or shardmanctl status.
25.2.4. Recovering from a Backup #
As any other Postgres Pro Shardman, the nodes are restored with shardmanct probackup restore.