Stack Overflow
Stack Overflow

Questions tagged [patroni]

Patroni is a cluster management software for PostgreSQL that provides automatic failover for high availability. It uses PostgreSQL streaming replication and a third-party distributed consensus store. Use this tag for questions about Patroni code and its usage or for questions about software architecture involving PostgreSQL high availability.

Patroni is a solution that can use , , or as its distributed consensus store. This holds the shared configuration and is used to determine which nodes are available and who should be the streaming replication primary.

Patroni manages the PostgreSQL servers on each node, initializing and promoting them as required. Managing the cluster and the PostgreSQL is done with the patronictl command.

Resources:

54 questions
1
vote
0 answers

Postgresql-Patroni-Etcd election handicapping

I am planning the creation of a PostgreSQL HA cluster that spans multiple data centres on different continents and trying to figure out how to tweak the election parameters in etcd and patron so that we are unlikely to failover accidentally to a…
Chris Travers
  • 25,424
  • 6
  • 65
  • 182
1
vote
2 answers

Postgresql Patroni documentation on installation/troubleshooting

Anyone aware where I can find further documentation on Patroni? https://github.com/zalando/patroni I've looked into the github docs, but it doesn't contain much documentation on usage/problems found during installation/etc. It seems the examples…
Alexandre Santos
  • 8,170
  • 10
  • 42
  • 64
0
votes
1 answer

kubeadm init conflict with already setup etcd for HAProxy

On my Server1, Server2 and Server3, I've installed PostgreSQL and Patroni, and on Server1 only, I've installed HAProxy and etcd. Server1 is acting as master db and Server2 and Server3 are acting as replica. Since it is not a production setup, I'm…
Amartya Sinha
  • 47
  • 9
0
votes
0 answers

Postgres is not loading the Patroni YAML configuration

I have created the three-node Patroni cluster. The Patroni configuration are showing as we provided in the Patroni YAML file: postgres@postgresql0:~$ patronictl -c /etc/patroni.yaml show-config loop_wait: 10 maximum_lag_on_failover:…
Charu Gupta sheherhers
  • 1
  • 1
0
votes
0 answers

ERROR: [045]: WAL file 'xxxxx.partial' already exists in the repo1 archive with a different checksum

I have a PostgreSQL 11.9 cluster managed by Patroni 3 and I use PgBackrest 2.39 for backups management. This night I started see errors like this on a Production system: ERROR: [045]: WAL file '00000015000025A70000005D.partial' already exists in the…
Salvatore D'angelo
  • 1,019
  • 3
  • 14
  • 39
0
votes
1 answer

Patroni service can be run only as root

We have centos7, postgresql15, all required modules, configs are fine I cant run patroni as postgres user When i change patroni.service USER= and GROUP= to root, its runs well But if i change it to postgres It shows error in log: Failed to import…
Jan
  • 3
  • 1
0
votes
0 answers

Patroni HA setup Main PID: 3167 (code=exited, status=217/USER)

Here is a screen shot of patroni.service status: enter image description here Following is the configuration of my patroni.yml: scope: pg_cluster namespace: /service/ name: patroni1 restapi: listen: 192.168.56.11:8008 connect_address:…
Vishwajit Bhadrashetty
  • 3
  • 1
  • 5
0
votes
0 answers

patroni - permanent logical replication slots - not working

I am trying to implement logical replication in a postgres cluster, where cluster switchover/failover is managed by patroni. I am trying to leverage the permanent replication slot feature. Using patroni version 2.1.1 on Postgres version 13.5. I have…
EXK
  • 23
  • 4
0
votes
0 answers

Could not connect to the primary server: fe_sendauth: no password supplied for Postgresql

I am going to do Patroni Cluster with 4 nodes. 2 nodes are patroni (07,08) 1 node is haproxy(06) 1 node is etcd (05) 08 node is successfully joind the cluster. But 07 node is getting this error. (Versions: PostgreSQL 12.13, ubuntu…
HAKAN MAZI
  • 1
  • 1
0
votes
0 answers

Unable to start Patroni-Consul setup

We are trying to setup a 3-node PG with Patroni-Consul-Postgres, however Patroni fails to spinup the db with below error. I let it run for sometime but with no change in status. Which one is the service ID or is there some mismatch in my…
Oxycash
  • 167
  • 12
0
votes
0 answers

patroni.yml file configuration for psql HA mode

I m setting up an 3 node postgres HA setup with patroni and etcd for high availability. when I define data directory variable in patroni.yml file, same directory on all 3 nodes ( local path ) its working fine. but if i update different values for…
rishikanth
  • 21
  • 1
0
votes
1 answer

etcd fatal error: failed to reserve page summary memory

when i try to run etcd from user account (Total RAM: 8GB, virtual memory of 1GB) in a 64 bit Linux environment (limited resources), I am getting the following error: fatal error: failed to reserve page summary memory runtime…
Sreejith K
  • 9
  • 1
0
votes
0 answers

Required Configuration for DC-DR Sync in Patroni PostgreSQL Setup

We have a cluster of 3 nodes in DC and a cluster of 3 nodes in DR. I need to sync DR leader from DC Leader keeping both cluster separated from each other. Though I got a solution of adding parameter standby_cluster from link: DC-DR Sync issue in…
Aviral Singh
  • 1
  • 3
0
votes
0 answers

Haproxy Postgresql SSL configuration

I need ssl connection between postgresql (patroni cluster) and Haproxy but I didnt find any related docs. Is it possible to configure haproxy via ssl without using pgbouncer or pgpool tools. I can connect directly to the database server with ssl…
aliosman
  • 1
  • 3
0
votes
1 answer

podman error: Error: error creating build container: initializing source

I have a strange problem with podman. I have a large Dockerfile of an open source project called spilo that I was always able to build. Today for some strange reason the same code doesn't work anymore. It's true that I haven't used podman for a…
Salvatore D'angelo
  • 1,019
  • 3
  • 14
  • 39
1
2
3 4