01.06. Database management with Patroni (manual switchover)

                <<< Back   Next >>>

1. Check status Patroni
[postgres@pgsql-db01 ~]$ patronictl -c /etc/patroni/patroni.yml list -e

2. Switchover databases with Patroni

[postgres@pgsql-db01 ~]$ patronictl -c /etc/patroni/patroni.yml switchover

3. Show configuration cluster

[postgres@pgsql-db01 ~]$ patronictl -c /etc/patroni/patroni.yml show-config

4. Restart node

[postgres@pgsql-db01 ~]$ patronictl -c /etc/patroni/patroni.yml restart postgres postgres pgsql-db02

5. Change parameter

[postgres@pgsql-db01 ~]$ patronictl -c /etc/patroni/patroni.yml edit-config

6. Restart cluster

[postgres@pgsql-db01 ~]$ patronictl -c /etc/patroni/patroni.yml restart postgres

                <<< Back   Next >>>