public inbox for [email protected]
help / color / mirror / Atom feedRe: Seeing new stuff in log after upgrading from 11 to 15
2+ messages / 2 participants
[nested] [flat]
* Re: Seeing new stuff in log after upgrading from 11 to 15
@ 2024-05-15 23:50 Tom Lane <[email protected]>
2024-05-16 00:00 ` Re: Seeing new stuff in log after upgrading from 11 to 15 Dmitry O Litvintsev <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Tom Lane @ 2024-05-15 23:50 UTC (permalink / raw)
To: Dmitry O Litvintsev <[email protected]>; +Cc: [email protected] <[email protected]>
Dmitry O Litvintsev <[email protected]> writes:
> After upgrade 11 -> 15 started to see these messages in hot standby log:
> < 2024-05-15 17:20:24.164 CDT 151879 > LOG: restartpoint complete: wrote 296338 buffers (28.3%); 0 WAL file(s) added, 134 removed, 0 recycled; write=1619.469 s, sync=0.022 s, total=1619.539 s; sync files=1492, longest=0.002 s, average=0.001 s; distance=2195446 kB, estimate=4171347 kB
> < 2024-05-15 17:20:24.164 CDT 151879 > LOG: recovery restart point at 17AB8/47000140
> < 2024-05-15 17:20:24.164 CDT 151879 > DETAIL: Last completed transaction was at log time 2024-05-15 17:20:24.138362-05.
> < 2024-05-15 17:20:24.167 CDT 151879 > LOG: restartpoint starting: wal
> while running 11 the log was almost empty, and I did not modify verbosity settings...
> Queston : are above harmless and just informational?
This is checkpoint logging, which is on by default now (a decision
I didn't particularly approve of). Feel free to set
"log_checkpoints = off" if you don't want it.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Seeing new stuff in log after upgrading from 11 to 15
2024-05-15 23:50 Re: Seeing new stuff in log after upgrading from 11 to 15 Tom Lane <[email protected]>
@ 2024-05-16 00:00 ` Dmitry O Litvintsev <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Dmitry O Litvintsev @ 2024-05-16 00:00 UTC (permalink / raw)
To: Tom Lane <[email protected]>; +Cc: [email protected] <[email protected]>
Thanks for the quick reply! NP, I was just being extra cautious after upgrade.
________________________________________
From: Tom Lane <[email protected]>
Sent: Wednesday, May 15, 2024 6:50 PM
To: Dmitry O Litvintsev
Cc: [email protected]
Subject: Re: Seeing new stuff in log after upgrading from 11 to 15
[EXTERNAL] – This message is from an external sender
Dmitry O Litvintsev <[email protected]> writes:
> After upgrade 11 -> 15 started to see these messages in hot standby log:
> < 2024-05-15 17:20:24.164 CDT 151879 > LOG: restartpoint complete: wrote 296338 buffers (28.3%); 0 WAL file(s) added, 134 removed, 0 recycled; write=1619.469 s, sync=0.022 s, total=1619.539 s; sync files=1492, longest=0.002 s, average=0.001 s; distance=2195446 kB, estimate=4171347 kB
> < 2024-05-15 17:20:24.164 CDT 151879 > LOG: recovery restart point at 17AB8/47000140
> < 2024-05-15 17:20:24.164 CDT 151879 > DETAIL: Last completed transaction was at log time 2024-05-15 17:20:24.138362-05.
> < 2024-05-15 17:20:24.167 CDT 151879 > LOG: restartpoint starting: wal
> while running 11 the log was almost empty, and I did not modify verbosity settings...
> Queston : are above harmless and just informational?
This is checkpoint logging, which is on by default now (a decision
I didn't particularly approve of). Feel free to set
"log_checkpoints = off" if you don't want it.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-05-16 00:00 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-05-15 23:50 Re: Seeing new stuff in log after upgrading from 11 to 15 Tom Lane <[email protected]>
2024-05-16 00:00 ` Dmitry O Litvintsev <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox