Search Postgresql Archives

Re: log wal file transfer in error logs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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@xxxxxxxxx> 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.albe@xxxxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux