Aiven-Open / Aiven-Open/pghoard

pg_rewind support

Aperta
#129 0 commenti 0 reazioni 0 assegnatari Vedi su GitHub
enhancement
Lingua principale
Python
Stelle
1.4k
Fork
111
Merge medio
1g 5h
PR unite (30g)
2

Descrizione

It's pretty common to promote a replica server of a database cluster when performing maintenance, i.e. maintenance is first done on the replica and after the maintenance is done and replica is fully synced up the old master is shut down and replica promoted. Typically we want to make the old master a replica after maintenance has been performed there, but PG doesn't allow master to switch roles to a replica too easily.

pg_rewind can be used for this, but running it is a bit cumbersome and access to WAL archive is required after it has been run, so it would be useful if PGHoard could take care of running pg_rewind and then setting up the old master as a replica, with proper recovery.conf pointing to PGHoard's wal archive and an optional primary_conninfo line connecting it to the new master.

Guida per i contributori

Nessuna guida per i contributori indicizzata per questo repository

Valutazione

Questa issue non è ancora stata valutata.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.