improve wals replay on secondary

Mariel Cherkassky <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <CA+t6e1njgBuGGzgQ_MH431T2w=CXZEoD_O9YTVBHqgFwqHdWgQ@mail.gmail.com>
Hey,
PG 9.6, I have a standalone configured. I tried to start up a secondary,
run standby clone (repmgr). The clone process took 3 hours and during that
time wals were generated(mostly because of the checkpoint_timeout). As a
result of that, when I start the secondary ,I see that the secondary keeps
getting the wals but I dont see any messages that indicate that the
secondary tried to replay the wals.
messages that i see :
receiving incremental file list
000000010000377B000000DE

sent 30 bytes  received 4.11M bytes  8.22M bytes/sec
total size is 4.15M  speedup is 1.01
2019-05-22 12:48:10 EEST  60942  LOG:  restored log file
"000000010000377B000000DE" from archive
2019-05-22 12:48:11 EEST db63311  FATAL:  the database system is starting up
2019-05-22 12:48:12 EEST db63313  FATAL:  the database system is starting
up

I was hoping to see the following messages (taken from a different machine)
:
2019-05-27 01:15:37 EDT  7428  LOG:  restartpoint starting: time
2019-05-27 01:16:18 EDT  7428  LOG:  restartpoint complete: wrote 406
buffers (0.2%); 1 transaction log file(s) added, 0 removed, 0 recycled;
write=41.390 s, sync=0.001 s, total=41.582 s; sync file
s=128, longest=0.000 s, average=0.000 s; distance=2005 kB, estimate=2699 kB
2019-05-27 01:16:18 EDT  7428  LOG:  recovery restart point at 4/D096C4F8

My primary settings(wals settings) :
wal_buffers = 16MB
checkpoint_completion_target = 0.9
checkpoint_timeout = 30min

Any idea what can explain why the secondary doesnt replay the wals ?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.