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
