On Tue, 2022-11-01 at 08:49 -0500, Ron wrote: > Primary has crashed, according to OP; it's not coming back any time soon. And thus you promote > Secondary to be New Primary, and go about your work. When the Old Primary comes back up > (hours or days later), you do a pg_basebackup to make it the New Secondary. There was no word about failover or "not coming back any time soon" (that's why I asked for clarification in my answer). In fact, PostgreSQL will often undergo crash recovery and come back up automatically. See the parameter "restart_after_crash", which defaults to "on". Yours, Laurenz Albe
