On 5/18/22 09:23, David Jordan wrote:
>
> Hi, folks;
>
> I’m a former Oracle database administrator of many years who is new to
> PostgreSQL. I’m in the process of testing PG v12.7 hot
> streaming standby’s in async mode, and specifically in the areas
> of switchover and switchback.
>
Async mode, huh?
In SQL Server, at least, you must be in synchronous replication mode before
doing a (manual or automatic) non-crash failover, to guarantee that all the
transaction log data has reached the replica before the switchover.
--
Angular momentum makes the world go 'round.