Search Postgresql Archives

Re: WAL-files is not removing authomaticaly

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

 



postgres=# show checkpoint_timeout;
 checkpoint_timeout
--------------------
 5min
(1 row)

Added log_checkpoints = on to postgresql.conf on slave, and here is the log from slave:

2021-03-16 09:43:42.509 EET [97581] [] [] [] []DEBUG:  checkpointer updated shared memory configuration values
2021-03-16 09:43:42.916 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68951 socket=11
2021-03-16 09:43:42.921 EET [97583] [] [] [] []DEBUG:  received inquiry for database 13212
2021-03-16 09:43:42.921 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2021-03-16 09:43:42.921 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/db_13212.stat"
2021-03-16 09:43:42.921 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-03-16 09:43:42.934 EET [97575] [] [] [] []DEBUG:  server process (PID 68951) exited with exit code 0
2021-03-16 09:43:44.581 EET [97585] [] [] [] []DEBUG:  sending write 145/EED56AF0 flush 145/EED56AF0 apply 145/EED56AF0
2021-03-16 09:43:44.945 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68959 socket=11
2021-03-16 09:43:44.950 EET [97583] [] [] [] []DEBUG:  received inquiry for database 13212
2021-03-16 09:43:44.950 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2021-03-16 09:43:44.950 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/db_13212.stat"
2021-03-16 09:43:44.950 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-03-16 09:43:44.963 EET [97575] [] [] [] []DEBUG:  server process (PID 68959) exited with exit code 0
2021-03-16 09:43:45.972 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68961 socket=11
2021-03-16 09:43:45.982 EET [97575] [] [] [] []DEBUG:  server process (PID 68961) exited with exit code 0
2021-03-16 09:43:45.991 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68963 socket=11
2021-03-16 09:43:46.003 EET [97575] [] [] [] []DEBUG:  server process (PID 68963) exited with exit code 0
2021-03-16 09:43:47.013 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68968 socket=11
2021-03-16 09:43:47.024 EET [97575] [] [] [] []DEBUG:  server process (PID 68968) exited with exit code 0
2021-03-16 09:43:47.033 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68974 socket=11
2021-03-16 09:43:47.041 EET [97575] [] [] [] []DEBUG:  server process (PID 68974) exited with exit code 0
2021-03-16 09:43:47.050 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68976 socket=11
2021-03-16 09:43:47.060 EET [97575] [] [] [] []DEBUG:  server process (PID 68976) exited with exit code 0
2021-03-16 09:43:47.516 EET [97581] [] [] [] []DEBUG:  updated min recovery point to 145/EED56AF0 on timeline 2
2021-03-16 09:43:47.517 EET [97581] [] [] [] []DEBUG:  performing replication slot checkpoint
2021-03-16 09:43:48.070 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68979 socket=11
2021-03-16 09:43:48.079 EET [97575] [] [] [] []DEBUG:  server process (PID 68979) exited with exit code 0
2021-03-16 09:43:48.085 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68981 socket=11
2021-03-16 09:43:48.094 EET [97575] [] [] [] []DEBUG:  server process (PID 68981) exited with exit code 0
2021-03-16 09:43:48.099 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68983 socket=11
2021-03-16 09:43:48.109 EET [97575] [] [] [] []DEBUG:  server process (PID 68983) exited with exit code 0
2021-03-16 09:43:48.115 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68985 socket=11
2021-03-16 09:43:48.122 EET [97575] [] [] [] []DEBUG:  server process (PID 68985) exited with exit code 0
2021-03-16 09:43:48.168 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68987 socket=11
2021-03-16 09:43:48.178 EET [97575] [] [] [] []DEBUG:  server process (PID 68987) exited with exit code 0
2021-03-16 09:43:51.134 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=68997 socket=11
2021-03-16 09:43:51.141 EET [97575] [] [] [] []DEBUG:  server process (PID 68997) exited with exit code 0
2021-03-16 09:43:54.605 EET [97585] [] [] [] []DEBUG:  sending write 145/EED56AF0 flush 145/EED56AF0 apply 145/EED56AF0
2021-03-16 09:43:56.177 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=69014 socket=11
2021-03-16 09:43:56.186 EET [97575] [] [] [] []DEBUG:  server process (PID 69014) exited with exit code 0
2021-03-16 09:43:57.196 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=69018 socket=11
2021-03-16 09:43:57.202 EET [97575] [] [] [] []DEBUG:  server process (PID 69018) exited with exit code 0
2021-03-16 09:43:57.552 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=69020 socket=11
2021-03-16 09:43:57.556 EET [97583] [] [] [] []DEBUG:  received inquiry for database 13212
2021-03-16 09:43:57.556 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2021-03-16 09:43:57.556 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/db_13212.stat"
2021-03-16 09:43:57.557 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-03-16 09:43:57.570 EET [97575] [] [] [] []DEBUG:  server process (PID 69020) exited with exit code 0
2021-03-16 09:43:57.577 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=69022 socket=11
2021-03-16 09:43:57.585 EET [97575] [] [] [] []DEBUG:  server process (PID 69022) exited with exit code 0
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=1 file=base/16395/54933 time=0.008 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=2 file=base/16395/54933.1 time=0.004 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=3 file=base/16395/54923.1 time=0.004 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=4 file=base/16395/54923.4 time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=5 file=base/16395/54923.5 time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=6 file=base/16395/54923.7 time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=7 file=base/16395/54923_fsm time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=8 file=base/16395/54923_vm time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=9 file=base/16395/40915.10 time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=10 file=base/16395/40915_fsm time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=11 file=base/16395/54926 time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=12 file=base/16395/54926.1 time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=13 file=base/16395/2619 time=0.004 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=14 file=base/16395/54928 time=0.004 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=15 file=base/16395/54928.1 time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=16 file=base/16395/46862.2 time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=17 file=base/16395/54931 time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=18 file=base/16395/54934 time=0.003 msec
2021-03-16 09:44:03.981 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=19 file=base/16395/54934.1 time=0.003 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=20 file=base/16395/54934.2 time=1.315 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=21 file=base/16395/54932 time=0.005 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=22 file=base/16395/54932.1 time=0.003 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=23 file=base/16395/54932.2 time=0.003 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=24 file=base/16395/40922.3 time=0.003 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=25 file=base/16395/40921.4 time=0.002 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=26 file=base/16395/40845.3 time=0.003 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=27 file=base/16395/54927 time=0.002 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=28 file=base/16395/54927.1 time=0.002 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=29 file=base/16395/40848 time=0.002 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=30 file=base/16395/40923.2 time=0.003 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=31 file=base/16395/40923.3 time=0.002 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=32 file=base/16395/40924 time=0.003 msec
2021-03-16 09:44:03.982 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=33 file=base/16395/40924.2 time=0.002 msec
2021-03-16 09:44:03.983 EET [97581] [] [] [] []DEBUG:  checkpoint sync: number=34 file=base/16395/54935 time=0.939 msec
2021-03-16 09:44:03.997 EET [97581] [] [] [] []DEBUG:  attempting to remove WAL segments older than log file 000000000000013E00000097
2021-03-16 09:44:03.999 EET [97581] [] [] [] []DEBUG:  SlruScanDirectory invoking callback on pg_subtrans/1EEF
2021-03-16 09:44:04.628 EET [97585] [] [] [] []DEBUG:  sending write 145/EED56AF0 flush 145/EED56AF0 apply 145/EED56AF0 (reply requested)
2021-03-16 09:44:04.629 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:04.628572+02 receipttime 2021-03-16 09:44:04.62953+02 replication apply delay 0 ms transfer latency 0 ms
2021-03-16 09:44:04.681 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=69032 socket=11
2021-03-16 09:44:04.688 EET [97575] [] [] [] []DEBUG:  server process (PID 69032) exited with exit code 0
2021-03-16 09:44:05.215 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=69039 socket=11
2021-03-16 09:44:05.223 EET [97575] [] [] [] []DEBUG:  server process (PID 69039) exited with exit code 0
2021-03-16 09:44:05.235 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=69043 socket=11
2021-03-16 09:44:05.241 EET [97575] [] [] [] []DEBUG:  server process (PID 69043) exited with exit code 0
2021-03-16 09:44:07.115 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:07.114539+02 receipttime 2021-03-16 09:44:07.115687+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:07.115 EET [97585] [] [] [] []DEBUG:  sending write 145/EED58B60 flush 145/EED56AF0 apply 145/EED56AF0
2021-03-16 09:44:07.118 EET [97585] [] [] [] []DEBUG:  sending write 145/EED58B60 flush 145/EED58B60 apply 145/EED56AF0
2021-03-16 09:44:07.118 EET [97585] [] [] [] []DEBUG:  sending write 145/EED58B60 flush 145/EED58B60 apply 145/EED58B60
2021-03-16 09:44:07.120 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:07.119335+02 receipttime 2021-03-16 09:44:07.120658+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:07.120 EET [97585] [] [] [] []DEBUG:  sending write 145/EED60278 flush 145/EED58B60 apply 145/EED58B60
2021-03-16 09:44:07.126 EET [97585] [] [] [] []DEBUG:  sending write 145/EED60278 flush 145/EED60278 apply 145/EED58B60
2021-03-16 09:44:07.126 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:07.121166+02 receipttime 2021-03-16 09:44:07.126213+02 replication apply delay 0 ms transfer latency 5 ms
2021-03-16 09:44:07.126 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:07.123089+02 receipttime 2021-03-16 09:44:07.126253+02 replication apply delay 0 ms transfer latency 3 ms
2021-03-16 09:44:07.126 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:07.124296+02 receipttime 2021-03-16 09:44:07.126275+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:07.126 EET [97585] [] [] [] []DEBUG:  sending write 145/EED65B88 flush 145/EED60278 apply 145/EED60278
2021-03-16 09:44:07.126 EET [97585] [] [] [] []DEBUG:  sending write 145/EED65B88 flush 145/EED65B88 apply 145/EED60278
2021-03-16 09:44:07.127 EET [97585] [] [] [] []DEBUG:  sending write 145/EED65B88 flush 145/EED65B88 apply 145/EED62970
2021-03-16 09:44:07.127 EET [97585] [] [] [] []DEBUG:  sending write 145/EED65B88 flush 145/EED65B88 apply 145/EED65B88
2021-03-16 09:44:07.129 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:07.128493+02 receipttime 2021-03-16 09:44:07.129383+02 replication apply delay 0 ms transfer latency 0 ms
2021-03-16 09:44:07.129 EET [97585] [] [] [] []DEBUG:  sending write 145/EED65BC8 flush 145/EED65B88 apply 145/EED65B88
2021-03-16 09:44:07.130 EET [97585] [] [] [] []DEBUG:  sending write 145/EED65BC8 flush 145/EED65BC8 apply 145/EED65B88
2021-03-16 09:44:07.130 EET [97585] [] [] [] []DEBUG:  sending write 145/EED65BC8 flush 145/EED65BC8 apply 145/EED65BC8
2021-03-16 09:44:07.402 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:07.401693+02 receipttime 2021-03-16 09:44:07.402781+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:07.402 EET [97585] [] [] [] []DEBUG:  sending write 145/EED65F38 flush 145/EED65BC8 apply 145/EED65BC8
2021-03-16 09:44:07.404 EET [97585] [] [] [] []DEBUG:  sending write 145/EED65F38 flush 145/EED65F38 apply 145/EED65BC8
2021-03-16 09:44:07.404 EET [97585] [] [] [] []DEBUG:  sending write 145/EED65F38 flush 145/EED65F38 apply 145/EED65F38
2021-03-16 09:44:09.039 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:09.037128+02 receipttime 2021-03-16 09:44:09.039141+02 replication apply delay 0 ms transfer latency 2 ms
2021-03-16 09:44:09.039 EET [97585] [] [] [] []DEBUG:  sending write 145/EED767D0 flush 145/EED65F38 apply 145/EED65F38
2021-03-16 09:44:09.040 EET [97585] [] [] [] []DEBUG:  sending write 145/EED767D0 flush 145/EED767D0 apply 145/EED65F38
2021-03-16 09:44:09.041 EET [97585] [] [] [] []DEBUG:  sending write 145/EED767D0 flush 145/EED767D0 apply 145/EED767D0
2021-03-16 09:44:09.052 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:09.051438+02 receipttime 2021-03-16 09:44:09.052571+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:09.052 EET [97585] [] [] [] []DEBUG:  sending write 145/EED79CB8 flush 145/EED767D0 apply 145/EED767D0
2021-03-16 09:44:09.053 EET [97585] [] [] [] []DEBUG:  sending write 145/EED79CB8 flush 145/EED79CB8 apply 145/EED767D0
2021-03-16 09:44:09.053 EET [97585] [] [] [] []DEBUG:  sending write 145/EED79CB8 flush 145/EED79CB8 apply 145/EED79CB8
2021-03-16 09:44:09.064 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:09.062875+02 receipttime 2021-03-16 09:44:09.064028+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:09.064 EET [97585] [] [] [] []DEBUG:  sending write 145/EED7CAE8 flush 145/EED79CB8 apply 145/EED79CB8
2021-03-16 09:44:09.065 EET [97585] [] [] [] []DEBUG:  sending write 145/EED7CAE8 flush 145/EED7CAE8 apply 145/EED79CB8
2021-03-16 09:44:09.065 EET [97585] [] [] [] []DEBUG:  sending write 145/EED7CAE8 flush 145/EED7CAE8 apply 145/EED7CAE8
2021-03-16 09:44:09.071 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:09.070821+02 receipttime 2021-03-16 09:44:09.071892+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:09.071 EET [97585] [] [] [] []DEBUG:  sending write 145/EED7DFB8 flush 145/EED7CAE8 apply 145/EED7CAE8
2021-03-16 09:44:09.072 EET [97585] [] [] [] []DEBUG:  sending write 145/EED7DFB8 flush 145/EED7DFB8 apply 145/EED7CAE8
2021-03-16 09:44:09.073 EET [97585] [] [] [] []DEBUG:  sending write 145/EED7DFB8 flush 145/EED7DFB8 apply 145/EED7DFB8
2021-03-16 09:44:09.082 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:09.081682+02 receipttime 2021-03-16 09:44:09.082764+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:09.082 EET [97585] [] [] [] []DEBUG:  sending write 145/EED7FBA0 flush 145/EED7DFB8 apply 145/EED7DFB8
2021-03-16 09:44:09.083 EET [97585] [] [] [] []DEBUG:  sending write 145/EED7FBA0 flush 145/EED7FBA0 apply 145/EED7DFB8
2021-03-16 09:44:09.083 EET [97585] [] [] [] []DEBUG:  sending write 145/EED7FBA0 flush 145/EED7FBA0 apply 145/EED7FBA0
2021-03-16 09:44:09.092 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:09.091792+02 receipttime 2021-03-16 09:44:09.092881+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:09.092 EET [97585] [] [] [] []DEBUG:  sending write 145/EED81DD8 flush 145/EED7FBA0 apply 145/EED7FBA0
2021-03-16 09:44:09.093 EET [97585] [] [] [] []DEBUG:  sending write 145/EED81DD8 flush 145/EED81DD8 apply 145/EED7FBA0
2021-03-16 09:44:09.093 EET [97585] [] [] [] []DEBUG:  sending write 145/EED81DD8 flush 145/EED81DD8 apply 145/EED81DD8
2021-03-16 09:44:09.103 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:09.102121+02 receipttime 2021-03-16 09:44:09.103193+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:09.103 EET [97585] [] [] [] []DEBUG:  sending write 145/EED83280 flush 145/EED81DD8 apply 145/EED81DD8
2021-03-16 09:44:09.103 EET [97585] [] [] [] []DEBUG:  sending write 145/EED83280 flush 145/EED83280 apply 145/EED81DD8
2021-03-16 09:44:09.104 EET [97585] [] [] [] []DEBUG:  sending write 145/EED83280 flush 145/EED83280 apply 145/EED83280
2021-03-16 09:44:09.112 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:09.111162+02 receipttime 2021-03-16 09:44:09.112253+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:09.112 EET [97585] [] [] [] []DEBUG:  sending write 145/EED84748 flush 145/EED83280 apply 145/EED83280
2021-03-16 09:44:09.113 EET [97585] [] [] [] []DEBUG:  sending write 145/EED84748 flush 145/EED84748 apply 145/EED83280
2021-03-16 09:44:09.113 EET [97585] [] [] [] []DEBUG:  sending write 145/EED84748 flush 145/EED84748 apply 145/EED84748
2021-03-16 09:44:09.120 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:09.119062+02 receipttime 2021-03-16 09:44:09.12016+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:09.120 EET [97585] [] [] [] []DEBUG:  sending write 145/EED868E0 flush 145/EED84748 apply 145/EED84748
2021-03-16 09:44:09.121 EET [97585] [] [] [] []DEBUG:  sending write 145/EED868E0 flush 145/EED868E0 apply 145/EED84748
2021-03-16 09:44:09.121 EET [97585] [] [] [] []DEBUG:  sending write 145/EED868E0 flush 145/EED868E0 apply 145/EED868E0
2021-03-16 09:44:09.284 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:09.283417+02 receipttime 2021-03-16 09:44:09.284538+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:09.284 EET [97585] [] [] [] []DEBUG:  sending write 145/EED86918 flush 145/EED868E0 apply 145/EED868E0
2021-03-16 09:44:09.285 EET [97585] [] [] [] []DEBUG:  sending write 145/EED86918 flush 145/EED86918 apply 145/EED868E0
2021-03-16 09:44:09.285 EET [97585] [] [] [] []DEBUG:  sending write 145/EED86918 flush 145/EED86918 apply 145/EED86918
2021-03-16 09:44:17.780 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:17.778827+02 receipttime 2021-03-16 09:44:17.779977+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:17.780 EET [97585] [] [] [] []DEBUG:  sending write 145/EED88910 flush 145/EED86918 apply 145/EED86918
2021-03-16 09:44:17.780 EET [97585] [] [] [] []DEBUG:  sending write 145/EED88910 flush 145/EED88910 apply 145/EED86918
2021-03-16 09:44:17.780 EET [97585] [] [] [] []DEBUG:  sending write 145/EED88910 flush 145/EED88910 apply 145/EED88910
2021-03-16 09:44:17.794 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:17.793372+02 receipttime 2021-03-16 09:44:17.79478+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:17.794 EET [97585] [] [] [] []DEBUG:  sending write 145/EED92370 flush 145/EED88910 apply 145/EED88910
2021-03-16 09:44:17.795 EET [97585] [] [] [] []DEBUG:  sending write 145/EED92370 flush 145/EED92370 apply 145/EED88910
2021-03-16 09:44:17.795 EET [97585] [] [] [] []DEBUG:  sending write 145/EED92370 flush 145/EED92370 apply 145/EED92370
2021-03-16 09:44:17.798 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:17.797854+02 receipttime 2021-03-16 09:44:17.798819+02 replication apply delay 0 ms transfer latency 0 ms
2021-03-16 09:44:17.798 EET [97585] [] [] [] []DEBUG:  sending write 145/EED93660 flush 145/EED92370 apply 145/EED92370
2021-03-16 09:44:17.799 EET [97585] [] [] [] []DEBUG:  sending write 145/EED93660 flush 145/EED93660 apply 145/EED92370
2021-03-16 09:44:17.799 EET [97585] [] [] [] []DEBUG:  sending write 145/EED93660 flush 145/EED93660 apply 145/EED93660
2021-03-16 09:44:17.804 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:17.803065+02 receipttime 2021-03-16 09:44:17.804053+02 replication apply delay 0 ms transfer latency 0 ms
2021-03-16 09:44:17.804 EET [97585] [] [] [] []DEBUG:  sending write 145/EED94918 flush 145/EED93660 apply 145/EED93660
2021-03-16 09:44:17.804 EET [97585] [] [] [] []DEBUG:  sending write 145/EED94918 flush 145/EED94918 apply 145/EED93660
2021-03-16 09:44:17.804 EET [97585] [] [] [] []DEBUG:  sending write 145/EED94918 flush 145/EED94918 apply 145/EED94918
2021-03-16 09:44:17.809 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:17.808038+02 receipttime 2021-03-16 09:44:17.809083+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:17.809 EET [97585] [] [] [] []DEBUG:  sending write 145/EED95BC8 flush 145/EED94918 apply 145/EED94918
2021-03-16 09:44:17.809 EET [97585] [] [] [] []DEBUG:  sending write 145/EED95BC8 flush 145/EED95BC8 apply 145/EED94918
2021-03-16 09:44:17.809 EET [97585] [] [] [] []DEBUG:  sending write 145/EED95BC8 flush 145/EED95BC8 apply 145/EED95BC8
2021-03-16 09:44:17.906 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:17.905067+02 receipttime 2021-03-16 09:44:17.906031+02 replication apply delay 0 ms transfer latency 0 ms
2021-03-16 09:44:17.906 EET [97585] [] [] [] []DEBUG:  sending write 145/EED95C08 flush 145/EED95BC8 apply 145/EED95BC8
2021-03-16 09:44:17.906 EET [97585] [] [] [] []DEBUG:  sending write 145/EED95C08 flush 145/EED95C08 apply 145/EED95BC8
2021-03-16 09:44:17.907 EET [97585] [] [] [] []DEBUG:  sending write 145/EED95C08 flush 145/EED95C08 apply 145/EED95C08
2021-03-16 09:44:18.038 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:18.036967+02 receipttime 2021-03-16 09:44:18.038009+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:18.038 EET [97585] [] [] [] []DEBUG:  sending write 145/EED95D38 flush 145/EED95C08 apply 145/EED95C08
2021-03-16 09:44:18.038 EET [97585] [] [] [] []DEBUG:  sending write 145/EED95D38 flush 145/EED95D38 apply 145/EED95C08
2021-03-16 09:44:18.038 EET [97585] [] [] [] []DEBUG:  sending write 145/EED95D38 flush 145/EED95D38 apply 145/EED95D38
2021-03-16 09:44:18.779 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:18.778734+02 receipttime 2021-03-16 09:44:18.779953+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:18.780 EET [97585] [] [] [] []DEBUG:  sending write 145/EED97DA0 flush 145/EED95D38 apply 145/EED95D38
2021-03-16 09:44:18.780 EET [97585] [] [] [] []DEBUG:  sending write 145/EED97DA0 flush 145/EED97DA0 apply 145/EED95D38
2021-03-16 09:44:18.780 EET [97585] [] [] [] []DEBUG:  sending write 145/EED97DA0 flush 145/EED97DA0 apply 145/EED97DA0
2021-03-16 09:44:18.787 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:18.786521+02 receipttime 2021-03-16 09:44:18.787955+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:18.788 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA13E8 flush 145/EED97DA0 apply 145/EED97DA0
2021-03-16 09:44:18.788 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA13E8 flush 145/EEDA13E8 apply 145/EED97DA0
2021-03-16 09:44:18.789 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA13E8 flush 145/EEDA13E8 apply 145/EEDA13E8
2021-03-16 09:44:18.791 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:18.790535+02 receipttime 2021-03-16 09:44:18.791493+02 replication apply delay 0 ms transfer latency 0 ms
2021-03-16 09:44:18.791 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA2550 flush 145/EEDA13E8 apply 145/EEDA13E8
2021-03-16 09:44:18.791 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA2550 flush 145/EEDA2550 apply 145/EEDA13E8
2021-03-16 09:44:18.792 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA2550 flush 145/EEDA2550 apply 145/EEDA2550
2021-03-16 09:44:18.793 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:18.792741+02 receipttime 2021-03-16 09:44:18.793759+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:18.793 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA3C70 flush 145/EEDA2550 apply 145/EEDA2550
2021-03-16 09:44:18.794 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA3C70 flush 145/EEDA3C70 apply 145/EEDA2550
2021-03-16 09:44:18.794 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA3C70 flush 145/EEDA3C70 apply 145/EEDA3C70
2021-03-16 09:44:18.795 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:18.794123+02 receipttime 2021-03-16 09:44:18.795082+02 replication apply delay 0 ms transfer latency 0 ms
2021-03-16 09:44:18.795 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA5E50 flush 145/EEDA3C70 apply 145/EEDA3C70
2021-03-16 09:44:18.795 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA5E50 flush 145/EEDA5E50 apply 145/EEDA3C70
2021-03-16 09:44:18.795 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA5E50 flush 145/EEDA5E50 apply 145/EEDA5E50
2021-03-16 09:44:18.908 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:18.907307+02 receipttime 2021-03-16 09:44:18.908412+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:18.908 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA5E90 flush 145/EEDA5E50 apply 145/EEDA5E50
2021-03-16 09:44:18.909 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA5E90 flush 145/EEDA5E90 apply 145/EEDA5E50
2021-03-16 09:44:18.909 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA5E90 flush 145/EEDA5E90 apply 145/EEDA5E90
2021-03-16 09:44:19.033 EET [97585] [] [] [] []DEBUG:  sendtime 2021-03-16 09:44:19.032755+02 receipttime 2021-03-16 09:44:19.033807+02 replication apply delay 0 ms transfer latency 1 ms
2021-03-16 09:44:19.033 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA5FC0 flush 145/EEDA5E90 apply 145/EEDA5E90
2021-03-16 09:44:19.034 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA5FC0 flush 145/EEDA5FC0 apply 145/EEDA5E90
2021-03-16 09:44:19.034 EET [97585] [] [] [] []DEBUG:  sending write 145/EEDA5FC0 flush 145/EEDA5FC0 apply 145/EEDA5FC0
2021-03-16 09:44:19.258 EET [97575] [] [] [] []DEBUG:  forked new backend, pid=69051 socket=11
2021-03-16 09:44:19.264 EET [97583] [] [] [] []DEBUG:  received inquiry for database 13212
2021-03-16 09:44:19.264 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/global.stat"
2021-03-16 09:44:19.264 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/db_13212.stat"
2021-03-16 09:44:19.265 EET [97583] [] [] [] []DEBUG:  writing stats file "pg_stat_tmp/db_0.stat"
2021-03-16 09:44:19.278 EET [97575] [] [] [] []DEBUG:  server process (PID 69051) exited with exit code 0
2021-03-16 09:44:19.849 EET [97577] [] [] [] []DEBUG:  parameter "log_checkpoints" removed from configuration file, reset to default
2021-03-16 09:44:19.849 EET [97581] [] [] [] []DEBUG:  parameter "log_checkpoints" removed from configuration file, reset to default
2021-03-16 09:44:19.849 EET [97582] [] [] [] []DEBUG:  parameter "log_checkpoints" removed from configuration file, reset to default
2021-03-16 09:44:19.850 EET [97583] [] [] [] []DEBUG:  parameter "log_checkpoints" removed from configuration file, reset to default
2021-03-16 09:44:19.851 EET [97576] [] [] [] []DEBUG:  parameter "log_checkpoints" removed from configuration file, reset to default
2021-03-16 09:44:19.937 EET [97585] [] [] [] []DEBUG:  parameter "log_checkpoints" removed from configuration file, reset to default

вт, 16 мар. 2021 г. в 09:40, Laurenz Albe <laurenz.albe@xxxxxxxxxxx>:
On Tue, 2021-03-16 at 09:33 +0200, Andrew Anderson wrote:
> The situation didn't changes, WAL segments not removing automatically.
> The streaming replication works fine, here is the log files:
>
> from master:
> [log with debug2, but without WAL segment delete messages]

Could you set "log_checkpoints = on" and tell us what "checkpoint_timeout"
is set to?  WAL segments are only deleted after checkpoints.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux