Category: Task

Source: https://patroni.readthedocs.io/en/latest/contributing_guidelines.html Chatting If you have a question, looking for an interactive troubleshooting help or want to chat with other Patroni users, join us on channel #patroni in the PostgreSQL …

Source: https://patroni.readthedocs.io/en/latest/existing_data.html This section describes the process for converting a standalone PostgreSQL instance into a Patroni cluster. To deploy a Patroni cluster without using a pre-existing PostgreSQL …

Source: https://patroni.readthedocs.io/en/latest/kubernetes.html Patroni can use Kubernetes objects in order to store the state of the cluster and manage the leader key. That makes it capable of operating Postgres in Kubernetes environment without …

Source: https://patroni.readthedocs.io/en/latest/pause.html The goal Under certain circumstances Patroni needs to temporarily step down from managing the cluster, while still retaining the cluster state in DCS. Possible use cases are uncommon …

Source: https://patroni.readthedocs.io/en/latest/standby_cluster.html Patroni also support running cascading replication to a remote datacenter (region) using a feature that is called “standby cluster”. This type of clusters has: “standby leader”, …

Source: https://patroni.readthedocs.io/en/latest/replica_bootstrap.html Patroni allows customizing creation of a new replica. It also supports defining what happens when the new empty cluster is being bootstrapped. The distinction between two is …

Source: pinned upstream README.md, section “Incremental Reports”. Incremental mode stores parsed statistics in binary form, then builds one HTML report per day, a cumulative report per week, and a calendar-style index linking them together. It is …

Source: pinned upstream README.md, section “Parallel Processing”. pgBadger has two complementary multiprocessing modes. Choose according to the shape of the input, not simply the number of CPUs. Option Parallel unit Best fit Main constraint -j N / …

Source: https://www.pgbouncer.org/usage.html Synopsis pgbouncer [-d][-R][-v][-u user] <pgbouncer.ini> pgbouncer -V|-h On Windows, the options are: pgbouncer.exe [-v][-u user] <pgbouncer.ini> pgbouncer.exe -V|-h Additional options for setting up a …