agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Dionysios-Charalampos Vythoulkas <dcvythoulkas@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Cc: Wasim Devale <wasimd60@gmail.com>
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
view thread (15+ messages) latest in thread
Message-ID: <6162737.lOV4Wx5bFT@dcv-workpc>
Permalink: ../6162737.lOV4Wx5bFT@dcv-workpc/
Also on: postgresql.org/message-id/6162737.lOV4Wx5bFT@dcv-workpc
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: pgsql-admin@postgresql.org
Cc: dcvythoulkas@gmail.com, pgsql-admin@lists.postgresql.org, wasimd60@gmail.com
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