| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Dmitry O Litvintsev <litvinse(at)fnal(dot)gov> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Seeing new stuff in log after upgrading from 11 to 15 |
| Date: | 2024-05-15 23:50:56 |
| Message-ID: | 1921891.1715817056@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dmitry O Litvintsev <litvinse(at)fnal(dot)gov> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dmitry O Litvintsev | 2024-05-16 00:00:36 | Re: Seeing new stuff in log after upgrading from 11 to 15 |
| Previous Message | Dmitry O Litvintsev | 2024-05-15 23:27:52 | Seeing new stuff in log after upgrading from 11 to 15 |