Re: [External] WAL Replication query - Mailing list pgsql-admin

From Scott Ribe
Subject Re: [External] WAL Replication query
Date
Msg-id 66DBCDC1-335A-463C-A7B6-8FC79D8548D4@elevated-dev.com
Whole thread Raw
In response to Re: [External] Re: WAL Replication query  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
> On Nov 1, 2022, at 7:34 AM, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
>
> Right.  And how does that constitute data loss?  If you start the primary again, the transaction
> will be replicated just fine.  Now if you call it *data delay*, I would agree.

It comes down to this: there is no magic. Replication is async with delay between primary & secondary, or replication
issynchronous with the delay visible to clients. Transaction commit completes, or it doesn't. And so on. 


pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: [External] Re: WAL Replication query
Next
From: Laurenz Albe
Date:
Subject: Re: [External] Re: WAL Replication query