Behaviour of failed Primary - Mailing list pgsql-hackers

From Santhosh Kumar
Subject Behaviour of failed Primary
Date
Msg-id CANCPq3g-2bpoukLyHpM3txrNusfjFwow6Q5sL3qXVdPD+CwmUw@mail.gmail.com
Whole thread Raw
Responses Re: Behaviour of failed Primary
Re: Behaviour of failed Primary
List pgsql-hackers
Hi Forum,
 If I have a cluster with Synchronous replication enabled with three nodes, for eg:

[primary] [hot stand by 1] [host stand by 2]

And for some unforeseen reasons, if primary fails, the failover will kick in and hot stand by 1 will become new primary and  cluster setup will look like this

[new primary (hot stand by1)] [host stand by 2]

My question here is, what will happen if the original primary which has failed comes back. Will it become part of this high available replica cluster automatically or it will be stale and disconnected from the cluster? 

How can we automatically make the failed primary to be part of the cluster with hot standby role? It would be of great help, if you can direct me to any references details. Thank you, upfront.

Regards,
Santhosh


pgsql-hackers by date:

Previous
From: John Naylor
Date:
Subject: Re: PostgreSQL 13 Beta 1 Release Announcement Draft
Next
From: David Rowley
Date:
Subject: Re: Parallel Seq Scan vs kernel read ahead