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

log wal file transfer in error logs

2023-10-11 Thread Atul Kumar
Hi, I need to log all wal files that are getting transferred to all standby servers in the postgresql error logs. I also need to log those wal files that are being applied in standbys. My postgres version is 12 and running on centos 7. I am unable to understand the proper parameters in the post