Comments (1)
Hi,
I was looking on patroni and repmgr and they both have some special flags to automate pg_rewind after failover.
Is there anything similar in PAF?
There's nothing similar in PAF, by design. It is quite scary to automatically get back online a failed node and removing some of its activity without manual checkup first, at least to pinpoint what was the crash origin and the real status of the node.
Its looks uncomfortable to get new promoted node when all nodes was rebooted accidentally (by some power supply issue or so) and then you need to do pg_ rewind manually.
You should not have to pg_rewind in such situation.
I expect you should just start manually the primary, then the secondaries, wait for them to settle, then restart the pacemaker stack.
- the PostgreSQL primary should recover
- then secondaries should resynch with it
- when starting Pacemaker, it should detect the clean status of all of them.
from paf.
Related Issues (20)
- Compatibility with Postgresql version 13 HOT 2
- Cluster with 3 nodes , 3rd node in different network HOT 1
- Postgres14 support.
- [PCS] postgres9.6 node in blocked state HOT 2
- Failover aborted due to error when trying to stop already stopped old primary HOT 3
- Maintenance status HOT 1
- problem during installation on almalinux 8.5 using postgres13 HOT 6
- Postgres start as slave in every severs HOT 2
- Auto Failover recovery HOT 4
- doc: add some metadata and manual doc about notify=1 HOT 1
- pgsqld monitor timed out on master when sync slave crashed HOT 3
- Check status of my resources HOT 4
- 2 node cluster, when master node is shutdown, promotion of pgsqld on slave is aborted HOT 21
- PAF without db user postgres
- PAF from Centos outdated for newer PCS/pacemaker - ? HOT 4
- PAF, Pacemaker, Postgres 15 and replication slots HOT 1
- PAF, PostgreSQL 15 and Debian 12 HOT 2
- Stale DB instance being promoted leads to data loss HOT 12
- Questions trying to im;le HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from paf.