If replication is in asynchronous then there will be data loss, right Laurenz? Thanks, Sacheen Birhade. -----Original Message----- From: Laurenz Albe <laurenz.albe@xxxxxxxxxxx> Sent: Tuesday, November 1, 2022 12:11 PM To: KK CHN <kkchn.in@xxxxxxxxx>; pgsql-admin@xxxxxxxxxxxxxxxxxxxx Subject: [External] Re: WAL Replication query 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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cybertec-postgresql.com%2F&data=05%7C01%7Csacheen.birhade%40veritas.com%7Ce6d7b7ce704e44eaa52208dabbd41e93%7Cfc8e13c0422c4c55b3eaca318e6cac32%7C0%7C0%7C638028816981291760%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=e5mP%2BJjxdGUSMFXWUowX0CUZJYDOu%2FRneDQ0jSSK3nA%3D&reserved=0
