On Tue, 2022-11-01 at 11:25 +0530, KK CHN wrote: > I am trying WAL replication,the setup is working with a primary and Standby server. > > Query is : When the primary crashes due an unforeseen reason, > what may happen to the uncommitted transactions at primary ? Their effects remain invisible. > Those won't replicate to the standby right ? They may be replicated, but their effects will remain invisible there too. > How much data loss occurs in this case ? Data loss? I don't understand. There is no data loss with replication. If an incomplete transaction is rolled back, that is no data loss. > What is the mechanism to overcome this uncommitted transaction loss due to primary > server crash which is not replicated to the standby server ? I don't understand. Are you perhaps talking about failover? Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
