chinnaobi wrote:
> You mean when the primary which is going to switch its role to
> standby might not have sent all the WAL records to the standby and
> If it is switched to standby it has more WAL records than the
> standby which is now serves as primary. Is it ??
What happens when there is a network fault between the primary and
the standby, but not between the primary and some of the clients
updating it? Similarly, if this is asynchronous replication, what if
there have been commits on the primary which were still in the
network buffer when the primary crashed?
Clean automated failover is not a trivial task. If you are writing
your own, it would be best to follow the steps recommended in the
documentation rather closely.
-Kevin