API tools faq
paste
Guest User

oarmas-2018-08-02-04

a guest
Aug 2nd, 2018
205
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 81.60 KB | None | 0 0
raw download clone embed print report
  1. -bash-4.2$ more postgresql-2018-08-01_000000.log
  2. 2018-08-01 00:08:11.251 UTC @ 1141 LOG: restartpoint complete: wrote 16488 buffers (1.6%); 0 transaction log file(s) added, 0 removed, 8 recycled; write=1079.175 s, sync=2.127 s, total=108
  3. 1.707 s; sync files=626, longest=0.549 s, average=0.003 s; distance=121577 kB, estimate=388896 kB
  4. 2018-08-01 00:08:11.251 UTC @ 1141 LOG: recovery restart point at 2164/1E074150
  5. 2018-08-01 00:08:11.251 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 00:08:09.747141+00
  6. 2018-08-01 00:10:09.285 UTC @ 1141 LOG: restartpoint starting: time
  7. 2018-08-01 00:27:08.817 UTC @ 1141 LOG: restartpoint complete: wrote 10015 buffers (1.0%); 0 transaction log file(s) added, 0 removed, 2 recycled; write=1017.987 s, sync=1.125 s, total=101
  8. 9.531 s; sync files=591, longest=0.241 s, average=0.001 s; distance=65071 kB, estimate=356513 kB
  9. 2018-08-01 00:27:08.817 UTC @ 1141 LOG: recovery restart point at 2164/22000028
  10. 2018-08-01 00:27:08.817 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 00:27:07.489174+00
  11. 2018-08-01 00:35:09.595 UTC @ 1141 LOG: restartpoint starting: time
  12. 2018-08-01 00:53:09.893 UTC @ 1141 LOG: restartpoint complete: wrote 10744 buffers (1.0%); 0 transaction log file(s) added, 0 removed, 5 recycled; write=1079.231 s, sync=0.676 s, total=108
  13. 0.298 s; sync files=556, longest=0.081 s, average=0.001 s; distance=84778 kB, estimate=329340 kB
  14. 2018-08-01 00:53:09.894 UTC @ 1141 LOG: recovery restart point at 2164/272CABF8
  15. 2018-08-01 00:53:09.894 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 00:53:09.768343+00
  16. 2018-08-01 01:04:24.132 UTC @ 1141 LOG: restartpoint starting: time
  17. 2018-08-01 01:22:24.509 UTC @ 1141 LOG: restartpoint complete: wrote 10869 buffers (1.0%); 0 transaction log file(s) added, 0 removed, 9 recycled; write=1079.628 s, sync=0.368 s, total=108
  18. 0.376 s; sync files=583, longest=0.103 s, average=0.000 s; distance=84187 kB, estimate=304824 kB
  19. 2018-08-01 01:22:24.509 UTC @ 1141 LOG: recovery restart point at 2164/2C501870
  20. 2018-08-01 01:22:24.509 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 01:22:22.850852+00
  21. 2018-08-01 01:38:12.793 UTC @ 4826 FATAL: could not send data to WAL stream: server closed the connection unexpectedly
  22. This probably means the server terminated abnormally
  23. before or while processing the request.
  24.  
  25. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  26. 2018-08-01 01:38:14.339 UTC @ 1076 LOG: restored log file "000000010000216400000090" from archive
  27. 2018-08-01 01:38:16.930 UTC @ 1076 LOG: restored log file "000000010000216400000091" from archive
  28. 2018-08-01 01:39:12.446 UTC @ 1076 LOG: restored log file "000000010000216400000092" from archive
  29. 2018-08-01 01:39:14.779 UTC @ 1076 LOG: restored log file "000000010000216400000093" from archive
  30. 2018-08-01 01:39:17.169 UTC @ 1076 LOG: restored log file "000000010000216400000094" from archive
  31. 2018-08-01 01:39:18.696 UTC @ 1076 LOG: restored log file "000000010000216400000095" from archive
  32. 2018-08-01 01:39:22.183 UTC @ 1076 LOG: restored log file "000000010000216400000096" from archive
  33. 2018-08-01 01:39:24.322 UTC @ 1076 LOG: restored log file "000000010000216400000097" from archive
  34. 2018-08-01 01:39:26.171 UTC @ 1076 LOG: restored log file "000000010000216400000098" from archive
  35. 2018-08-01 01:39:28.073 UTC @ 1076 LOG: restored log file "000000010000216400000099" from archive
  36. 2018-08-01 01:39:30.070 UTC @ 1076 LOG: restored log file "00000001000021640000009A" from archive
  37. 2018-08-01 01:39:31.645 UTC @ 1076 LOG: restored log file "00000001000021640000009B" from archive
  38. 2018-08-01 01:39:33.251 UTC @ 1076 LOG: restored log file "00000001000021640000009C" from archive
  39. 2018-08-01 01:40:14.418 UTC @ 1076 LOG: restored log file "00000001000021640000009D" from archive
  40. 2018-08-01 01:41:13.092 UTC @ 1076 LOG: restored log file "00000001000021640000009E" from archive
  41. 2018-08-01 01:41:14.513 UTC @ 1076 LOG: restored log file "00000001000021640000009F" from archive
  42. 2018-08-01 01:41:16.019 UTC @ 1076 LOG: restored log file "0000000100002164000000A0" from archive
  43. 2018-08-01 01:41:17.549 UTC @ 1076 LOG: restored log file "0000000100002164000000A1" from archive
  44. 2018-08-01 01:41:19.104 UTC @ 1076 LOG: restored log file "0000000100002164000000A2" from archive
  45. 2018-08-01 01:41:20.474 UTC @ 1076 LOG: restored log file "0000000100002164000000A3" from archive
  46. 2018-08-01 01:41:22.100 UTC @ 1076 LOG: restored log file "0000000100002164000000A4" from archive
  47. 2018-08-01 01:41:23.878 UTC @ 1076 LOG: restored log file "0000000100002164000000A5" from archive
  48. 2018-08-01 01:41:27.979 UTC @ 1076 LOG: restored log file "0000000100002164000000A6" from archive
  49. 2018-08-01 01:41:34.091 UTC @ 1076 LOG: restored log file "0000000100002164000000A7" from archive
  50. 2018-08-01 01:41:40.138 UTC @ 1076 LOG: restored log file "0000000100002164000000A8" from archive
  51. 2018-08-01 01:41:41.575 UTC @ 1076 LOG: restored log file "0000000100002164000000A9" from archive
  52. 2018-08-01 01:41:43.311 UTC @ 1076 LOG: restored log file "0000000100002164000000AA" from archive
  53. 2018-08-01 01:41:44.771 UTC @ 1076 LOG: restored log file "0000000100002164000000AB" from archive
  54. 2018-08-01 01:42:52.004 UTC @ 1076 LOG: restored log file "0000000100002164000000AC" from archive
  55. 2018-08-01 01:42:52.384 UTC @ 1141 LOG: restartpoint starting: xlog
  56. 2018-08-01 01:42:53.577 UTC @ 1076 LOG: restored log file "0000000100002164000000AD" from archive
  57. 2018-08-01 01:42:54.988 UTC @ 1076 LOG: restored log file "0000000100002164000000AE" from archive
  58. 2018-08-01 01:42:57.085 UTC @ 1076 LOG: restored log file "0000000100002164000000AF" from archive
  59. 2018-08-01 01:42:58.469 UTC @ 1076 LOG: restored log file "0000000100002164000000B0" from archive
  60. 2018-08-01 01:42:59.942 UTC @ 1076 LOG: restored log file "0000000100002164000000B1" from archive
  61. 2018-08-01 01:43:02.571 UTC @ 1076 LOG: restored log file "0000000100002164000000B2" from archive
  62. 2018-08-01 01:46:04.696 UTC @ 1076 LOG: restored log file "0000000100002164000000B3" from archive
  63. 2018-08-01 01:46:06.320 UTC @ 1076 LOG: restored log file "0000000100002164000000B4" from archive
  64. 2018-08-01 01:46:08.150 UTC @ 1076 LOG: restored log file "0000000100002164000000B5" from archive
  65. 2018-08-01 01:46:09.508 UTC @ 1076 LOG: restored log file "0000000100002164000000B6" from archive
  66. Connection closed by 23.23.186.15
  67. 2018-08-01 01:50:13.601 UTC @ 22743 LOG: started streaming WAL from primary at 2164/B6000000 on timeline 1
  68. 2018-08-01 01:53:14.682 UTC @ 22743 FATAL: could not send data to WAL stream: server closed the connection unexpectedly
  69. This probably means the server terminated abnormally
  70. before or while processing the request.
  71.  
  72. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  73. 2018-08-01 01:53:16.116 UTC @ 1076 LOG: restored log file "0000000100002164000000BD" from archive
  74. 2018-08-01 01:53:18.763 UTC @ 1076 LOG: restored log file "0000000100002164000000BE" from archive
  75. 2018-08-01 01:53:21.434 UTC @ 1076 LOG: restored log file "0000000100002164000000BF" from archive
  76. 2018-08-01 01:53:24.832 UTC @ 1076 LOG: restored log file "0000000100002164000000C0" from archive
  77. 2018-08-01 01:53:27.416 UTC @ 1076 LOG: restored log file "0000000100002164000000C1" from archive
  78. 2018-08-01 01:54:37.693 UTC @ 1076 LOG: restored log file "0000000100002164000000C2" from archive
  79. 2018-08-01 01:54:39.536 UTC @ 1076 LOG: restored log file "0000000100002164000000C3" from archive
  80. 2018-08-01 01:54:42.445 UTC @ 1076 LOG: restored log file "0000000100002164000000C4" from archive
  81. 2018-08-01 01:54:46.752 UTC @ 1076 LOG: restored log file "0000000100002164000000C5" from archive
  82. 2018-08-01 01:56:02.131 UTC @ 1076 LOG: restored log file "0000000100002164000000C6" from archive
  83. 2018-08-01 01:56:03.646 UTC @ 1141 LOG: could not link file "pg_xlog/xlogtemp.1141" to "pg_xlog/0000000100002164000000C6": File exists
  84. 2018-08-01 01:56:03.660 UTC @ 1141 LOG: restartpoint complete: wrote 276414 buffers (26.4%); 1 transaction log file(s) added, 145 removed, 0 recycled; write=708.987 s, sync=79.954 s, total
  85. =791.275 s; sync files=626, longest=63.055 s, average=0.127 s; distance=163553 kB, estimate=290697 kB
  86. 2018-08-01 01:56:03.660 UTC @ 1141 LOG: recovery restart point at 2164/364B9D68
  87. 2018-08-01 01:56:03.660 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 01:35:39.245924+00
  88. 2018-08-01 01:56:05.285 UTC @ 1076 LOG: restored log file "0000000100002164000000C7" from archive
  89. 2018-08-01 01:56:07.174 UTC @ 1076 LOG: restored log file "0000000100002164000000C8" from archive
  90. 2018-08-01 01:56:09.620 UTC @ 1076 LOG: restored log file "0000000100002164000000C9" from archive
  91. 2018-08-01 01:56:11.813 UTC @ 1076 LOG: restored log file "0000000100002164000000CA" from archive
  92. 2018-08-01 01:56:13.707 UTC @ 1076 LOG: restored log file "0000000100002164000000CB" from archive
  93. 2018-08-01 01:56:15.713 UTC @ 1076 LOG: restored log file "0000000100002164000000CC" from archive
  94. 2018-08-01 01:56:18.229 UTC @ 1076 LOG: restored log file "0000000100002164000000CD" from archive
  95. 2018-08-01 01:56:20.804 UTC @ 1076 LOG: restored log file "0000000100002164000000CE" from archive
  96. 2018-08-01 01:56:22.730 UTC @ 1076 LOG: restored log file "0000000100002164000000CF" from archive
  97. 2018-08-01 01:56:25.504 UTC @ 1076 LOG: restored log file "0000000100002164000000D0" from archive
  98. 2018-08-01 01:56:27.230 UTC @ 1076 LOG: restored log file "0000000100002164000000D1" from archive
  99. 2018-08-01 01:56:29.286 UTC @ 1076 LOG: restored log file "0000000100002164000000D2" from archive
  100. 2018-08-01 01:56:31.122 UTC @ 1076 LOG: restored log file "0000000100002164000000D3" from archive
  101. 2018-08-01 01:56:33.753 UTC @ 1076 LOG: restored log file "0000000100002164000000D4" from archive
  102. 2018-08-01 01:56:36.525 UTC @ 1076 LOG: restored log file "0000000100002164000000D5" from archive
  103. 2018-08-01 01:56:38.936 UTC @ 1076 LOG: restored log file "0000000100002164000000D6" from archive
  104. 2018-08-01 01:56:41.313 UTC @ 1076 LOG: restored log file "0000000100002164000000D7" from archive
  105. 2018-08-01 01:56:45.125 UTC @ 1076 LOG: restored log file "0000000100002164000000D8" from archive
  106. 2018-08-01 01:56:47.537 UTC @ 1076 LOG: restored log file "0000000100002164000000D9" from archive
  107. 2018-08-01 01:56:50.754 UTC @ 1076 LOG: restored log file "0000000100002164000000DA" from archive
  108. 2018-08-01 01:57:07.610 UTC @ 1076 LOG: restored log file "0000000100002164000000DB" from archive
  109. 2018-08-01 01:57:09.029 UTC @ 1076 LOG: restored log file "0000000100002164000000DC" from archive
  110. 2018-08-01 01:57:11.297 UTC @ 1076 LOG: restored log file "0000000100002164000000DD" from archive
  111. 2018-08-01 01:57:46.515 UTC @ 1076 LOG: restored log file "0000000100002164000000DE" from archive
  112. 2018-08-01 01:57:48.726 UTC @ 1076 LOG: restored log file "0000000100002164000000DF" from archive
  113. 2018-08-01 01:57:50.378 UTC @ 1076 LOG: restored log file "0000000100002164000000E0" from archive
  114. 2018-08-01 01:57:52.127 UTC @ 1076 LOG: restored log file "0000000100002164000000E1" from archive
  115. 2018-08-01 01:57:53.572 UTC @ 1076 LOG: restored log file "0000000100002164000000E2" from archive
  116. 2018-08-01 01:57:56.599 UTC @ 1076 LOG: restored log file "0000000100002164000000E3" from archive
  117. 2018-08-01 01:59:14.958 UTC @ 1076 LOG: restored log file "0000000100002164000000E4" from archive
  118. 2018-08-01 01:59:47.438 UTC @ 1076 LOG: restored log file "0000000100002164000000E5" from archive
  119. 2018-08-01 02:00:00.371 UTC @ 1076 LOG: restored log file "0000000100002164000000E6" from archive
  120. 2018-08-01 02:02:47.741 UTC @ 1076 LOG: restored log file "0000000100002164000000E7" from archive
  121. 2018-08-01 02:03:56.787 UTC @ 1076 LOG: restored log file "0000000100002164000000E8" from archive
  122. 2018-08-01 02:03:58.442 UTC @ 1076 LOG: restored log file "0000000100002164000000E9" from archive
  123. 2018-08-01 02:04:04.035 UTC @ 1076 LOG: restored log file "0000000100002164000000EA" from archive
  124. 2018-08-01 02:04:12.493 UTC @ 1076 LOG: restored log file "0000000100002164000000EB" from archive
  125. 2018-08-01 02:04:30.645 UTC @ 1076 LOG: restored log file "0000000100002164000000EC" from archive
  126. 2018-08-01 02:06:27.255 UTC @ 1076 LOG: restored log file "0000000100002164000000ED" from archive
  127. 2018-08-01 02:06:46.475 UTC @ 1076 LOG: restored log file "0000000100002164000000EE" from archive
  128. 2018-08-01 02:06:48.354 UTC @ 1076 LOG: restored log file "0000000100002164000000EF" from archive
  129. 2018-08-01 02:06:51.926 UTC @ 1076 LOG: restored log file "0000000100002164000000F0" from archive
  130. 2018-08-01 02:06:54.410 UTC @ 1076 LOG: restored log file "0000000100002164000000F1" from archive
  131. 2018-08-01 02:06:56.348 UTC @ 1076 LOG: restored log file "0000000100002164000000F2" from archive
  132. 2018-08-01 02:06:58.215 UTC @ 1076 LOG: restored log file "0000000100002164000000F3" from archive
  133. 2018-08-01 02:07:01.974 UTC @ 1076 LOG: restored log file "0000000100002164000000F4" from archive
  134. 2018-08-01 02:07:03.863 UTC @ 1076 LOG: restored log file "0000000100002164000000F5" from archive
  135. 2018-08-01 02:07:06.008 UTC @ 1076 LOG: restored log file "0000000100002164000000F6" from archive
  136. 2018-08-01 02:07:10.207 UTC @ 1076 LOG: restored log file "0000000100002164000000F7" from archive
  137. 2018-08-01 02:11:00.023 UTC @ 1076 LOG: restored log file "0000000100002164000000F8" from archive
  138. 2018-08-01 02:11:01.864 UTC @ 1076 LOG: restored log file "0000000100002164000000F9" from archive
  139. 2018-08-01 02:11:05.179 UTC @ 1076 LOG: restored log file "0000000100002164000000FA" from archive
  140. 2018-08-01 02:11:06.904 UTC @ 1076 LOG: restored log file "0000000100002164000000FB" from archive
  141. 2018-08-01 02:11:09.099 UTC @ 1076 LOG: restored log file "0000000100002164000000FC" from archive
  142. 2018-08-01 02:11:12.643 UTC @ 1076 LOG: restored log file "0000000100002164000000FD" from archive
  143. 2018-08-01 02:11:14.709 UTC @ 1076 LOG: restored log file "0000000100002164000000FE" from archive
  144. 2018-08-01 02:11:17.136 UTC @ 1076 LOG: restored log file "0000000100002164000000FF" from archive
  145. 2018-08-01 02:11:20.361 UTC @ 1076 LOG: restored log file "000000010000216500000000" from archive
  146. 2018-08-01 02:11:26.795 UTC @ 1076 LOG: restored log file "000000010000216500000001" from archive
  147. 2018-08-01 02:12:33.341 UTC @ 1076 LOG: restored log file "000000010000216500000002" from archive
  148. 2018-08-01 02:12:35.788 UTC @ 1076 LOG: restored log file "000000010000216500000003" from archive
  149. 2018-08-01 02:12:37.754 UTC @ 1076 LOG: restored log file "000000010000216500000004" from archive
  150. 2018-08-01 02:12:41.529 UTC @ 1076 LOG: restored log file "000000010000216500000005" from archive
  151. 2018-08-01 02:12:43.369 UTC @ 1076 LOG: restored log file "000000010000216500000006" from archive
  152. 2018-08-01 02:12:46.960 UTC @ 1076 LOG: restored log file "000000010000216500000007" from archive
  153. 2018-08-01 02:12:49.427 UTC @ 1076 LOG: restored log file "000000010000216500000008" from archive
  154. 2018-08-01 02:12:53.850 UTC @ 1076 LOG: restored log file "000000010000216500000009" from archive
  155. 2018-08-01 02:12:55.774 UTC @ 1076 LOG: restored log file "00000001000021650000000A" from archive
  156. 2018-08-01 02:12:58.183 UTC @ 1076 LOG: restored log file "00000001000021650000000B" from archive
  157. 2018-08-01 02:13:00.139 UTC @ 1076 LOG: restored log file "00000001000021650000000C" from archive
  158. 2018-08-01 02:13:01.934 UTC @ 1076 LOG: restored log file "00000001000021650000000D" from archive
  159. 2018-08-01 02:13:03.746 UTC @ 1076 LOG: restored log file "00000001000021650000000E" from archive
  160. 2018-08-01 02:13:05.767 UTC @ 1076 LOG: restored log file "00000001000021650000000F" from archive
  161. 2018-08-01 02:13:09.456 UTC @ 1076 LOG: restored log file "000000010000216500000010" from archive
  162. 2018-08-01 02:13:11.463 UTC @ 1076 LOG: restored log file "000000010000216500000011" from archive
  163. 2018-08-01 02:13:15.510 UTC @ 1076 LOG: restored log file "000000010000216500000012" from archive
  164. 2018-08-01 02:13:17.097 UTC @ 1076 LOG: restored log file "000000010000216500000013" from archive
  165. 2018-08-01 02:13:19.259 UTC @ 1076 LOG: restored log file "000000010000216500000014" from archive
  166. 2018-08-01 02:13:22.033 UTC @ 1076 LOG: restored log file "000000010000216500000015" from archive
  167. 2018-08-01 02:14:01.064 UTC @ 1076 LOG: restored log file "000000010000216500000016" from archive
  168. 2018-08-01 02:14:02.620 UTC @ 1076 LOG: restored log file "000000010000216500000017" from archive
  169. 2018-08-01 02:14:04.302 UTC @ 1076 LOG: restored log file "000000010000216500000018" from archive
  170. 2018-08-01 02:14:05.658 UTC @ 1076 LOG: restored log file "000000010000216500000019" from archive
  171. 2018-08-01 02:14:07.335 UTC @ 1076 LOG: restored log file "00000001000021650000001A" from archive
  172. 2018-08-01 02:14:09.838 UTC @ 1076 LOG: restored log file "00000001000021650000001B" from archive
  173. 2018-08-01 02:14:25.593 UTC @ 1076 LOG: restored log file "00000001000021650000001C" from archive
  174. 2018-08-01 02:14:27.529 UTC @ 1076 LOG: restored log file "00000001000021650000001D" from archive
  175. 2018-08-01 02:14:29.323 UTC @ 1076 LOG: restored log file "00000001000021650000001E" from archive
  176. 2018-08-01 02:14:31.615 UTC @ 1076 LOG: restored log file "00000001000021650000001F" from archive
  177. 2018-08-01 02:14:34.348 UTC @ 1076 LOG: restored log file "000000010000216500000020" from archive
  178. 2018-08-01 02:14:38.292 UTC @ 1076 LOG: restored log file "000000010000216500000021" from archive
  179. 2018-08-01 02:15:37.552 UTC @ 1076 LOG: restored log file "000000010000216500000022" from archive
  180. 2018-08-01 02:15:39.453 UTC @ 1076 LOG: restored log file "000000010000216500000023" from archive
  181. 2018-08-01 02:15:41.473 UTC @ 1076 LOG: restored log file "000000010000216500000024" from archive
  182. 2018-08-01 02:15:45.622 UTC @ 1076 LOG: restored log file "000000010000216500000025" from archive
  183. 2018-08-01 02:16:22.173 UTC @ 1076 LOG: restored log file "000000010000216500000026" from archive
  184. 2018-08-01 02:16:23.579 UTC @ 1076 LOG: restored log file "000000010000216500000027" from archive
  185. 2018-08-01 02:16:25.418 UTC @ 1076 LOG: restored log file "000000010000216500000028" from archive
  186. 2018-08-01 02:16:27.345 UTC @ 1076 LOG: restored log file "000000010000216500000029" from archive
  187. 2018-08-01 02:16:28.648 UTC @ 1076 LOG: restored log file "00000001000021650000002A" from archive
  188. 2018-08-01 02:16:30.565 UTC @ 1076 LOG: restored log file "00000001000021650000002B" from archive
  189. 2018-08-01 02:16:32.159 UTC @ 1076 LOG: restored log file "00000001000021650000002C" from archive
  190. 2018-08-01 02:17:19.843 UTC @ 1076 LOG: restored log file "00000001000021650000002D" from archive
  191. 2018-08-01 02:17:24.083 UTC @ 1076 LOG: restored log file "00000001000021650000002E" from archive
  192. 2018-08-01 02:17:27.149 UTC @ 1076 LOG: restored log file "00000001000021650000002F" from archive
  193. 2018-08-01 02:17:30.818 UTC @ 1076 LOG: restored log file "000000010000216500000030" from archive
  194. 2018-08-01 02:17:32.237 UTC @ 1076 LOG: restored log file "000000010000216500000031" from archive
  195. 2018-08-01 02:17:33.787 UTC @ 1076 LOG: restored log file "000000010000216500000032" from archive
  196. 2018-08-01 02:17:35.753 UTC @ 1076 LOG: restored log file "000000010000216500000033" from archive
  197. 2018-08-01 02:17:38.225 UTC @ 1076 LOG: restored log file "000000010000216500000034" from archive
  198. 2018-08-01 02:17:39.632 UTC @ 1076 LOG: restored log file "000000010000216500000035" from archive
  199. 2018-08-01 02:17:41.268 UTC @ 1076 LOG: restored log file "000000010000216500000036" from archive
  200. 2018-08-01 02:17:42.867 UTC @ 1076 LOG: restored log file "000000010000216500000037" from archive
  201. 2018-08-01 02:17:45.084 UTC @ 1076 LOG: restored log file "000000010000216500000038" from archive
  202. 2018-08-01 02:18:36.824 UTC @ 1076 LOG: restored log file "000000010000216500000039" from archive
  203. 2018-08-01 02:22:00.432 UTC @ 1076 LOG: restored log file "00000001000021650000003A" from archive
  204. 2018-08-01 02:22:01.727 UTC @ 1076 LOG: restored log file "00000001000021650000003B" from archive
  205. 2018-08-01 02:22:03.169 UTC @ 1076 LOG: restored log file "00000001000021650000003C" from archive
  206. 2018-08-01 02:22:04.459 UTC @ 1076 LOG: restored log file "00000001000021650000003D" from archive
  207. 2018-08-01 02:22:06.076 UTC @ 1076 LOG: restored log file "00000001000021650000003E" from archive
  208. 2018-08-01 02:22:07.653 UTC @ 1076 LOG: restored log file "00000001000021650000003F" from archive
  209. 2018-08-01 02:22:09.287 UTC @ 1076 LOG: restored log file "000000010000216500000040" from archive
  210. 2018-08-01 02:22:10.519 UTC @ 1076 LOG: restored log file "000000010000216500000041" from archive
  211. 2018-08-01 02:22:30.428 UTC @ 1076 LOG: restored log file "000000010000216500000042" from archive
  212. 2018-08-01 02:23:51.435 UTC @ 1076 LOG: restored log file "000000010000216500000043" from archive
  213. 2018-08-01 02:23:52.934 UTC @ 1076 LOG: restored log file "000000010000216500000044" from archive
  214. 2018-08-01 02:23:54.479 UTC @ 1076 LOG: restored log file "000000010000216500000045" from archive
  215. 2018-08-01 02:23:55.931 UTC @ 1076 LOG: restored log file "000000010000216500000046" from archive
  216. 2018-08-01 02:23:57.389 UTC @ 1076 LOG: restored log file "000000010000216500000047" from archive
  217. 2018-08-01 02:23:58.510 UTC @ 1076 LOG: restored log file "000000010000216500000048" from archive
  218. 2018-08-01 02:23:59.839 UTC @ 1076 LOG: restored log file "000000010000216500000049" from archive
  219. 2018-08-01 02:24:01.657 UTC @ 1076 LOG: restored log file "00000001000021650000004A" from archive
  220. 2018-08-01 02:24:12.699 UTC @ 1076 LOG: restored log file "00000001000021650000004B" from archive
  221. 2018-08-01 02:24:14.719 UTC @ 1076 LOG: restored log file "00000001000021650000004C" from archive
  222. 2018-08-01 02:24:18.915 UTC @ 1076 LOG: restored log file "00000001000021650000004D" from archive
  223. 2018-08-01 02:24:20.300 UTC @ 1076 LOG: restored log file "00000001000021650000004E" from archive
  224. 2018-08-01 02:24:22.189 UTC @ 1076 LOG: restored log file "00000001000021650000004F" from archive
  225. 2018-08-01 02:26:15.703 UTC @ 1076 LOG: restored log file "000000010000216500000050" from archive
  226. 2018-08-01 02:29:35.012 UTC @ 1076 LOG: restored log file "000000010000216500000051" from archive
  227. 2018-08-01 02:30:09.332 UTC @ 1076 LOG: restored log file "000000010000216500000052" from archive
  228. 2018-08-01 02:30:13.244 UTC @ 1076 LOG: restored log file "000000010000216500000053" from archive
  229. 2018-08-01 02:30:15.895 UTC @ 1076 LOG: restored log file "000000010000216500000054" from archive
  230. 2018-08-01 02:30:17.800 UTC @ 1076 LOG: restored log file "000000010000216500000055" from archive
  231. 2018-08-01 02:30:19.459 UTC @ 1076 LOG: restored log file "000000010000216500000056" from archive
  232. 2018-08-01 02:30:21.457 UTC @ 1076 LOG: restored log file "000000010000216500000057" from archive
  233. 2018-08-01 02:30:23.486 UTC @ 1076 LOG: restored log file "000000010000216500000058" from archive
  234. 2018-08-01 02:30:25.382 UTC @ 1076 LOG: restored log file "000000010000216500000059" from archive
  235. 2018-08-01 02:30:27.802 UTC @ 1076 LOG: restored log file "00000001000021650000005A" from archive
  236. 2018-08-01 02:30:30.284 UTC @ 1076 LOG: restored log file "00000001000021650000005B" from archive
  237. 2018-08-01 02:30:32.114 UTC @ 1076 LOG: restored log file "00000001000021650000005C" from archive
  238. 2018-08-01 02:30:33.803 UTC @ 1076 LOG: restored log file "00000001000021650000005D" from archive
  239. 2018-08-01 02:30:35.705 UTC @ 1076 LOG: restored log file "00000001000021650000005E" from archive
  240. 2018-08-01 02:30:36.537 UTC @ 1141 LOG: restartpoint starting: xlog
  241. 2018-08-01 02:30:38.086 UTC @ 1076 LOG: restored log file "00000001000021650000005F" from archive
  242. 2018-08-01 02:30:44.144 UTC @ 1076 LOG: restored log file "000000010000216500000060" from archive
  243. 2018-08-01 02:31:09.172 UTC @ 1076 LOG: restored log file "000000010000216500000061" from archive
  244. 2018-08-01 02:31:12.132 UTC @ 1076 LOG: restored log file "000000010000216500000062" from archive
  245. 2018-08-01 02:31:15.737 UTC @ 1076 LOG: restored log file "000000010000216500000063" from archive
  246. 2018-08-01 02:31:18.977 UTC @ 1076 LOG: restored log file "000000010000216500000064" from archive
  247. 2018-08-01 02:31:23.379 UTC @ 1076 LOG: restored log file "000000010000216500000065" from archive
  248. 2018-08-01 02:31:29.062 UTC @ 1076 LOG: restored log file "000000010000216500000066" from archive
  249. 2018-08-01 02:31:31.914 UTC @ 1076 LOG: restored log file "000000010000216500000067" from archive
  250. 2018-08-01 02:31:56.673 UTC @ 1076 LOG: restored log file "000000010000216500000068" from archive
  251. 2018-08-01 02:37:19.913 UTC @ 1076 LOG: restored log file "000000010000216500000069" from archive
  252. 2018-08-01 02:37:21.488 UTC @ 1076 LOG: restored log file "00000001000021650000006A" from archive
  253. 2018-08-01 02:37:22.883 UTC @ 1076 LOG: restored log file "00000001000021650000006B" from archive
  254. 2018-08-01 02:37:24.625 UTC @ 1076 LOG: restored log file "00000001000021650000006C" from archive
  255. 2018-08-01 02:37:28.339 UTC @ 1076 LOG: restored log file "00000001000021650000006D" from archive
  256. 2018-08-01 02:37:29.966 UTC @ 1076 LOG: restored log file "00000001000021650000006E" from archive
  257. 2018-08-01 02:41:16.801 UTC @ 1076 LOG: restored log file "00000001000021650000006F" from archive
  258. 2018-08-01 02:41:59.947 UTC @ 1076 LOG: restored log file "000000010000216500000070" from archive
  259. 2018-08-01 02:42:03.110 UTC @ 1076 LOG: restored log file "000000010000216500000071" from archive
  260. 2018-08-01 02:42:04.898 UTC @ 1076 LOG: restored log file "000000010000216500000072" from archive
  261. 2018-08-01 02:42:06.712 UTC @ 1076 LOG: restored log file "000000010000216500000073" from archive
  262. 2018-08-01 02:42:10.188 UTC @ 1076 LOG: restored log file "000000010000216500000074" from archive
  263. 2018-08-01 02:42:13.302 UTC @ 1076 LOG: restored log file "000000010000216500000075" from archive
  264. 2018-08-01 02:42:16.599 UTC @ 1076 LOG: restored log file "000000010000216500000076" from archive
  265. 2018-08-01 02:42:20.506 UTC @ 1076 LOG: restored log file "000000010000216500000077" from archive
  266. 2018-08-01 02:42:22.436 UTC @ 1076 LOG: restored log file "000000010000216500000078" from archive
  267. 2018-08-01 02:42:26.525 UTC @ 1076 LOG: restored log file "000000010000216500000079" from archive
  268. 2018-08-01 02:42:28.654 UTC @ 1076 LOG: restored log file "00000001000021650000007A" from archive
  269. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000001000021650000007B: No such file or directory
  270. 2018-08-01 02:43:38.509 UTC @ 25929 LOG: started streaming WAL from primary at 2165/7A000000 on timeline 1
  271. 2018-08-01 02:48:11.854 UTC @ 25929 FATAL: could not send data to WAL stream: server closed the connection unexpectedly
  272. This probably means the server terminated abnormally
  273. before or while processing the request.
  274.  
  275. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  276. 2018-08-01 02:48:13.558 UTC @ 1076 LOG: restored log file "00000001000021650000007B" from archive
  277. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000001000021650000007C: No such file or directory
  278. 2018-08-01 02:48:19.812 UTC @ 26212 LOG: started streaming WAL from primary at 2165/7B000000 on timeline 1
  279. 2018-08-01 02:48:34.377 UTC @ 1141 LOG: restartpoint complete: wrote 564949 buffers (53.9%); 0 transaction log file(s) added, 183 removed, 0 recycled; write=698.729 s, sync=378.354 s, tota
  280. l=1077.839 s; sync files=757, longest=251.544 s, average=0.499 s; distance=4755690 kB, estimate=4755690 kB
  281. 2018-08-01 02:48:34.377 UTC @ 1141 LOG: recovery restart point at 2165/588F45B8
  282. 2018-08-01 02:48:34.377 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 02:48:34.009339+00
  283. 2018-08-01 02:48:34.380 UTC @ 1141 LOG: restartpoint starting: xlog
  284. 2018-08-01 03:06:50.847 UTC @ 1141 LOG: restartpoint complete: wrote 70595 buffers (6.7%); 0 transaction log file(s) added, 0 removed, 6 recycled; write=1079.298 s, sync=16.309 s, total=10
  285. 96.467 s; sync files=587, longest=3.648 s, average=0.027 s; distance=324937 kB, estimate=4312614 kB
  286. 2018-08-01 03:06:50.847 UTC @ 1141 LOG: recovery restart point at 2165/6C646A98
  287. 2018-08-01 03:06:50.847 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 03:06:48.564206+00
  288. 2018-08-01 03:08:34.876 UTC @ 1141 LOG: restartpoint starting: time
  289. 2018-08-01 03:26:34.997 UTC @ 1141 LOG: restartpoint complete: wrote 15521 buffers (1.5%); 0 transaction log file(s) added, 0 removed, 5 recycled; write=1078.958 s, sync=0.861 s, total=108
  290. 0.120 s; sync files=464, longest=0.170 s, average=0.001 s; distance=324598 kB, estimate=3913813 kB
  291. 2018-08-01 03:26:34.997 UTC @ 1141 LOG: recovery restart point at 2165/80344458
  292. 2018-08-01 03:26:34.997 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 03:26:34.68417+00
  293. 2018-08-01 03:38:35.100 UTC @ 1141 LOG: restartpoint starting: time
  294. 2018-08-01 03:56:36.043 UTC @ 1141 LOG: restartpoint complete: wrote 20281 buffers (1.9%); 0 transaction log file(s) added, 0 removed, 10 recycled; write=1079.783 s, sync=0.733 s, total=10
  295. 80.942 s; sync files=484, longest=0.137 s, average=0.001 s; distance=141164 kB, estimate=3536548 kB
  296. 2018-08-01 03:56:36.043 UTC @ 1141 LOG: recovery restart point at 2165/88D1F728
  297. 2018-08-01 03:56:36.043 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 03:56:35.822907+00
  298. 2018-08-01 04:04:50.363 UTC @ 1141 LOG: restartpoint starting: time
  299. 2018-08-01 04:20:47.811 UTC @ 1141 LOG: restartpoint complete: wrote 30396 buffers (2.9%); 0 transaction log file(s) added, 4 removed, 25 recycled; write=952.777 s, sync=3.930 s, total=957
  300. .447 s; sync files=581, longest=1.544 s, average=0.006 s; distance=162407 kB, estimate=3199134 kB
  301. 2018-08-01 04:20:47.811 UTC @ 1141 LOG: recovery restart point at 2165/92BB9648
  302. 2018-08-01 04:20:47.811 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 04:20:47.707406+00
  303. 2018-08-01 04:32:33.436 UTC @ 1141 LOG: restartpoint starting: time
  304. 2018-08-01 04:51:07.799 UTC @ 1141 LOG: restartpoint complete: wrote 96378 buffers (9.2%); 0 transaction log file(s) added, 6 removed, 10 recycled; write=1088.294 s, sync=25.091 s, total=1
  305. 114.363 s; sync files=610, longest=1.575 s, average=0.041 s; distance=653889 kB, estimate=2944609 kB
  306. 2018-08-01 04:51:07.800 UTC @ 1141 LOG: recovery restart point at 2165/BAA49BA8
  307. 2018-08-01 04:51:07.800 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 04:51:07.670809+00
  308. 2018-08-01 05:03:04.287 UTC @ 1141 LOG: restartpoint starting: time
  309. 2018-08-01 05:21:06.002 UTC @ 1141 LOG: restartpoint complete: wrote 12638 buffers (1.2%); 0 transaction log file(s) added, 0 removed, 4 recycled; write=1079.441 s, sync=1.876 s, total=108
  310. 1.715 s; sync files=548, longest=0.494 s, average=0.003 s; distance=84072 kB, estimate=2658556 kB
  311. 2018-08-01 05:21:06.002 UTC @ 1141 LOG: recovery restart point at 2165/BFC63EC8
  312. 2018-08-01 05:21:06.002 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 05:21:05.540483+00
  313. 2018-08-01 05:32:34.883 UTC @ 1141 LOG: restartpoint starting: time
  314. 2018-08-01 05:43:42.645 UTC @ 1141 LOG: restartpoint complete: wrote 6456 buffers (0.6%); 0 transaction log file(s) added, 0 removed, 2 recycled; write=665.669 s, sync=1.857 s, total=667.7
  315. 62 s; sync files=465, longest=1.141 s, average=0.003 s; distance=50547 kB, estimate=2397755 kB
  316. 2018-08-01 05:43:42.645 UTC @ 1141 LOG: recovery restart point at 2165/C2DC0B48
  317. 2018-08-01 05:43:42.645 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 05:43:41.34112+00
  318. 2018-08-01 06:08:31.064 UTC @ 1141 LOG: restartpoint starting: time
  319. 2018-08-01 06:17:26.360 UTC @ 26212 FATAL: terminating walreceiver due to timeout
  320. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  321. 2018-08-01 06:17:27.889 UTC @ 1076 LOG: restored log file "0000000100002165000000E3" from archive
  322. 2018-08-01 06:17:33.944 UTC @ 1076 LOG: restored log file "0000000100002165000000E4" from archive
  323. 2018-08-01 06:17:36.301 UTC @ 1076 LOG: restored log file "0000000100002165000000E5" from archive
  324. 2018-08-01 06:17:38.143 UTC @ 1076 LOG: restored log file "0000000100002165000000E6" from archive
  325. 2018-08-01 06:17:39.766 UTC @ 1076 LOG: restored log file "0000000100002165000000E7" from archive
  326. 2018-08-01 06:20:26.591 UTC @ 1076 LOG: restored log file "0000000100002165000000E8" from archive
  327. 2018-08-01 06:20:30.704 UTC @ 1076 LOG: restored log file "0000000100002165000000E9" from archive
  328. 2018-08-01 06:20:33.175 UTC @ 1076 LOG: restored log file "0000000100002165000000EA" from archive
  329. 2018-08-01 06:20:37.403 UTC @ 1076 LOG: restored log file "0000000100002165000000EB" from archive
  330. 2018-08-01 06:20:39.905 UTC @ 1076 LOG: restored log file "0000000100002165000000EC" from archive
  331. 2018-08-01 06:20:41.267 UTC @ 1076 LOG: restored log file "0000000100002165000000ED" from archive
  332. 2018-08-01 06:20:43.167 UTC @ 1076 LOG: restored log file "0000000100002165000000EE" from archive
  333. 2018-08-01 06:20:44.843 UTC @ 1076 LOG: restored log file "0000000100002165000000EF" from archive
  334. 2018-08-01 06:20:46.330 UTC @ 1076 LOG: restored log file "0000000100002165000000F0" from archive
  335. 2018-08-01 06:20:49.835 UTC @ 1076 LOG: restored log file "0000000100002165000000F1" from archive
  336. 2018-08-01 06:20:51.270 UTC @ 1076 LOG: restored log file "0000000100002165000000F2" from archive
  337. 2018-08-01 06:20:53.057 UTC @ 1076 LOG: restored log file "0000000100002165000000F3" from archive
  338. 2018-08-01 06:20:54.496 UTC @ 1076 LOG: restored log file "0000000100002165000000F4" from archive
  339. 2018-08-01 06:22:15.897 UTC @ 1076 LOG: restored log file "0000000100002165000000F5" from archive
  340. 2018-08-01 06:22:23.029 UTC @ 1076 LOG: restored log file "0000000100002165000000F6" from archive
  341. 2018-08-01 06:26:30.623 UTC @ 1076 LOG: restored log file "0000000100002165000000F7" from archive
  342. 2018-08-01 06:26:32.498 UTC @ 1076 LOG: restored log file "0000000100002165000000F8" from archive
  343. 2018-08-01 06:26:34.156 UTC @ 1076 LOG: restored log file "0000000100002165000000F9" from archive
  344. 2018-08-01 06:26:36.288 UTC @ 1076 LOG: restored log file "0000000100002165000000FA" from archive
  345. 2018-08-01 06:26:37.897 UTC @ 1076 LOG: restored log file "0000000100002165000000FB" from archive
  346. 2018-08-01 06:26:39.567 UTC @ 1076 LOG: restored log file "0000000100002165000000FC" from archive
  347. 2018-08-01 06:26:42.535 UTC @ 1076 LOG: restored log file "0000000100002165000000FD" from archive
  348. 2018-08-01 06:26:45.944 UTC @ 1076 LOG: restored log file "0000000100002165000000FE" from archive
  349. 2018-08-01 06:26:49.233 UTC @ 1076 LOG: restored log file "0000000100002165000000FF" from archive
  350. 2018-08-01 06:26:51.529 UTC @ 1076 LOG: restored log file "000000010000216600000000" from archive
  351. 2018-08-01 06:26:53.824 UTC @ 1076 LOG: restored log file "000000010000216600000001" from archive
  352. 2018-08-01 06:26:56.712 UTC @ 1076 LOG: restored log file "000000010000216600000002" from archive
  353. 2018-08-01 06:26:58.668 UTC @ 1141 LOG: restartpoint complete: wrote 124135 buffers (11.8%); 1 transaction log file(s) added, 61 removed, 0 recycled; write=1078.140 s, sync=27.016 s, total
  354. =1107.603 s; sync files=638, longest=16.828 s, average=0.042 s; distance=174598 kB, estimate=2175439 kB
  355. 2018-08-01 06:26:58.668 UTC @ 1141 LOG: recovery restart point at 2165/CD842500
  356. 2018-08-01 06:26:58.668 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 06:13:21.87563+00
  357. 2018-08-01 06:26:59.746 UTC @ 1076 LOG: restored log file "000000010000216600000003" from archive
  358. 2018-08-01 06:27:01.256 UTC @ 1076 LOG: restored log file "000000010000216600000004" from archive
  359. 2018-08-01 06:27:03.471 UTC @ 1076 LOG: restored log file "000000010000216600000005" from archive
  360. 2018-08-01 06:27:05.150 UTC @ 1076 LOG: restored log file "000000010000216600000006" from archive
  361. 2018-08-01 06:27:06.750 UTC @ 1076 LOG: restored log file "000000010000216600000007" from archive
  362. 2018-08-01 06:27:08.909 UTC @ 1076 LOG: restored log file "000000010000216600000008" from archive
  363. 2018-08-01 06:27:10.371 UTC @ 1076 LOG: restored log file "000000010000216600000009" from archive
  364. 2018-08-01 06:27:11.777 UTC @ 1076 LOG: restored log file "00000001000021660000000A" from archive
  365. 2018-08-01 06:27:13.480 UTC @ 1076 LOG: restored log file "00000001000021660000000B" from archive
  366. 2018-08-01 06:27:15.176 UTC @ 1076 LOG: restored log file "00000001000021660000000C" from archive
  367. 2018-08-01 06:27:17.966 UTC @ 1076 LOG: restored log file "00000001000021660000000D" from archive
  368. 2018-08-01 06:27:19.789 UTC @ 1076 LOG: restored log file "00000001000021660000000E" from archive
  369. 2018-08-01 06:27:21.922 UTC @ 1076 LOG: restored log file "00000001000021660000000F" from archive
  370. 2018-08-01 06:27:23.885 UTC @ 1076 LOG: restored log file "000000010000216600000010" from archive
  371. 2018-08-01 06:27:26.185 UTC @ 1076 LOG: restored log file "000000010000216600000011" from archive
  372. 2018-08-01 06:27:28.765 UTC @ 1076 LOG: restored log file "000000010000216600000012" from archive
  373. 2018-08-01 06:27:30.390 UTC @ 1076 LOG: restored log file "000000010000216600000013" from archive
  374. 2018-08-01 06:27:32.453 UTC @ 1076 LOG: restored log file "000000010000216600000014" from archive
  375. 2018-08-01 06:27:34.277 UTC @ 1076 LOG: restored log file "000000010000216600000015" from archive
  376. 2018-08-01 06:27:36.565 UTC @ 1076 LOG: restored log file "000000010000216600000016" from archive
  377. 2018-08-01 06:27:38.031 UTC @ 1076 LOG: restored log file "000000010000216600000017" from archive
  378. 2018-08-01 06:27:39.687 UTC @ 1076 LOG: restored log file "000000010000216600000018" from archive
  379. 2018-08-01 06:27:41.727 UTC @ 1076 LOG: restored log file "000000010000216600000019" from archive
  380. 2018-08-01 06:27:43.523 UTC @ 1076 LOG: restored log file "00000001000021660000001A" from archive
  381. 2018-08-01 06:27:45.284 UTC @ 1076 LOG: restored log file "00000001000021660000001B" from archive
  382. 2018-08-01 06:27:46.933 UTC @ 1076 LOG: restored log file "00000001000021660000001C" from archive
  383. 2018-08-01 06:27:50.182 UTC @ 1076 LOG: restored log file "00000001000021660000001D" from archive
  384. 2018-08-01 06:27:51.952 UTC @ 1076 LOG: restored log file "00000001000021660000001E" from archive
  385. 2018-08-01 06:27:54.066 UTC @ 1076 LOG: restored log file "00000001000021660000001F" from archive
  386. 2018-08-01 06:27:56.385 UTC @ 1076 LOG: restored log file "000000010000216600000020" from archive
  387. 2018-08-01 06:27:58.034 UTC @ 1076 LOG: restored log file "000000010000216600000021" from archive
  388. 2018-08-01 06:28:00.070 UTC @ 1076 LOG: restored log file "000000010000216600000022" from archive
  389. 2018-08-01 06:28:01.824 UTC @ 1076 LOG: restored log file "000000010000216600000023" from archive
  390. 2018-08-01 06:28:03.718 UTC @ 1076 LOG: restored log file "000000010000216600000024" from archive
  391. 2018-08-01 06:28:05.464 UTC @ 1076 LOG: restored log file "000000010000216600000025" from archive
  392. 2018-08-01 06:28:07.588 UTC @ 1076 LOG: restored log file "000000010000216600000026" from archive
  393. 2018-08-01 06:28:09.253 UTC @ 1076 LOG: restored log file "000000010000216600000027" from archive
  394. 2018-08-01 06:28:10.844 UTC @ 1076 LOG: restored log file "000000010000216600000028" from archive
  395. 2018-08-01 06:28:13.293 UTC @ 1076 LOG: restored log file "000000010000216600000029" from archive
  396. 2018-08-01 06:28:17.462 UTC @ 1076 LOG: restored log file "00000001000021660000002A" from archive
  397. 2018-08-01 06:28:19.209 UTC @ 1076 LOG: restored log file "00000001000021660000002B" from archive
  398. 2018-08-01 06:28:22.746 UTC @ 1076 LOG: restored log file "00000001000021660000002C" from archive
  399. 2018-08-01 06:28:24.434 UTC @ 1076 LOG: restored log file "00000001000021660000002D" from archive
  400. 2018-08-01 06:28:25.947 UTC @ 1076 LOG: restored log file "00000001000021660000002E" from archive
  401. 2018-08-01 06:28:29.456 UTC @ 1076 LOG: restored log file "00000001000021660000002F" from archive
  402. 2018-08-01 06:28:31.312 UTC @ 1076 LOG: restored log file "000000010000216600000030" from archive
  403. 2018-08-01 06:28:33.972 UTC @ 1076 LOG: restored log file "000000010000216600000031" from archive
  404. 2018-08-01 06:28:35.524 UTC @ 1076 LOG: restored log file "000000010000216600000032" from archive
  405. 2018-08-01 06:28:36.798 UTC @ 1076 LOG: restored log file "000000010000216600000033" from archive
  406. 2018-08-01 06:28:37.960 UTC @ 1076 LOG: restored log file "000000010000216600000034" from archive
  407. 2018-08-01 06:28:40.082 UTC @ 1076 LOG: restored log file "000000010000216600000035" from archive
  408. 2018-08-01 06:28:41.990 UTC @ 1076 LOG: restored log file "000000010000216600000036" from archive
  409. 2018-08-01 06:28:43.520 UTC @ 1076 LOG: restored log file "000000010000216600000037" from archive
  410. 2018-08-01 06:28:44.790 UTC @ 1076 LOG: restored log file "000000010000216600000038" from archive
  411. 2018-08-01 06:28:46.621 UTC @ 1076 LOG: restored log file "000000010000216600000039" from archive
  412. 2018-08-01 06:28:51.289 UTC @ 1076 LOG: restored log file "00000001000021660000003A" from archive
  413. 2018-08-01 06:28:57.012 UTC @ 1076 LOG: restored log file "00000001000021660000003B" from archive
  414. 2018-08-01 06:29:00.768 UTC @ 1076 LOG: restored log file "00000001000021660000003C" from archive
  415. 2018-08-01 06:29:09.359 UTC @ 1076 LOG: restored log file "00000001000021660000003D" from archive
  416. 2018-08-01 06:29:11.812 UTC @ 1076 LOG: restored log file "00000001000021660000003E" from archive
  417. 2018-08-01 06:29:13.570 UTC @ 1076 LOG: restored log file "00000001000021660000003F" from archive
  418. 2018-08-01 06:29:15.367 UTC @ 1076 LOG: restored log file "000000010000216600000040" from archive
  419. 2018-08-01 06:29:19.013 UTC @ 1076 LOG: restored log file "000000010000216600000041" from archive
  420. 2018-08-01 06:29:21.450 UTC @ 1076 LOG: restored log file "000000010000216600000042" from archive
  421. 2018-08-01 06:29:24.303 UTC @ 1076 LOG: restored log file "000000010000216600000043" from archive
  422. 2018-08-01 06:29:25.782 UTC @ 1076 LOG: restored log file "000000010000216600000044" from archive
  423. 2018-08-01 06:29:29.423 UTC @ 1076 LOG: restored log file "000000010000216600000045" from archive
  424. 2018-08-01 06:29:33.282 UTC @ 1076 LOG: restored log file "000000010000216600000046" from archive
  425. 2018-08-01 06:29:34.668 UTC @ 1141 LOG: restartpoint starting: xlog
  426. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/000000010000216600000047: No such file or directory
  427. 2018-08-01 06:29:35.185 UTC @ 6438 LOG: started streaming WAL from primary at 2166/47000000 on timeline 1
  428. 2018-08-01 06:43:14.435 UTC @ 6438 FATAL: could not receive data from WAL stream: server closed the connection unexpectedly
  429. This probably means the server terminated abnormally
  430. before or while processing the request.
  431.  
  432. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  433. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/000000010000216600000048: No such file or directory
  434. 2018-08-01 06:43:15.359 UTC @ 1076 LOG: invalid record length at 2166/4809DA80
  435. 2018-08-01 06:43:15.466 UTC @ 7050 LOG: started streaming WAL from primary at 2166/48000000 on timeline 1
  436. 2018-08-01 07:00:47.315 UTC @ 7050 FATAL: could not receive data from WAL stream: server closed the connection unexpectedly
  437. This probably means the server terminated abnormally
  438. before or while processing the request.
  439.  
  440. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  441. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/000000010000216600000049: No such file or directory
  442. 2018-08-01 07:00:48.374 UTC @ 1076 LOG: invalid record length at 2166/491D1530
  443. 2018-08-01 07:00:48.488 UTC @ 8139 LOG: started streaming WAL from primary at 2166/49000000 on timeline 1
  444. 2018-08-01 07:08:20.667 UTC @ 8139 FATAL: terminating walreceiver due to timeout
  445. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  446. 2018-08-01 07:08:22.373 UTC @ 1076 LOG: restored log file "00000001000021660000004B" from archive
  447. 2018-08-01 07:08:30.647 UTC @ 1076 LOG: restored log file "00000001000021660000004C" from archive
  448. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000001000021660000004D: No such file or directory
  449. 2018-08-01 07:08:33.824 UTC @ 8668 LOG: started streaming WAL from primary at 2166/4C000000 on timeline 1
  450. 2018-08-01 07:09:33.729 UTC @ 1141 LOG: restartpoint complete: wrote 392873 buffers (37.5%); 0 transaction log file(s) added, 76 removed, 0 recycled; write=2317.540 s, sync=80.864 s, total
  451. =2399.061 s; sync files=2206, longest=40.551 s, average=0.036 s; distance=1679094 kB, estimate=2125805 kB
  452. 2018-08-01 07:09:33.729 UTC @ 1141 LOG: recovery restart point at 2166/34000028
  453. 2018-08-01 07:09:33.729 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 07:09:33.092763+00
  454. 2018-08-01 07:09:33.735 UTC @ 1141 LOG: restartpoint starting: xlog time
  455. 2018-08-01 07:27:36.924 UTC @ 1141 LOG: restartpoint complete: wrote 15682 buffers (1.5%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=1078.556 s, sync=3.593 s, total=108
  456. 3.189 s; sync files=496, longest=1.642 s, average=0.007 s; distance=331920 kB, estimate=1946416 kB
  457. 2018-08-01 07:27:36.924 UTC @ 1141 LOG: recovery restart point at 2166/484243A0
  458. 2018-08-01 07:27:36.924 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 07:27:36.612258+00
  459. 2018-08-01 07:29:33.928 UTC @ 1141 LOG: restartpoint starting: time
  460. 2018-08-01 07:35:22.306 UTC @ 1141 LOG: restartpoint complete: wrote 3287 buffers (0.3%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=346.343 s, sync=1.796 s, total=348.3
  461. 78 s; sync files=321, longest=0.390 s, average=0.005 s; distance=88985 kB, estimate=1760673 kB
  462. 2018-08-01 07:35:22.306 UTC @ 1141 LOG: recovery restart point at 2166/4DB0AB40
  463. 2018-08-01 07:35:22.306 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 07:35:21.862724+00
  464. 2018-08-01 07:45:32.839 UTC @ 8668 FATAL: could not send data to WAL stream: server closed the connection unexpectedly
  465. This probably means the server terminated abnormally
  466. before or while processing the request.
  467.  
  468. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  469. 2018-08-01 07:45:34.393 UTC @ 1076 LOG: restored log file "0000000100002166000000A3" from archive
  470. 2018-08-01 07:45:37.563 UTC @ 1076 LOG: restored log file "0000000100002166000000A4" from archive
  471. 2018-08-01 07:47:08.319 UTC @ 1076 LOG: restored log file "0000000100002166000000A5" from archive
  472. 2018-08-01 07:47:10.018 UTC @ 1076 LOG: restored log file "0000000100002166000000A6" from archive
  473. 2018-08-01 07:47:11.600 UTC @ 1076 LOG: restored log file "0000000100002166000000A7" from archive
  474. 2018-08-01 07:47:13.380 UTC @ 1076 LOG: restored log file "0000000100002166000000A8" from archive
  475. 2018-08-01 07:49:26.587 UTC @ 1076 LOG: restored log file "0000000100002166000000A9" from archive
  476. 2018-08-01 07:49:28.524 UTC @ 1076 LOG: restored log file "0000000100002166000000AA" from archive
  477. 2018-08-01 07:49:30.174 UTC @ 1076 LOG: restored log file "0000000100002166000000AB" from archive
  478. 2018-08-01 07:49:31.904 UTC @ 1076 LOG: restored log file "0000000100002166000000AC" from archive
  479. 2018-08-01 07:50:37.993 UTC @ 1076 LOG: restored log file "0000000100002166000000AD" from archive
  480. 2018-08-01 07:50:41.513 UTC @ 1076 LOG: restored log file "0000000100002166000000AE" from archive
  481. 2018-08-01 07:50:43.247 UTC @ 1076 LOG: restored log file "0000000100002166000000AF" from archive
  482. 2018-08-01 07:51:16.568 UTC @ 1076 LOG: restored log file "0000000100002166000000B0" from archive
  483. 2018-08-01 07:51:21.842 UTC @ 1076 LOG: restored log file "0000000100002166000000B1" from archive
  484. 2018-08-01 07:51:23.587 UTC @ 1076 LOG: restored log file "0000000100002166000000B2" from archive
  485. 2018-08-01 07:51:24.994 UTC @ 1076 LOG: restored log file "0000000100002166000000B3" from archive
  486. 2018-08-01 07:51:26.522 UTC @ 1076 LOG: restored log file "0000000100002166000000B4" from archive
  487. 2018-08-01 07:51:28.127 UTC @ 1076 LOG: restored log file "0000000100002166000000B5" from archive
  488. 2018-08-01 07:52:03.202 UTC @ 1076 LOG: restored log file "0000000100002166000000B6" from archive
  489. 2018-08-01 07:52:05.839 UTC @ 1076 LOG: restored log file "0000000100002166000000B7" from archive
  490. 2018-08-01 07:52:07.936 UTC @ 1076 LOG: restored log file "0000000100002166000000B8" from archive
  491. 2018-08-01 07:52:13.178 UTC @ 1076 LOG: restored log file "0000000100002166000000B9" from archive
  492. 2018-08-01 07:52:21.577 UTC @ 1076 LOG: restored log file "0000000100002166000000BA" from archive
  493. 2018-08-01 07:52:28.021 UTC @ 1076 LOG: restored log file "0000000100002166000000BB" from archive
  494. 2018-08-01 07:52:30.016 UTC @ 1076 LOG: restored log file "0000000100002166000000BC" from archive
  495. 2018-08-01 07:52:33.095 UTC @ 1076 LOG: restored log file "0000000100002166000000BD" from archive
  496. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/0000000100002166000000BE: No such file or directory
  497. 2018-08-01 07:52:41.918 UTC @ 11182 LOG: started streaming WAL from primary at 2166/BD000000 on timeline 1
  498. 2018-08-01 07:52:56.485 UTC @ 1141 LOG: restartpoint starting: time
  499. 2018-08-01 08:09:02.717 UTC @ 11182 FATAL: could not send data to WAL stream: server closed the connection unexpectedly
  500. This probably means the server terminated abnormally
  501. before or while processing the request.
  502.  
  503. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  504. 2018-08-01 08:09:04.454 UTC @ 1076 LOG: restored log file "0000000100002166000000C0" from archive
  505. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/0000000100002166000000C1: No such file or directory
  506. 2018-08-01 08:09:06.557 UTC @ 12040 LOG: started streaming WAL from primary at 2166/C0000000 on timeline 1
  507. 2018-08-01 08:18:30.134 UTC @ 1141 LOG: restartpoint complete: wrote 252697 buffers (24.1%); 0 transaction log file(s) added, 115 removed, 0 recycled; write=1255.343 s, sync=277.319 s, tot
  508. al=1533.649 s; sync files=597, longest=194.377 s, average=0.464 s; distance=1797784 kB, estimate=1797784 kB
  509. 2018-08-01 08:18:30.135 UTC @ 1141 LOG: recovery restart point at 2166/BB6B0B58
  510. 2018-08-01 08:18:30.135 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 08:18:29.601769+00
  511. 2018-08-01 08:18:30.140 UTC @ 1141 LOG: restartpoint starting: time
  512. 2018-08-01 08:34:07.649 UTC @ 1141 LOG: restartpoint complete: wrote 8941 buffers (0.9%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=930.548 s, sync=6.401 s, total=937.5
  513. 09 s; sync files=468, longest=2.185 s, average=0.013 s; distance=109488 kB, estimate=1628954 kB
  514. 2018-08-01 08:34:07.649 UTC @ 1141 LOG: recovery restart point at 2166/C219CD08
  515. 2018-08-01 08:34:07.649 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 08:34:07.461319+00
  516. 2018-08-01 08:47:30.120 UTC @ 1141 LOG: restartpoint starting: time
  517. 2018-08-01 09:05:02.726 UTC @ 1141 LOG: restartpoint complete: wrote 26083 buffers (2.5%); 0 transaction log file(s) added, 28 removed, 17 recycled; write=1032.763 s, sync=17.591 s, total=
  518. 1052.605 s; sync files=527, longest=2.099 s, average=0.033 s; distance=254566 kB, estimate=1491515 kB
  519. 2018-08-01 09:05:02.726 UTC @ 1141 LOG: recovery restart point at 2166/D1A367C0
  520. 2018-08-01 09:05:02.726 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 09:04:48.986979+00
  521. 2018-08-01 09:17:07.163 UTC @ 1141 LOG: restartpoint starting: time
  522. 2018-08-01 09:24:22.249 UTC @ 12040 FATAL: could not send data to WAL stream: server closed the connection unexpectedly
  523. This probably means the server terminated abnormally
  524. before or while processing the request.
  525.  
  526. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  527. 2018-08-01 09:24:23.984 UTC @ 1076 LOG: restored log file "000000010000216700000019" from archive
  528. 2018-08-01 09:24:26.307 UTC @ 1076 LOG: restored log file "00000001000021670000001A" from archive
  529. 2018-08-01 09:24:28.234 UTC @ 1076 LOG: restored log file "00000001000021670000001B" from archive
  530. 2018-08-01 09:24:43.538 UTC @ 1076 LOG: restored log file "00000001000021670000001C" from archive
  531. 2018-08-01 09:26:36.603 UTC @ 1076 LOG: restored log file "00000001000021670000001D" from archive
  532. 2018-08-01 09:26:38.827 UTC @ 1076 LOG: restored log file "00000001000021670000001E" from archive
  533. 2018-08-01 09:26:40.920 UTC @ 1076 LOG: restored log file "00000001000021670000001F" from archive
  534. 2018-08-01 09:29:00.426 UTC @ 1076 LOG: restored log file "000000010000216700000020" from archive
  535. 2018-08-01 09:29:02.508 UTC @ 1076 LOG: restored log file "000000010000216700000021" from archive
  536. 2018-08-01 09:29:04.057 UTC @ 1076 LOG: restored log file "000000010000216700000022" from archive
  537. 2018-08-01 09:29:06.111 UTC @ 1076 LOG: restored log file "000000010000216700000023" from archive
  538. 2018-08-01 09:29:09.242 UTC @ 1076 LOG: restored log file "000000010000216700000024" from archive
  539. 2018-08-01 09:30:21.349 UTC @ 1076 LOG: restored log file "000000010000216700000025" from archive
  540. 2018-08-01 09:30:23.548 UTC @ 1076 LOG: restored log file "000000010000216700000026" from archive
  541. 2018-08-01 09:30:30.727 UTC @ 1076 LOG: restored log file "000000010000216700000027" from archive
  542. 2018-08-01 09:30:40.114 UTC @ 1076 LOG: restored log file "000000010000216700000028" from archive
  543. 2018-08-01 09:30:45.220 UTC @ 1076 LOG: restored log file "000000010000216700000029" from archive
  544. 2018-08-01 09:30:49.001 UTC @ 1076 LOG: restored log file "00000001000021670000002A" from archive
  545. 2018-08-01 09:30:50.962 UTC @ 1076 LOG: restored log file "00000001000021670000002B" from archive
  546. 2018-08-01 09:30:54.363 UTC @ 1076 LOG: restored log file "00000001000021670000002C" from archive
  547. 2018-08-01 09:30:58.569 UTC @ 1076 LOG: restored log file "00000001000021670000002D" from archive
  548. 2018-08-01 09:31:05.799 UTC @ 1076 LOG: restored log file "00000001000021670000002E" from archive
  549. 2018-08-01 09:31:08.037 UTC @ 1076 LOG: restored log file "00000001000021670000002F" from archive
  550. 2018-08-01 09:31:09.915 UTC @ 1076 LOG: restored log file "000000010000216700000030" from archive
  551. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/000000010000216700000031: No such file or directory
  552. 2018-08-01 09:31:11.054 UTC @ 16518 LOG: started streaming WAL from primary at 2167/30000000 on timeline 1
  553. 2018-08-01 09:31:18.520 UTC @ 1141 LOG: restartpoint complete: wrote 148134 buffers (14.1%); 0 transaction log file(s) added, 65 removed, 0 recycled; write=801.661 s, sync=49.398 s, total=
  554. 851.357 s; sync files=583, longest=26.094 s, average=0.084 s; distance=1026006 kB, estimate=1444964 kB
  555. 2018-08-01 09:31:18.520 UTC @ 1141 LOG: recovery restart point at 2167/1042C1B0
  556. 2018-08-01 09:31:18.520 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 09:31:17.117926+00
  557. 2018-08-01 09:56:05.960 UTC @ 1141 LOG: restartpoint starting: time
  558. 2018-08-01 10:14:16.738 UTC @ 1141 LOG: restartpoint complete: wrote 84845 buffers (8.1%); 0 transaction log file(s) added, 0 removed, 9 recycled; write=1078.642 s, sync=11.373 s, total=10
  559. 90.777 s; sync files=624, longest=6.538 s, average=0.018 s; distance=646161 kB, estimate=1365084 kB
  560. 2018-08-01 10:14:16.738 UTC @ 1141 LOG: recovery restart point at 2167/37B30828
  561. 2018-08-01 10:14:16.738 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 10:14:15.175405+00
  562. 2018-08-01 10:17:05.065 UTC @ 1141 LOG: restartpoint starting: time
  563. 2018-08-01 10:27:17.446 UTC @ 1141 LOG: restartpoint complete: wrote 5962 buffers (0.6%); 0 transaction log file(s) added, 0 removed, 2 recycled; write=611.167 s, sync=0.402 s, total=612.3
  564. 81 s; sync files=467, longest=0.245 s, average=0.000 s; distance=50533 kB, estimate=1233629 kB
  565. 2018-08-01 10:27:17.447 UTC @ 1141 LOG: recovery restart point at 2167/3AC89F80
  566. 2018-08-01 10:27:17.447 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 10:27:17.287741+00
  567. 2018-08-01 10:50:36.153 UTC @ 1141 LOG: restartpoint starting: time
  568. 2018-08-01 11:08:38.647 UTC @ 1141 LOG: restartpoint complete: wrote 20702 buffers (2.0%); 0 transaction log file(s) added, 0 removed, 16 recycled; write=1079.382 s, sync=2.143 s, total=10
  569. 82.494 s; sync files=562, longest=0.644 s, average=0.003 s; distance=107544 kB, estimate=1121020 kB
  570. 2018-08-01 11:08:38.647 UTC @ 1141 LOG: recovery restart point at 2167/41590168
  571. 2018-08-01 11:08:38.647 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 11:08:37.946297+00
  572. 2018-08-01 11:24:06.822 UTC @ 1141 LOG: restartpoint starting: time
  573. 2018-08-01 11:42:09.341 UTC @ 1141 LOG: restartpoint complete: wrote 35962 buffers (3.4%); 0 transaction log file(s) added, 0 removed, 16 recycled; write=1079.115 s, sync=2.280 s, total=10
  574. 82.519 s; sync files=573, longest=0.656 s, average=0.003 s; distance=214439 kB, estimate=1030362 kB
  575. 2018-08-01 11:42:09.341 UTC @ 1141 LOG: recovery restart point at 2167/4E6FA070
  576. 2018-08-01 11:42:09.341 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 11:42:08.877516+00
  577. 2018-08-01 11:52:37.271 UTC @ 1141 LOG: restartpoint starting: time
  578. 2018-08-01 12:10:45.214 UTC @ 1141 LOG: restartpoint complete: wrote 34489 buffers (3.3%); 0 transaction log file(s) added, 0 removed, 15 recycled; write=1079.664 s, sync=7.502 s, total=10
  579. 87.942 s; sync files=616, longest=1.977 s, average=0.012 s; distance=245709 kB, estimate=951897 kB
  580. 2018-08-01 12:10:45.214 UTC @ 1141 LOG: recovery restart point at 2167/5D6ED780
  581. 2018-08-01 12:10:45.214 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 12:10:45.094439+00
  582. 2018-08-01 12:21:38.734 UTC @ 1141 LOG: restartpoint starting: time
  583. 2018-08-01 12:39:41.002 UTC @ 1141 LOG: restartpoint complete: wrote 34716 buffers (3.3%); 0 transaction log file(s) added, 0 removed, 15 recycled; write=1079.447 s, sync=2.524 s, total=10
  584. 82.267 s; sync files=684, longest=0.611 s, average=0.003 s; distance=250708 kB, estimate=881778 kB
  585. 2018-08-01 12:39:41.002 UTC @ 1141 LOG: recovery restart point at 2167/6CBC2920
  586. 2018-08-01 12:39:41.002 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 12:39:40.673948+00
  587. 2018-08-01 12:52:10.568 UTC @ 1141 LOG: restartpoint starting: time
  588. 2018-08-01 13:10:13.937 UTC @ 1141 LOG: restartpoint complete: wrote 44142 buffers (4.2%); 0 transaction log file(s) added, 1 removed, 24 recycled; write=1079.069 s, sync=3.147 s, total=10
  589. 83.369 s; sync files=756, longest=1.021 s, average=0.004 s; distance=276186 kB, estimate=821219 kB
  590. 2018-08-01 13:10:13.938 UTC @ 1141 LOG: recovery restart point at 2167/7D9792D8
  591. 2018-08-01 13:10:13.938 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 13:10:13.806597+00
  592. 2018-08-01 13:21:27.524 UTC @ 1141 LOG: restartpoint starting: xlog
  593. 2018-08-01 13:39:36.528 UTC @ 1141 LOG: restartpoint complete: wrote 65134 buffers (6.2%); 0 transaction log file(s) added, 7 removed, 17 recycled; write=1079.670 s, sync=8.825 s, total=10
  594. 89.004 s; sync files=836, longest=1.355 s, average=0.010 s; distance=402823 kB, estimate=779379 kB
  595. 2018-08-01 13:39:36.528 UTC @ 1141 LOG: recovery restart point at 2167/962DB130
  596. 2018-08-01 13:39:36.528 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 13:39:36.477305+00
  597. 2018-08-01 13:50:42.571 UTC @ 1141 LOG: restartpoint starting: time
  598. 2018-08-01 14:06:42.262 UTC @ 1141 LOG: restartpoint complete: wrote 63619 buffers (6.1%); 0 transaction log file(s) added, 26 removed, 8 recycled; write=952.091 s, sync=6.713 s, total=959
  599. .691 s; sync files=900, longest=0.866 s, average=0.007 s; distance=427438 kB, estimate=744185 kB
  600. 2018-08-01 14:06:42.262 UTC @ 1141 LOG: recovery restart point at 2167/B0446AD8
  601. 2018-08-01 14:06:42.262 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 14:06:42.227929+00
  602. 2018-08-01 14:21:28.752 UTC @ 1141 LOG: restartpoint starting: time
  603. 2018-08-01 14:39:48.793 UTC @ 1141 LOG: restartpoint complete: wrote 84544 buffers (8.1%); 0 transaction log file(s) added, 36 removed, 0 recycled; write=1079.114 s, sync=20.682 s, total=1
  604. 100.040 s; sync files=930, longest=9.563 s, average=0.022 s; distance=589549 kB, estimate=728722 kB
  605. 2018-08-01 14:39:48.793 UTC @ 1141 LOG: recovery restart point at 2167/D4401FF8
  606. 2018-08-01 14:39:48.793 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 14:39:47.872788+00
  607. 2018-08-01 14:50:11.341 UTC @ 1141 LOG: restartpoint starting: time
  608. 2018-08-01 15:08:27.366 UTC @ 1141 LOG: restartpoint complete: wrote 88099 buffers (8.4%); 0 transaction log file(s) added, 26 removed, 4 recycled; write=1079.734 s, sync=15.700 s, total=1
  609. 096.025 s; sync files=845, longest=3.704 s, average=0.018 s; distance=587396 kB, estimate=714589 kB
  610. 2018-08-01 15:08:27.367 UTC @ 1141 LOG: recovery restart point at 2167/F81A30B8
  611. 2018-08-01 15:08:27.367 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 15:08:27.18314+00
  612. 2018-08-01 15:21:19.219 UTC @ 1141 LOG: restartpoint starting: time
  613. 2018-08-01 15:39:32.389 UTC @ 1141 LOG: restartpoint complete: wrote 70753 buffers (6.7%); 0 transaction log file(s) added, 16 removed, 12 recycled; write=1078.648 s, sync=12.302 s, total=
  614. 1093.170 s; sync files=851, longest=2.223 s, average=0.014 s; distance=459543 kB, estimate=689084 kB
  615. 2018-08-01 15:39:32.389 UTC @ 1141 LOG: recovery restart point at 2168/14268F48
  616. 2018-08-01 15:39:32.389 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 15:39:32.326513+00
  617. 2018-08-01 15:50:00.942 UTC @ 1141 LOG: restartpoint starting: time
  618. 2018-08-01 16:04:07.770 UTC @ 1141 LOG: restartpoint complete: wrote 66439 buffers (6.3%); 1 transaction log file(s) added, 42 removed, 0 recycled; write=822.864 s, sync=22.712 s, total=84
  619. 6.828 s; sync files=849, longest=7.321 s, average=0.026 s; distance=459677 kB, estimate=666144 kB
  620. 2018-08-01 16:04:07.770 UTC @ 1141 LOG: recovery restart point at 2168/30350738
  621. 2018-08-01 16:04:07.770 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 16:02:46.178144+00
  622. 2018-08-01 16:20:10.923 UTC @ 1141 LOG: restartpoint starting: time
  623. 2018-08-01 16:38:26.530 UTC @ 1141 LOG: restartpoint complete: wrote 164142 buffers (15.7%); 0 transaction log file(s) added, 48 removed, 0 recycled; write=1078.603 s, sync=16.224 s, total
  624. =1095.606 s; sync files=904, longest=2.013 s, average=0.017 s; distance=1007192 kB, estimate=1007192 kB
  625. 2018-08-01 16:38:26.530 UTC @ 1141 LOG: recovery restart point at 2168/6DAE6860
  626. 2018-08-01 16:38:26.530 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 16:38:26.46389+00
  627. 2018-08-01 16:48:49.804 UTC @ 1141 LOG: restartpoint starting: time
  628. 2018-08-01 17:06:56.169 UTC @ 1141 LOG: restartpoint complete: wrote 64594 buffers (6.2%); 0 transaction log file(s) added, 11 removed, 14 recycled; write=1079.079 s, sync=6.874 s, total=1
  629. 086.364 s; sync files=826, longest=1.007 s, average=0.008 s; distance=470737 kB, estimate=953546 kB
  630. 2018-08-01 17:06:56.169 UTC @ 1141 LOG: recovery restart point at 2168/8A69AD00
  631. 2018-08-01 17:06:56.169 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 17:06:56.075642+00
  632. 2018-08-01 17:08:28.732 UTC postgres@[unknown] 9681 10.0.128.179(59042) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  633. 2018-08-01 17:08:29.062 UTC postgres@[unknown] 9683 10.0.128.179(59048) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  634. 2018-08-01 17:08:34.075 UTC postgres@[unknown] 9684 10.0.128.179(59054) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  635. 2018-08-01 17:08:39.068 UTC postgres@[unknown] 9696 10.0.128.179(59060) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  636. 2018-08-01 17:08:44.087 UTC postgres@[unknown] 9697 10.0.128.179(59066) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  637. 2018-08-01 17:08:49.075 UTC postgres@[unknown] 9698 10.0.128.179(59072) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  638. 2018-08-01 17:08:54.082 UTC postgres@[unknown] 9699 10.0.128.179(59078) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  639. 2018-08-01 17:08:59.090 UTC postgres@[unknown] 9700 10.0.128.179(59084) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  640. 2018-08-01 17:09:04.094 UTC postgres@[unknown] 9701 10.0.128.179(59090) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  641. 2018-08-01 17:09:09.099 UTC postgres@[unknown] 9702 10.0.128.179(59096) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  642. 2018-08-01 17:09:14.104 UTC postgres@[unknown] 9703 10.0.128.179(59102) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  643. 2018-08-01 17:09:19.109 UTC postgres@[unknown] 9704 10.0.128.179(59108) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  644. 2018-08-01 17:09:24.127 UTC postgres@[unknown] 9705 10.0.128.179(59114) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  645. 2018-08-01 17:09:29.122 UTC postgres@[unknown] 9706 10.0.128.179(59120) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  646. 2018-08-01 17:09:34.128 UTC postgres@[unknown] 9707 10.0.128.179(59126) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  647. 2018-08-01 17:09:39.147 UTC postgres@[unknown] 9719 10.0.128.179(59132) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  648. 2018-08-01 17:09:44.138 UTC postgres@[unknown] 9720 10.0.128.179(59138) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  649. 2018-08-01 17:09:49.139 UTC postgres@[unknown] 9721 10.0.128.179(59144) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  650. 2018-08-01 17:09:54.156 UTC postgres@[unknown] 9722 10.0.128.179(59150) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  651. 2018-08-01 17:09:59.148 UTC postgres@[unknown] 9723 10.0.128.179(59156) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  652. 2018-08-01 17:10:04.156 UTC postgres@[unknown] 9731 10.0.128.179(59162) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  653. 2018-08-01 17:10:09.161 UTC postgres@[unknown] 9732 10.0.128.179(59168) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  654. 2018-08-01 17:10:14.164 UTC postgres@[unknown] 9733 10.0.128.179(59174) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  655. 2018-08-01 17:10:19.170 UTC postgres@[unknown] 9734 10.0.128.179(59180) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  656. 2018-08-01 17:10:24.174 UTC postgres@[unknown] 9735 10.0.128.179(59186) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  657. 2018-08-01 17:10:29.179 UTC postgres@[unknown] 9736 10.0.128.179(59192) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  658. 2018-08-01 17:10:34.184 UTC postgres@[unknown] 9738 10.0.128.179(59198) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  659. 2018-08-01 17:10:39.193 UTC postgres@[unknown] 9750 10.0.128.179(59204) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  660. 2018-08-01 17:10:44.207 UTC postgres@[unknown] 9751 10.0.128.179(59210) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  661. 2018-08-01 17:10:49.201 UTC postgres@[unknown] 9752 10.0.128.179(59216) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  662. 2018-08-01 17:10:54.203 UTC postgres@[unknown] 9753 10.0.128.179(59222) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  663. 2018-08-01 17:10:59.214 UTC postgres@[unknown] 9754 10.0.128.179(59228) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  664. 2018-08-01 17:11:04.221 UTC postgres@[unknown] 9755 10.0.128.179(59234) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  665. 2018-08-01 17:11:09.220 UTC postgres@[unknown] 9756 10.0.128.179(59240) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  666. 2018-08-01 17:11:14.229 UTC postgres@[unknown] 9757 10.0.128.179(59246) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  667. 2018-08-01 17:11:19.233 UTC postgres@[unknown] 9758 10.0.128.179(59252) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  668. 2018-08-01 17:11:24.238 UTC postgres@[unknown] 9759 10.0.128.179(59258) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  669. 2018-08-01 17:11:29.242 UTC postgres@[unknown] 9760 10.0.128.179(59264) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  670. 2018-08-01 17:11:34.259 UTC postgres@[unknown] 9761 10.0.128.179(59270) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  671. 2018-08-01 17:11:39.265 UTC postgres@[unknown] 9773 10.0.128.179(59276) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  672. 2018-08-01 17:11:44.266 UTC postgres@[unknown] 9774 10.0.128.179(59282) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  673. 2018-08-01 17:11:49.265 UTC postgres@[unknown] 9775 10.0.128.179(59288) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  674. 2018-08-01 17:11:54.272 UTC postgres@[unknown] 9776 10.0.128.179(59294) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  675. 2018-08-01 17:11:59.276 UTC postgres@[unknown] 9777 10.0.128.179(59300) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  676. 2018-08-01 17:12:04.281 UTC postgres@[unknown] 9778 10.0.128.179(59306) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  677. 2018-08-01 17:12:09.290 UTC postgres@[unknown] 9782 10.0.128.179(59312) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  678. 2018-08-01 17:12:14.300 UTC postgres@[unknown] 9803 10.0.128.179(59318) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  679. 2018-08-01 17:12:19.301 UTC postgres@[unknown] 9837 10.0.128.179(59324) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  680. 2018-08-01 17:12:24.316 UTC postgres@[unknown] 9839 10.0.128.179(59330) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  681. 2018-08-01 17:12:29.314 UTC postgres@[unknown] 9840 10.0.128.179(59336) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  682. 2018-08-01 17:12:34.313 UTC postgres@[unknown] 9841 10.0.128.179(59342) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  683. 2018-08-01 17:12:39.317 UTC postgres@[unknown] 9853 10.0.128.179(59348) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  684. 2018-08-01 17:12:44.322 UTC postgres@[unknown] 9854 10.0.128.179(59354) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  685. 2018-08-01 17:12:49.327 UTC postgres@[unknown] 9855 10.0.128.179(59360) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  686. 2018-08-01 17:12:54.336 UTC postgres@[unknown] 9856 10.0.128.179(59366) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  687. 2018-08-01 17:12:59.338 UTC postgres@[unknown] 9857 10.0.128.179(59372) FATAL: no pg_hba.conf entry for replication connection from host "10.0.128.179", user "postgres", SSL off
  688. 2018-08-01 17:13:03.275 UTC @ 1035 LOG: received SIGHUP, reloading configuration files
  689. 2018-08-01 17:20:24.797 UTC @ 1141 LOG: restartpoint starting: time
  690. 2018-08-01 17:38:34.307 UTC @ 1141 LOG: restartpoint complete: wrote 66549 buffers (6.3%); 0 transaction log file(s) added, 15 removed, 14 recycled; write=1078.353 s, sync=8.904 s, total=1
  691. 089.510 s; sync files=883, longest=1.666 s, average=0.010 s; distance=432805 kB, estimate=901472 kB
  692. 2018-08-01 17:38:34.307 UTC @ 1141 LOG: recovery restart point at 2168/A4D441B8
  693. 2018-08-01 17:38:34.307 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 17:38:34.189508+00
  694. 2018-08-01 17:49:18.113 UTC @ 1141 LOG: restartpoint starting: time
  695. 2018-08-01 18:01:52.195 UTC @ 16518 FATAL: terminating walreceiver due to timeout
  696. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/00000002.history: No such file or directory
  697. 2018-08-01 18:02:56.141 UTC @ 1076 LOG: restored log file "0000000100002168000000F9" from archive
  698. 2018-08-01 18:02:58.254 UTC @ 1076 LOG: restored log file "0000000100002168000000FA" from archive
  699. 2018-08-01 18:02:59.903 UTC @ 1076 LOG: restored log file "0000000100002168000000FB" from archive
  700. 2018-08-01 18:03:01.990 UTC @ 1076 LOG: restored log file "0000000100002168000000FC" from archive
  701. 2018-08-01 18:03:52.004 UTC @ 1076 LOG: restored log file "0000000100002168000000FD" from archive
  702. 2018-08-01 18:03:58.326 UTC @ 1076 LOG: restored log file "0000000100002168000000FE" from archive
  703. 2018-08-01 18:04:47.859 UTC @ 1076 LOG: restored log file "0000000100002168000000FF" from archive
  704. 2018-08-01 18:04:49.599 UTC @ 1076 LOG: restored log file "000000010000216900000000" from archive
  705. scp: /opt/Postgres/DATA-ARCHIVE/archivelogs/000000010000216900000001: No such file or directory
  706. 2018-08-01 18:04:51.376 UTC @ 12860 LOG: started streaming WAL from primary at 2169/0 on timeline 1
  707. 2018-08-01 18:08:00.351 UTC @ 1141 LOG: restartpoint complete: wrote 171868 buffers (16.4%); 0 transaction log file(s) added, 72 removed, 0 recycled; write=1075.114 s, sync=41.791 s, total
  708. =1122.237 s; sync files=902, longest=19.432 s, average=0.046 s; distance=1176265 kB, estimate=1176265 kB
  709. 2018-08-01 18:08:00.351 UTC @ 1141 LOG: recovery restart point at 2168/EC9F69B0
  710. 2018-08-01 18:08:00.351 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 18:07:59.190748+00
  711. 2018-08-01 18:20:09.627 UTC @ 1141 LOG: restartpoint starting: time
  712. 2018-08-01 18:38:20.417 UTC @ 1141 LOG: restartpoint complete: wrote 70631 buffers (6.7%); 0 transaction log file(s) added, 20 removed, 10 recycled; write=1078.863 s, sync=11.177 s, total=
  713. 1090.790 s; sync files=884, longest=1.353 s, average=0.012 s; distance=453193 kB, estimate=1103958 kB
  714. 2018-08-01 18:38:20.417 UTC @ 1141 LOG: recovery restart point at 2169/8489168
  715. 2018-08-01 18:38:20.418 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 18:38:20.362251+00
  716. 2018-08-01 18:49:43.318 UTC @ 1141 LOG: restartpoint starting: time
  717. 2018-08-01 19:07:53.374 UTC @ 1141 LOG: restartpoint complete: wrote 76061 buffers (7.3%); 0 transaction log file(s) added, 16 removed, 11 recycled; write=1084.169 s, sync=5.110 s, total=1
  718. 090.056 s; sync files=884, longest=0.945 s, average=0.005 s; distance=523877 kB, estimate=1045950 kB
  719. 2018-08-01 19:07:53.374 UTC @ 1141 LOG: recovery restart point at 2169/284226F0
  720. 2018-08-01 19:07:53.374 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 19:07:53.316791+00
  721. 2018-08-01 19:20:06.882 UTC @ 1141 LOG: restartpoint starting: time
  722. 2018-08-01 19:38:14.913 UTC @ 1141 LOG: restartpoint complete: wrote 68000 buffers (6.5%); 0 transaction log file(s) added, 15 removed, 14 recycled; write=1078.307 s, sync=7.816 s, total=1
  723. 088.030 s; sync files=932, longest=1.998 s, average=0.008 s; distance=450524 kB, estimate=986408 kB
  724. 2018-08-01 19:38:14.913 UTC @ 1141 LOG: recovery restart point at 2169/43C199D8
  725. 2018-08-01 19:38:14.913 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 19:38:14.862427+00
  726. 2018-08-01 19:50:20.354 UTC @ 1141 LOG: restartpoint starting: xlog
  727. 2018-08-01 20:08:25.262 UTC @ 1141 LOG: restartpoint complete: wrote 65693 buffers (6.3%); 0 transaction log file(s) added, 11 removed, 15 recycled; write=1079.536 s, sync=4.672 s, total=1
  728. 084.907 s; sync files=891, longest=1.023 s, average=0.005 s; distance=439072 kB, estimate=931674 kB
  729. 2018-08-01 20:08:25.262 UTC @ 1141 LOG: recovery restart point at 2169/5E8E19F8
  730. 2018-08-01 20:08:25.262 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 20:08:25.209049+00
  731. 2018-08-01 20:19:50.284 UTC @ 1141 LOG: restartpoint starting: time
  732. 2018-08-01 20:38:02.666 UTC @ 1141 LOG: restartpoint complete: wrote 59592 buffers (5.7%); 0 transaction log file(s) added, 4 removed, 19 recycled; write=1079.280 s, sync=8.668 s, total=10
  733. 92.381 s; sync files=882, longest=1.381 s, average=0.009 s; distance=422964 kB, estimate=880803 kB
  734. 2018-08-01 20:38:02.666 UTC @ 1141 LOG: recovery restart point at 2169/785EEA00
  735. 2018-08-01 20:38:02.666 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 20:38:02.236889+00
  736. 2018-08-01 20:50:45.188 UTC @ 1141 LOG: restartpoint starting: time
  737. 2018-08-01 21:08:56.622 UTC @ 1141 LOG: restartpoint complete: wrote 55534 buffers (5.3%); 0 transaction log file(s) added, 0 removed, 21 recycled; write=1079.109 s, sync=10.971 s, total=1
  738. 091.433 s; sync files=819, longest=1.475 s, average=0.013 s; distance=376376 kB, estimate=830360 kB
  739. 2018-08-01 21:08:56.622 UTC @ 1141 LOG: recovery restart point at 2169/8F57CDC0
  740. 2018-08-01 21:08:56.622 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 21:08:56.414594+00
  741. 2018-08-01 21:20:43.342 UTC @ 1141 LOG: restartpoint starting: xlog
  742. 2018-08-01 21:38:52.097 UTC @ 1141 LOG: restartpoint complete: wrote 47501 buffers (4.5%); 0 transaction log file(s) added, 0 removed, 18 recycled; write=1079.316 s, sync=8.537 s, total=10
  743. 88.755 s; sync files=825, longest=1.140 s, average=0.010 s; distance=324699 kB, estimate=779794 kB
  744. 2018-08-01 21:38:52.098 UTC @ 1141 LOG: recovery restart point at 2169/A3293AC0
  745. 2018-08-01 21:38:52.098 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 21:38:51.971451+00
  746. 2018-08-01 21:50:43.644 UTC @ 1141 LOG: restartpoint starting: time
  747. 2018-08-01 22:08:51.303 UTC @ 1141 LOG: restartpoint complete: wrote 42397 buffers (4.0%); 0 transaction log file(s) added, 0 removed, 19 recycled; write=1078.504 s, sync=7.169 s, total=10
  748. 87.659 s; sync files=728, longest=1.749 s, average=0.009 s; distance=294642 kB, estimate=731279 kB
  749. 2018-08-01 22:08:51.303 UTC @ 1141 LOG: recovery restart point at 2169/B52502F0
  750. 2018-08-01 22:08:51.303 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 22:08:51.118153+00
  751. 2018-08-01 22:20:58.840 UTC @ 1141 LOG: restartpoint starting: time
  752. 2018-08-01 22:39:01.617 UTC @ 1141 LOG: restartpoint complete: wrote 37300 buffers (3.6%); 0 transaction log file(s) added, 0 removed, 11 recycled; write=1078.678 s, sync=3.404 s, total=10
  753. 82.777 s; sync files=748, longest=0.838 s, average=0.004 s; distance=285111 kB, estimate=686662 kB
  754. 2018-08-01 22:39:01.617 UTC @ 1141 LOG: recovery restart point at 2169/C68BDFE0
  755. 2018-08-01 22:39:01.617 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 22:39:01.401571+00
  756. 2018-08-01 22:51:44.133 UTC @ 1141 LOG: restartpoint starting: time
  757. 2018-08-01 23:02:22.398 UTC postgres@[unknown] 7521 10.0.128.142(38454) LOG: could not receive data from client: No route to host
  758. 2018-08-01 23:02:22.398 UTC postgres@[unknown] 7521 10.0.128.142(38454) LOG: unexpected EOF on standby connection
  759. 2018-08-01 23:09:46.578 UTC @ 1141 LOG: restartpoint complete: wrote 24502 buffers (2.3%); 0 transaction log file(s) added, 0 removed, 11 recycled; write=1079.787 s, sync=1.537 s, total=10
  760. 82.444 s; sync files=653, longest=0.380 s, average=0.002 s; distance=172273 kB, estimate=635223 kB
  761. 2018-08-01 23:09:46.578 UTC @ 1141 LOG: recovery restart point at 2169/D10FA588
  762. 2018-08-01 23:09:46.578 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 23:09:46.485541+00
  763. 2018-08-01 23:19:14.600 UTC @ 1141 LOG: restartpoint starting: time
  764. 2018-08-01 23:37:17.067 UTC @ 1141 LOG: restartpoint complete: wrote 24154 buffers (2.3%); 0 transaction log file(s) added, 0 removed, 9 recycled; write=1079.374 s, sync=2.188 s, total=108
  765. 2.466 s; sync files=608, longest=0.836 s, average=0.003 s; distance=180469 kB, estimate=589748 kB
  766. 2018-08-01 23:37:17.067 UTC @ 1141 LOG: recovery restart point at 2169/DC137C10
  767. 2018-08-01 23:37:17.067 UTC @ 1141 DETAIL: last completed transaction was at log time 2018-08-01 23:37:15.981382+00
  768. 2018-08-01 23:50:44.944 UTC @ 1141 LOG: restartpoint starting: time
  769. -bash-4.2$
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!