Re: [External] Re: WAL Replication query

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