Contains of archive:

[root@kd-icedb01 pgsql]# ls -l /pgxlog/wal_archive/
total 131076
-rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:09 000000010000000000000001
-rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:11 000000010000000000000002
-rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:11 000000010000000000000003
-rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:11 000000010000000000000004
-rw-r--r--. 1 postgres postgres      291 Aug 16 00:11 000000010000000000000004.00000248.backup
-rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:12 000000010000000000000005
-rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:12 000000010000000000000006
-rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:13 000000010000000000000007
-rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:14 000000010000000000000008

Note that these were all writen before we restored from backup.


Top of log just after restoring from backup:

[root@kd-icedb01 pgsql]# less postgresql-2018-08-16_001436.log
2018-08-16 00:14:36 UTC [3511]: [1] user=,db=,app=,client= LOG:  database system was interrupted; last known up at 2018-08-16 00:11:43 UTC
2018-08-16 00:14:36 UTC [3511]: [2] user=,db=,app=,client= LOG:  creating missing WAL directory "pg_wal/archive_status"
2018-08-16 00:14:36 UTC [3511]: [3] user=,db=,app=,client= LOG:  starting point-in-time recovery to earliest consistent point
2018-08-16 00:14:36 UTC [3511]: [4] user=,db=,app=,client= LOG:  restored log file "000000010000000000000004" from archive
2018-08-16 00:14:36 UTC [3511]: [5] user=,db=,app=,client= LOG:  redo starts at 0/4000248
2018-08-16 00:14:36 UTC [3515]: [1] user=,db=,app=,client= LOG:  archive command failed with exit code 1
2018-08-16 00:14:36 UTC [3511]: [6] user=,db=,app=,client= LOG:  consistent recovery state reached at 0/41450F0
2018-08-16 00:14:36 UTC [3511]: [7] user=,db=,app=,client= LOG:  recovery stopping after reaching consistency
2018-08-16 00:14:36 UTC [3511]: [8] user=,db=,app=,client= LOG:  redo done at 0/41450F0
2018-08-16 00:14:36 UTC [3511]: [9] user=,db=,app=,client= LOG:  last completed transaction was at log time 2018-08-16 00:11:45.105103+00
2018-08-16 00:14:36 UTC [3508]: [6] user=,db=,app=,client= LOG:  database system is ready to accept read only connections
cp: cannot stat ‘/pgxlog/wal_archive/00000002.history’: No such file or directory
2018-08-16 00:14:36 UTC [3511]: [10] user=,db=,app=,client= LOG:  selected new timeline ID: 2
cp: cannot stat ‘/pgxlog/wal_archive/00000001.history’: No such file or directory
2018-08-16 00:14:36 UTC [3515]: [2] user=,db=,app=,client= LOG:  archive command failed with exit code 1
2018-08-16 00:14:36 UTC [3511]: [11] user=,db=,app=,client= LOG:  archive recovery complete
2018-08-16 00:14:36 UTC [3513]: [1] user=,db=,app=,client= LOG:  checkpoint starting: end-of-recovery immediate wait
2018-08-16 00:14:36 UTC [3513]: [2] user=,db=,app=,client= LOG:  checkpoint complete: wrote 115 buffers (0.7%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.007 s, sync=0.001 s, total=0.018 s; sync files=14, longest=0.000 s, average=0.000 s; distance=1299 kB, estimate=1299 kB
2018-08-16 00:14:36 UTC [3508]: [7] user=,db=,app=,client= LOG:  database system is ready to accept connections
2018-08-16 00:14:37 UTC [3515]: [3] user=,db=,app=,client= LOG:  archive command failed with exit code 1
2018-08-16 00:14:37 UTC [3515]: [4] user=,db=,app=,client= WARNING:  archiving write-ahead log file "000000010000000000000004" failed too many times, will try again later
2018-08-16 00:14:37 UTC [3515]: [5] user=,db=,app=,client= LOG:  archive command failed with exit code 1
2018-08-16 00:14:38 UTC [3515]: [6] user=,db=,app=,client= LOG:  archive command failed with exit code 1
2018-08-16 00:14:39 UTC [3515]: [7] user=,db=,app=,client= LOG:  archive command failed with exit code 1
2018-08-16 00:14:39 UTC [3515]: [8] user=,db=,app=,client= WARNING:  archiving write-ahead log file "000000010000000000000004" failed too many times, will try again later
2018-08-16 00:14:40 UTC [3533]: [1] user=[unknown],db=[unknown],app=[unknown],client=localhost LOG:  connection received: host=localhost port=45558