Re: log wal file transfer in error logs

2023-10-12 Thread Laurenz Albe
On Wed, 2023-10-11 at 23:20 +0530, 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 rep

Re: log wal file transfer in error logs

2023-10-11 Thread Ron
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 sta

Re: log wal file transfer in error logs

2023-10-11 Thread Atul Kumar
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

Re: log wal file transfer in error logs

2023-10-11 Thread Laurenz Albe
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