public inbox for [email protected]  

help / color / mirror / Atom feed

From: Dionysios-Charalampos Vythoulkas <[email protected]>
To: pgsql-admin <[email protected]>
To: Pgsql-admin <[email protected]>
Cc: Wasim Devale <[email protected]>
Subject: Re: Replication lag
Date: Fri, 23 May 2025 11:31:19 +0300
Message-ID: <6162737.lOV4Wx5bFT@dcv-workpc> (raw)
In-Reply-To: <CAB5fag6D_UdYOipnhH+n0cFimHjxjvP1fPvh_qZWH7q+1dQ+GQ@mail.gmail.com>
References: <CAB5fag6D_UdYOipnhH+n0cFimHjxjvP1fPvh_qZWH7q+1dQ+GQ@mail.gmail.com>

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Replication lag
  In-Reply-To: <6162737.lOV4Wx5bFT@dcv-workpc>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox