Re: Replication lag

From: Dionysios-Charalampos Vythoulkas <dcvythoulkas(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Cc: Wasim Devale <wasimd60(at)gmail(dot)com>
Subject: Re: Replication lag
Date: 2025-05-23 08:31:19
Message-ID: 6162737.lOV4Wx5bFT@dcv-workpc
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On streaming replication yes, you can perform read-only queries.
On logical replication, as far as I know you can also run write queries, but you have to be
careful to keep the data consistent.

On Παρασκευή, 23 Μαΐου 2025 10:13:10 Π.Μ. EEST Wasim Devale wrote:
> Hello,
>
> Reply wal and query execution on replica can coexists?
>
> Golden gate in oracle has this feature that they can coexists but in
> postgresql do we have any provision like this.
>
> Please assist.
>
> Thanks,
> Wasim

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-05-23 09:46:48 Re: Replication lag
Previous Message David Okeamah 2025-05-23 08:08:33 Re: Replication lag