improve wals replay on secondary

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 ?

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux