pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedlog wal file transfer in error logs
5+ messages / 3 participants
[nested] [flat]
* log wal file transfer in error logs
@ 2023-10-11 16:45 Atul Kumar <akumar14871@gmail.com>
2023-10-11 16:51 ` Re: log wal file transfer in error logs Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 1 reply; 5+ messages in thread
From: Atul Kumar @ 2023-10-11 16:45 UTC (permalink / raw)
To: pgsql-general <pgsql-general@lists.postgresql.org>
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 postgresql.conf
file, please help me in achieving this.
Regards,
Atul
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: log wal file transfer in error logs
2023-10-11 16:45 log wal file transfer in error logs Atul Kumar <akumar14871@gmail.com>
@ 2023-10-11 16:51 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-10-11 17:50 ` Re: log wal file transfer in error logs Atul Kumar <akumar14871@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Laurenz Albe @ 2023-10-11 16:51 UTC (permalink / raw)
To: Atul Kumar <akumar14871@gmail.com>; pgsql-general <pgsql-general@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: log wal file transfer in error logs
2023-10-11 16:45 log wal file transfer in error logs Atul Kumar <akumar14871@gmail.com>
2023-10-11 16:51 ` Re: log wal file transfer in error logs Laurenz Albe <laurenz.albe@cybertec.at>
@ 2023-10-11 17:50 ` Atul Kumar <akumar14871@gmail.com>
2023-10-11 17:59 ` Re: log wal file transfer in error logs Ron <ronljohnsonjr@gmail.com>
2023-10-12 07:18 ` Re: log wal file transfer in error logs Laurenz Albe <laurenz.albe@cybertec.at>
0 siblings, 2 replies; 5+ messages in thread
From: Atul Kumar @ 2023-10-11 17:50 UTC (permalink / raw)
To: Laurenz Albe <laurenz.albe@cybertec.at>; pgsql-general <pgsql-general@lists.postgresql.org>
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@gmail.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.albe@cybertec.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
>>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: log wal file transfer in error logs
2023-10-11 16:45 log wal file transfer in error logs Atul Kumar <akumar14871@gmail.com>
2023-10-11 16:51 ` Re: log wal file transfer in error logs Laurenz Albe <laurenz.albe@cybertec.at>
2023-10-11 17:50 ` Re: log wal file transfer in error logs Atul Kumar <akumar14871@gmail.com>
@ 2023-10-11 17:59 ` Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 5+ messages in thread
From: Ron @ 2023-10-11 17:59 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
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@gmail.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.albe@cybertec.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.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: log wal file transfer in error logs
2023-10-11 16:45 log wal file transfer in error logs Atul Kumar <akumar14871@gmail.com>
2023-10-11 16:51 ` Re: log wal file transfer in error logs Laurenz Albe <laurenz.albe@cybertec.at>
2023-10-11 17:50 ` Re: log wal file transfer in error logs Atul Kumar <akumar14871@gmail.com>
@ 2023-10-12 07:18 ` Laurenz Albe <laurenz.albe@cybertec.at>
1 sibling, 0 replies; 5+ messages in thread
From: Laurenz Albe @ 2023-10-12 07:18 UTC (permalink / raw)
To: Atul Kumar <akumar14871@gmail.com>; pgsql-general <pgsql-general@lists.postgresql.org>
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 replayed on standby.
>
> I need to keep a track of these wal files in db error logs.
I don't think you can do that, and it seems like a strange requirement to me.
Instead, you should monitor pg_stat_replication.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2023-10-12 07:18 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-11 16:45 log wal file transfer in error logs Atul Kumar <akumar14871@gmail.com>
2023-10-11 16:51 ` Laurenz Albe <laurenz.albe@cybertec.at>
2023-10-11 17:50 ` Atul Kumar <akumar14871@gmail.com>
2023-10-11 17:59 ` Ron <ronljohnsonjr@gmail.com>
2023-10-12 07:18 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox