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
0
votes
1 answer

how to debug and fix google gke, spilo/patroni pod label update that returns error code 4, Gateway Timeout

I'm using zalando's postgres operator and been having postgres cluster downtime now. I'm using connection pooler to connection to master and replica, but replica connection pooler not able to connect to replica pod due to replica svc does not have…
shadowlegend
  • 373
  • 2
  • 7
  • 21
0
votes
2 answers

Patroni switchover. How to choose target server in API-request?

Simple question. We have Postgres cluster with 3 servers, for example: - serverA_1 - serverA_2 - serverB. Server A-2 cant't be leader without manual switch. For example right now leader is serverA-1. I want't to switchover leader in serverB. What…
sadux
  • 23
  • 5
0
votes
0 answers

patroni pg_hba.conf issue

I've added a new node to my patroni cluster, and have added, via patronictl, the ip address for replication. This is my config file: loop_wait: 10 maximum_lag_on_failover: 1048576 postgresql: parameters: checkpoint_timeout: 30 hot_standby:…
Larry G. Wapnitsky
  • 1,216
  • 2
  • 16
  • 35
0
votes
1 answer

Where can I find information about roadmap "pgbouncer", "Etcd", "patroni"?

Could you please tell me if there is information about the update schedule(when support for different versions ends, when new ones are planned to be released). Is there a link to this information(graph, table) ? Thanks
Nik238ss
  • 1
  • 1
0
votes
1 answer

PostgreSQL - Etcd - Patroni Cluster Restoration Problem

I am trying to create PostgreSQL - Etcd - Patroni(PEP) cluster. There are lots of examples on the internet and I have created one and it runs perfect. Yet, this architecture should comply with my company' s backup solution which is NetApp. We are…
Umut TEKİN
  • 856
  • 1
  • 9
  • 19
0
votes
0 answers

Bring up PostgreSQL 13 cluster with Patroni and enabling scram-sha-256

I am trying to bring up a PG13 cluster via patroni along with "scram-sha-256" password_encryption. Besides, I have changed the default md5 to scram-sha-256 in pg_hba.conf as well. However, once patroni was trying to bring the instance up, it…
joker57
  • 110
  • 7
0
votes
1 answer

Exposing a Postegres / Patroni db on Openshift to outside world

I am planning to run an SSIS ETL job , which has a sql server as SOURCE db , this is on a physical on-premise machine and the DESTINATION db (postegres/patroni) is running on Openshift platform as pod/containers. The issue I am facing now is like,…
user1597990
  • 181
  • 3
  • 13
0
votes
0 answers

Can not find suitable configuration of distributed configuration store when initializing Patroni as sudo

I followed the example described here https://www.opsdash.com/blog/postgres-getting-started-patroni.html and everything works as expected. While testing, I tried sudo patroni pg-2.yml. The output was: 2022-01-13 11:39:22,316 INFO: Failed to import…
Yannis_Fr
  • 1
  • 1
0
votes
1 answer

How to cancel a broken StatefulSets rolling update?

I have a PostgreSQL Kubernetes Service based on Patroni/Spilo. This Kubernetes service deploys a cluster of three PostgreSQL pods + three Etcd pods. During maintenance, I had a failure and I wasn't able to restore the old configuration that worked…
Salvatore D'angelo
  • 1,019
  • 3
  • 14
  • 39
0
votes
0 answers

Patroni Cluster Switchover Assistance

I am trying to create an automated shell script that will perform a patroni switchover. This will promote a leader within a 3-node cluster, and then reboot the replicas. I have a curl command that can perform the switchover for the leader. But I am…
ljunplugged
  • 1
  • 1
0
votes
0 answers

All members disappeared from a patroni cluster

I have 2 members in patroni cluster (1-master and 1-replica). In logs i saw problem after master reconnecting to new etcd server: ERROR: Request to server http://etcd2:2379 failed: MaxRetryError('HTTPConnectionPool(host=\'etcd2\', port=2379): Max…
Re Og
  • 15
  • 7
0
votes
1 answer

Patroni, Postgres: Could not start WAL streaming: ERROR: requested starting point Y on timeline X is not in this server's history

I have 3 nodes Postgres cluster managed by patroni, Whenever my master node goes down and joins back as a replica, then the old master facing the below error: 2021-06-25T00:16:29.856133+00:00 host0 postgres_0[14131]: [7-2] #011DETAIL: This server's…
Dushyant Sapra
  • 585
  • 1
  • 8
  • 16
0
votes
1 answer

"Lag in MB" patroni/postgresql how do i troubleshoot it?

The replica's is getting behind. Where do i begin to troubleshoot this? I have looked in /var/log/patroni/patroni.log but don't see anything weird. Lag in MB postgres2 | 192.168.1.26 | Replica | running | 5…
vonanka
  • 23
  • 2
  • 11
0
votes
1 answer

Patroni Does Not Change wal_level in postgresql.conf

I modify wal_level in patroini yaml file from replica to logical and ran the following commands. However, the value was not changed in postgresql.conf. What am I missing? Is there a way to change DCS parameters? I even tried to use alter database…
user1409708
  • 953
  • 2
  • 11
  • 20
0
votes
1 answer

Patroni Cluster initializing with scram-sha 256

When I am trying to install patroni , I can initialize database with md5 , all the cluster is working well. . But when i tried to install patroni with initializing scram-sha 256 . It is not starting also status stay "replica" for all database…
curios
  • 1
  • 1
1 2
3
4