cybertec-postgresql / pes

Patroni Environment Setup

PES: Patroni Environment Setup for Windows

Application can be used in two modes:

• interactive
• standalone configuration editor

In interactive mode PES instances, launched on different nodes, can syncrhonize cluster settings with Sync configs button and generate configurations locally. To enable interactive mode press Connect button:

If the machine were PES launched supposed to be one of the nodes, you can check Python dependancies:

PostgreSQL specific settings can be set on the corresponding tab. Right now all settings are the same for all nodes participating.

Nodes tab represent all nodes in the future cluster. Not every node must run database, this is the common setup where only two database and one witness node with etcd.

VIP Manager (if enabled) should run on every database node. Right now all settings are the same for all nodes participating.

Save button will save cluster information in the internal format to open and edit it later.

Load button will open previously saved cluster in internal format for further edit.

Generate Configs button will produce all needed configurations file for every node participated. The hierarchy will contain folders with node names containing .yaml configuration files depending on the node role (has db, has etcd, is vip-manager enabled), e.g.

db1
  - patroni.yaml
  - patronictl.yaml
  - etcd.yaml
db2
  - patroni.yaml
  - patronictl.yaml
  - etcd.yaml
witness
  - etcd.yaml
db_only
  - patroni.yaml
  - patronictl.yaml

---

Icon made by Vitaly Gorbachev

pes's Issues

Parser error for patroni.yaml

yaml.scanner.ScannerError: while scanning for the next token
found character '\t' that cannot start any token
  in ".\patroni.yaml", line 15, column 1

add TVIPManager class

Add TCluster.SaveToStream and TCluster.LoadFromStream methods

add procedures SaveToFile/LoadFromFile(AFileName: string)

Add app tethering for local instances

add function TNode.GetEtcdConfig()

part of #3

Fix line breaks in mmLog

etcd produces LF instead of CRLF line breaks in output

Add config generation tab

add procedure TfmInstall.Invalidate()

Invalidate form controls with TCluster object

Sync TCluster object with changes on form immediately

automatically add nodes from tethering

Implement patroni start and check

Add vipmanager config generation

Implement etcd start and check

add support for etcd v3

Replace TcxTreeList with TVirtualStringTree

subj

Implement vip-manager start and check

Add check for Etcd cluster size

Etcd even cluster size not supported, use an odd number of nodes up to 7

Implement start/stop functionality

add function TNode.GetConfig()

• write_patroni_config
• write_patronictl_config
• write_etcd_config
• write_vip_config

Local instance in Tether tab shown as MULTIHOMED instead of IP

Local instance:
   MULTIHOMED:2021

Implement check for patroni packages

Check Python version and install\update if needed

add function TNode.GetPatroniConfig()

Part of a #3

Check etcd version and install\update if needed

add function TNode.GetPatroniCtlConfig()

part of #3

Incorrect value for nofailover property in patroni.yaml

nofailover: -1

cannot change node name in the grid

select current node automatically on "run & test" tab