Re: log wal file transfer in error logs

Tables (on the primary) pg_stat_replication and (on the secondary)
pg_stat_wal_receiver do that for you.

On 10/11/23 12:50, Atul Kumar wrote:
> Yes, I meant streamed, I need to log those wal files that are getting
> streamed and replayed on standby servers in error logs of primary as well
> as standby servers.
>
> So that I can cross check that whichever file is streamed has been
> replayed on standby.
>
> I need to keep a track of these wal files in db error logs.
>
>
>
> Regard
>
> On Wed, Oct 11, 2023 at 10:29 PM Atul Kumar <akumar14871(at)gmail(dot)com> wrote:
>
> Yss, I meant streamed, I need to log those wal files that are getting
> streamed and replayed on standby servers in error logs of primary as
> well as standby servers.
>
> So that I can cross check that whichever file is streamed has been
> replayed on standby.
>
> I need to keep a track of these wal files in db error logs.
>
>
>
> Regards,
> Atul
>
>
>
> On Wed, Oct 11, 2023 at 10:21 PM Laurenz Albe
> <laurenz(dot)albe(at)cybertec(dot)at> wrote:
>
> On Wed, 2023-10-11 at 22:15 +0530, Atul Kumar wrote:
> > I need to log all wal files that are getting transferred to all
> standby servers in the postgresql error logs.
>
> WAL files are not transferred to standby servers...
>
> WAL is streamed, so what would you want to log?
>
> Yours,
> Laurenz Albe
>

--
Born in Arizona, moved to Babylonia.