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