Hi,
Do the below processes look OK for a standby (streaming replication)
server? We recently migrated from 12 to 16. I don't remember seeing
"startup recovering" process for a long time after starting of
standby server on postgresql 12, it has been long time so I could be
wrong. Just want to make sure my standby is in a good shape. I have
run some queries on standby to see if latest data is available and
seems like it is there.
postgres 16909 1 0 May15 ?
00:00:00 /usr/lib/postgresql/16/bin/postgres -D
/var/lib/postgresql/16/main -c
config_file=/etc/postgresql/16/main/postgresql.conf
postgres 16910 16909 0 May15 ? 00:00:00 postgres:
16/main: logger
postgres 16911 16909 0 May15 ? 00:00:54 postgres:
16/main: checkpointer
postgres 16912 16909 0 May15 ? 00:00:03 postgres:
16/main: background writer
postgres 16913 16909 0 May15 ? 00:03:14 postgres:
16/main: startup recovering 0000000100000085000000E2
postgres 17012 16909 0 May15 ? 00:03:04 postgres:
16/main: walreceiver streaming 85/E24B6000
Also seeing log entries about every 5 minutes as shown below. These
were not present when we were running 12.
2024-05-16 16:17:02.981 CDT: : 16911: LOG: restartpoint starting:
time
2024-05-16 16:18:58.337 CDT: : 16911: LOG: restartpoint complete:
wrote 1132 buffers (0.1%); 0 WAL file(s) added, 0 removed, 0
recycled; write=113.465 s, sync=1.688 s, total=115.356 s; sync
files=155, longest=0.058 s, average=0.011 s; distance=21216 kB,
estimate=174182 kB; lsn=85/FCFA8AA8, redo lsn=85/FCB6C578
2024-05-16 16:18:58.337 CDT: : 16911: LOG: recovery restart point
at 85/FCB6C578
2024-05-16 16:18:58.337 CDT: : 16911: DETAIL: Last completed
transaction was at log time 2024-05-16 16:18:57.612916-05.
Appreciate your help.
Thanks,
Prasanth
