On Thu, Mar 16, 2023 at 17:01, Melanie Plageman
wrote:
> On Thu, Mar 16, 2023 at 4:43 PM Tejasvi Kashi wrote:
> > Thanks a lot for your reply. It looks like this is exactly what I need.
> For my use case, I'm trying to get read-only transactions to wait for the
> replication of prior writes.
>
>
On Thu, Mar 16, 2023 at 4:43 PM Tejasvi Kashi wrote:
> Thanks a lot for your reply. It looks like this is exactly what I need. For
> my use case, I'm trying to get read-only transactions to wait for the
> replication of prior writes.
can't you use remote_apply?
https://www.postgresql.org/docs/
Hi Bharath,
Thanks a lot for your reply. It looks like this is exactly what I need. For
my use case, I'm trying to get read-only transactions to wait for the
replication of prior writes.
Sincerely,
Tej Kashi
MMath CS, University of Waterloo
Waterloo, ON, CA
On Thu, 16 Mar 2023 at 01:36, Bharath
On Thu, Mar 16, 2023 at 1:18 AM Tejasvi Kashi wrote:
>
> For my use case, I'm trying to ascertain if there are any in-flight
> transactions that are yet to be replicated to synchronous standbys (in a
> synchronous streaming replication setting)
>
> I've been looking at sent_lsn, write_lsn, flush