WAL Replication query

From: KK CHN <kkchn(dot)in(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: WAL Replication query
Date: 2022-11-01 05:55:27
Message-ID: CAKgGyB-SMT0RxeoifAfjkRx6RHEOgpn7sf8F_zD1DPsKydTu=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

List,

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 ?
Those won't replicate to the standby right ?

How much data loss occurs in this case ?
What is the mechanism to overcome this uncommitted transaction loss due to
primary server crash which is not replicated to the standby server ?

Thank you,
Krishane

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2022-11-01 06:41:11 Re: WAL Replication query
Previous Message abbas alizadeh 2022-11-01 03:53:53 Pg_upgrade issue