Sobes.tech

DBA / Database

How to perform a major upgrade of PostgreSQL in a Patroni cluster?

192

What is quorum in Patroni and why is it needed?

192

If the Postgres master has fallen and Patroni has switched it to a replica, how does the SQL server that pulls data from Postgres find out about this?

187

How to monitor replica lag from the master through the dashboard?

169

How to perform a minor update of PostgreSQL in a Patroni cluster?

166

How to configure master node selection in Patroni if one node is weaker and should not become primary?

163

What is LSN and how is it used to monitor replication lag?

160

What happens to a request during a leader restart in Patroni?

155

Can data be lost if the master crashes and WAL files haven't reached the replicas?

151

Реплики без короны — они в режиме read-only или нет?

147

Tell me about the architecture of Patroni PostgreSQL clusters

146

How to set up a floating IP through Patroni so that the client does not know which node it will connect to?

133

What happens to the cluster if quorum is not reached?.

127

Have you worked with Percona? Tell us about orchestration in Patroni.

116