Re: WAL Replication query

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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?

Laurenz Albe
Cybertec |

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux