daily pastebin goal
36%
SHARE
TWEET

Untitled

a guest Aug 15th, 2018 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Contains of archive:
  2.  
  3. [root@kd-icedb01 pgsql]# ls -l /pgxlog/wal_archive/
  4. total 131076
  5. -rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:09 000000010000000000000001
  6. -rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:11 000000010000000000000002
  7. -rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:11 000000010000000000000003
  8. -rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:11 000000010000000000000004
  9. -rw-r--r--. 1 postgres postgres      291 Aug 16 00:11 000000010000000000000004.00000248.backup
  10. -rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:12 000000010000000000000005
  11. -rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:12 000000010000000000000006
  12. -rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:13 000000010000000000000007
  13. -rw-r--r--. 1 postgres postgres 16777216 Aug 16 00:14 000000010000000000000008
  14.  
  15. Note that these were all writen before we restored from backup.
  16.  
  17.  
  18. Top of log just after restoring from backup:
  19.  
  20. [root@kd-icedb01 pgsql]# less postgresql-2018-08-16_001436.log
  21. 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
  22. 2018-08-16 00:14:36 UTC [3511]: [2] user=,db=,app=,client= LOG:  creating missing WAL directory "pg_wal/archive_status"
  23. 2018-08-16 00:14:36 UTC [3511]: [3] user=,db=,app=,client= LOG:  starting point-in-time recovery to earliest consistent point
  24. 2018-08-16 00:14:36 UTC [3511]: [4] user=,db=,app=,client= LOG:  restored log file "000000010000000000000004" from archive
  25. 2018-08-16 00:14:36 UTC [3511]: [5] user=,db=,app=,client= LOG:  redo starts at 0/4000248
  26. 2018-08-16 00:14:36 UTC [3515]: [1] user=,db=,app=,client= LOG:  archive command failed with exit code 1
  27. 2018-08-16 00:14:36 UTC [3511]: [6] user=,db=,app=,client= LOG:  consistent recovery state reached at 0/41450F0
  28. 2018-08-16 00:14:36 UTC [3511]: [7] user=,db=,app=,client= LOG:  recovery stopping after reaching consistency
  29. 2018-08-16 00:14:36 UTC [3511]: [8] user=,db=,app=,client= LOG:  redo done at 0/41450F0
  30. 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
  31. 2018-08-16 00:14:36 UTC [3508]: [6] user=,db=,app=,client= LOG:  database system is ready to accept read only connections
  32. cp: cannot stat ‘/pgxlog/wal_archive/00000002.history’: No such file or directory
  33. 2018-08-16 00:14:36 UTC [3511]: [10] user=,db=,app=,client= LOG:  selected new timeline ID: 2
  34. cp: cannot stat ‘/pgxlog/wal_archive/00000001.history’: No such file or directory
  35. 2018-08-16 00:14:36 UTC [3515]: [2] user=,db=,app=,client= LOG:  archive command failed with exit code 1
  36. 2018-08-16 00:14:36 UTC [3511]: [11] user=,db=,app=,client= LOG:  archive recovery complete
  37. 2018-08-16 00:14:36 UTC [3513]: [1] user=,db=,app=,client= LOG:  checkpoint starting: end-of-recovery immediate wait
  38. 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
  39. 2018-08-16 00:14:36 UTC [3508]: [7] user=,db=,app=,client= LOG:  database system is ready to accept connections
  40. 2018-08-16 00:14:37 UTC [3515]: [3] user=,db=,app=,client= LOG:  archive command failed with exit code 1
  41. 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
  42. 2018-08-16 00:14:37 UTC [3515]: [5] user=,db=,app=,client= LOG:  archive command failed with exit code 1
  43. 2018-08-16 00:14:38 UTC [3515]: [6] user=,db=,app=,client= LOG:  archive command failed with exit code 1
  44. 2018-08-16 00:14:39 UTC [3515]: [7] user=,db=,app=,client= LOG:  archive command failed with exit code 1
  45. 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
  46. 2018-08-16 00:14:40 UTC [3533]: [1] user=[unknown],db=[unknown],app=[unknown],client=localhost LOG:  connection received: host=localhost port=45558
RAW Paste Data
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
 
Top