pgbackrest.git / summary / log / commit / refs

commit    9f19e13095628bf1b654db08ea3eec883c2cc5cd
Author:   David Steele <david@pgmasters.net>
Date:     Tue Aug 09 14:06:21 2016 +0000

    v1.05: Bug Fix for Tablespace Link Checking
    
    Bug Fixes:
    
    * Fixed an issue where tablespace paths that had $PGDATA as a substring would be identified as a subdirectories of $PGDATA even when they were not. Also hardened relative path checking a bit. (Reported by Chris Fort.)


README.md | 2 +- doc/resource/exe.cache | 399 +++++++++++++++++++++++----------------------- doc/xml/release.xml | 2 +- lib/pgBackRest/Version.pm | 2 +- 4 files changed, 202 insertions(+), 203 deletions(-) diff --git a/README.md b/README.md index 17a94a31b..c26e21453 100644 --- a/README.md +++ b/README.md @@ -6,7 +6,7 @@ pgBackRest aims to be a simple, reliable backup and restore system that can seam Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses a custom protocol for communicating with remote systems. Removing reliance on tar and rsync allows for better solutions to database-specific backup challenges. The custom remote protocol allows for more flexibility and limits the types of connections that are required to perform a backup which increases security. -pgBackRest [v1.04](https://github.com/pgbackrest/pgbackrest/releases/tag/release/1.04) is the current stable release. Release notes are on the [Releases](http://www.pgbackrest.org/release.html) page. +pgBackRest [v1.05](https://github.com/pgbackrest/pgbackrest/releases/tag/release/1.05) is the current stable release. Release notes are on the [Releases](http://www.pgbackrest.org/release.html) page. ## Features diff --git a/doc/resource/exe.cache b/doc/resource/exe.cache index b4d43b158..df6d1b83a 100644 --- a/doc/resource/exe.cache +++ b/doc/resource/exe.cache @@ -12,7 +12,7 @@ }, "type" : "host", "value" : { - "ip" : "172.17.0.2" + "ip" : "172.17.0.4" } }, { @@ -90,7 +90,7 @@ { "key" : { "cmd" : [ - "sudo cp -r ~/pgbackrest-release-1.04/lib/pgBackRest \\", + "sudo cp -r ~/pgbackrest-release-1.05/lib/pgBackRest \\", " /usr/share/perl5" ], "host" : "db-master", @@ -121,7 +121,7 @@ { "key" : { "cmd" : [ - "sudo cp ~/pgbackrest-release-1.04/bin/pgbackrest /usr/bin/pgbackrest" + "sudo cp ~/pgbackrest-release-1.05/bin/pgbackrest /usr/bin/pgbackrest" ], "host" : "db-master", "output" : false @@ -169,7 +169,7 @@ "type" : "exe", "value" : { "output" : [ - "pgBackRest 1.04 - General help", + "pgBackRest 1.05 - General help", "", "Usage:", " pgbackrest [options] [command]", @@ -406,7 +406,7 @@ " INFO: check start: --db-path=/var/lib/pgsql/9.4/data --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo", " INFO: switch xlog 000000010000000000000001", " ERROR: [148]: /var/lib/pgbackrest/backup/demo does not exist", - " INFO: WAL segment 000000010000000000000001 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000100000000/000000010000000000000001-a7222d9b4f857cba76a925bf7c740174dae416e5.gz'", + " INFO: WAL segment 000000010000000000000001 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000100000000/000000010000000000000001-66674034f2e06ce9dbafaaecfabb84d58cda9de8.gz'", " INFO: check stop" ] } @@ -432,11 +432,11 @@ "output" : [ " INFO: backup start: --db-path=/var/lib/pgsql/9.4/data --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo", " WARN: no prior backup exists, incr backup has been changed to full", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:03:58\": backup begins after the next regular checkpoint completes", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:54:05\": backup begins after the next regular checkpoint completes", " INFO: archive start: 0/2000028", " [filtered 763 lines of output]", " INFO: backup file /var/lib/pgsql/9.4/data/base/1/11886 (0B, 100%)", - " INFO: backup file /var/lib/pgsql/9.4/data/global/pg_control (8KB) checksum f65c8f990f0c4f2a896b3d78b35241eb8233fe2f", + " INFO: backup file /var/lib/pgsql/9.4/data/global/pg_control (8KB) checksum 918023283eae43f780e12d4abce157f1ba6e5f2f", " INFO: full backup size = 19.3MB", " INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive", " INFO: archive stop: 0/20000F0", @@ -455,7 +455,7 @@ "type" : "exe", "value" : { "output" : [ - "20160730-130403F" + "20160809-135410F" ] } }, @@ -478,10 +478,10 @@ "type" : "exe", "value" : { "output" : [ - " [filtered 5 lines of output]", - " INFO: backup file /var/lib/pgsql/9.4/data/backup_label (236B, 100%) checksum 20c888a374878fae8638982d257627729c8ca82e", - " INFO: backup file /var/lib/pgsql/9.4/data/global/pg_control (8KB) checksum 24ce78d71e1356bb1e498c9f99c7cdfe1e82d4bd", - " INFO: diff backup size = 8.8KB", + " [filtered 4 lines of output]", + " INFO: backup file /var/lib/pgsql/9.4/data/backup_label (236B, 100%) checksum b1f9185fb453e4d5bb36d71451c9cbbaed0e2ac6", + " INFO: backup file /var/lib/pgsql/9.4/data/global/pg_control (8KB) checksum 0938b14f4b05986a769b2b0d27c2e845813f7fa3", + " INFO: diff backup size = 8.2KB", " INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive", " INFO: archive stop: 0/30000F0", " [filtered 4 lines of output]" @@ -509,16 +509,16 @@ "stanza: demo", " status: ok", "", - " full backup: 20160730-130403F", - " start / stop timestamp: 2016-07-30 13:03:58 / 2016-07-30 13:04:03", + " full backup: 20160809-135410F", + " start / stop timestamp: 2016-08-09 13:54:05 / 2016-08-09 13:54:10", " database size: 19.3MB, backup size: 19.3MB", " repository size: 2.2MB, repository backup size: 2.2MB", "", - " diff backup: 20160730-130403F_20160730-130406D", - " start / stop timestamp: 2016-07-30 13:04:03 / 2016-07-30 13:04:06", - " database size: 19.3MB, backup size: 8.8KB", - " repository size: 2.2MB, repository backup size: 669B", - " backup reference list: 20160730-130403F" + " diff backup: 20160809-135410F_20160809-135413D", + " start / stop timestamp: 2016-08-09 13:54:10 / 2016-08-09 13:54:13", + " database size: 19.3MB, backup size: 8.2KB", + " repository size: 2.2MB, repository backup size: 342B", + " backup reference list: 20160809-135410F" ] } }, @@ -657,10 +657,10 @@ "value" : { "output" : [ " INFO: backup start: --db-path=/var/lib/pgsql/9.4/data --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo --type=incr", - " INFO: last backup label = 20160730-130403F_20160730-130406D, version = 1.04", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:04:17\": backup begins after the next regular checkpoint completes", + " INFO: last backup label = 20160809-135410F_20160809-135413D, version = 1.05", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:54:24\": backup begins after the next regular checkpoint completes", " INFO: archive start: 0/5000028", - " INFO: backup file /var/lib/pgsql/9.4/data/base/12140/pg_internal.init (115.2KB, 71%) checksum 06acde9729d12758d20191638064c0b3ce9470c4", + " INFO: backup file /var/lib/pgsql/9.4/data/base/12140/pg_internal.init (115.2KB, 71%) checksum 86a38e5b0434f6938d697aa069799bbf0467eb65", " [filtered 16 lines of output]" ] } @@ -709,11 +709,11 @@ "value" : { "output" : [ " INFO: backup start: --db-path=/var/lib/pgsql/9.4/data --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo --start-fast --type=incr", - " INFO: last backup label = 20160730-130403F_20160730-130420I, version = 1.04", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:04:21\": backup begins after the requested immediate checkpoint completes", + " INFO: last backup label = 20160809-135410F_20160809-135427I, version = 1.05", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:54:28\": backup begins after the requested immediate checkpoint completes", " INFO: archive start: 0/6000028", - " INFO: backup file /var/lib/pgsql/9.4/data/pg_log/postgresql.log (1.3KB, 85%) checksum 7d42cf629f4354eaa078d7fc02650c032315a1a7", - " [filtered 9 lines of output]" + " INFO: backup file /var/lib/pgsql/9.4/data/backup_label (236B, 100%) checksum d44da68b85a519cc53de29ddeffb08468eb3b78e", + " [filtered 8 lines of output]" ] } }, @@ -748,7 +748,7 @@ "value" : { "output" : [ " [filtered 2 lines of output]", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:04:24\": backup begins after the requested immediate checkpoint completes", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:54:31\": backup begins after the requested immediate checkpoint completes", " INFO: archive start: 0/7000028", " ERROR: [122]: unable to create /var/lib/pgbackrest/temp/demo.tmp: Permission denied", " INFO: backup stop" @@ -786,11 +786,11 @@ "value" : { "output" : [ " INFO: backup start: --db-path=/var/lib/pgsql/9.4/data --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo --start-fast --type=incr", - " INFO: last backup label = 20160730-130403F_20160730-130424I, version = 1.04", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:04:26\": backup begins after the requested immediate checkpoint completes", + " INFO: last backup label = 20160809-135410F_20160809-135431I, version = 1.05", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:54:33\": backup begins after the requested immediate checkpoint completes", " ERROR: [132]: ERROR: a backup is already in progress", " HINT: Run pg_stop_backup() and try again.:", - " select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS.US TZ'), lsn::text from pg_start_backup('pgBackRest backup started at 2016-07-30 13:04:26', true) as lsn" + " select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS.US TZ'), lsn::text from pg_start_backup('pgBackRest backup started at 2016-08-09 13:54:33', true) as lsn" ] } }, @@ -839,12 +839,12 @@ "value" : { "output" : [ " INFO: backup start: --db-path=/var/lib/pgsql/9.4/data --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo --start-fast --stop-auto --type=incr", - " INFO: last backup label = 20160730-130403F_20160730-130424I, version = 1.04", + " INFO: last backup label = 20160809-135410F_20160809-135431I, version = 1.05", " WARN: the cluster is already in backup mode but no backup process is running. pg_stop_backup() will be called so a new backup can be started.", " INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:04:27\": backup begins after the requested immediate checkpoint completes", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:54:34\": backup begins after the requested immediate checkpoint completes", " INFO: archive start: 0/9000028", - " INFO: backup file /var/lib/pgsql/9.4/data/pg_log/postgresql.log (1.8KB, 88%) checksum 23783ddadc157138fb3727d692af91cc7e097aad", + " INFO: backup file /var/lib/pgsql/9.4/data/pg_log/postgresql.log (1.2KB, 84%) checksum d822378190f1c4548c6f2353fee1704cb37abcfb", " [filtered 9 lines of output]" ] } @@ -885,7 +885,7 @@ "filter" : true, "filter-context" : 2, "list" : [ - "archive retention on backup 20160730-130403F|remove archive" + "archive retention on backup 20160809-135410F|remove archive" ] }, "host" : "db-master", @@ -897,7 +897,7 @@ " [filtered 772 lines of output]", " INFO: backup stop", " INFO: expire start: --log-level-console=detail --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo", - "DETAIL: archive retention on backup 20160730-130403F, start = 000000010000000000000002", + "DETAIL: archive retention on backup 20160809-135410F, start = 000000010000000000000002", "DETAIL: remove archive: start = 000000010000000000000001, stop = 000000010000000000000001", " INFO: expire stop" ] @@ -914,7 +914,7 @@ "type" : "exe", "value" : { "output" : [ - "20160730-130437F" + "20160809-135444F" ] } }, @@ -928,7 +928,7 @@ "filter" : true, "filter-context" : 2, "list" : [ - "expire full backup set\\: 20160730-130403F|archive retention on backup 20160730-130437F|remove archive" + "expire full backup set\\: 20160809-135410F|archive retention on backup 20160809-135444F|remove archive" ] }, "host" : "db-master", @@ -940,9 +940,9 @@ " [filtered 772 lines of output]", " INFO: backup stop", " INFO: expire start: --log-level-console=info --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo", - " INFO: expire full backup set: 20160730-130403F, 20160730-130403F_20160730-130406D, 20160730-130403F_20160730-130420I, 20160730-130403F_20160730-130424I, 20160730-130403F_20160730-130432I", - " INFO: remove expired backup 20160730-130403F_20160730-130432I", - " INFO: remove expired backup 20160730-130403F_20160730-130424I", + " INFO: expire full backup set: 20160809-135410F, 20160809-135410F_20160809-135413D, 20160809-135410F_20160809-135427I, 20160809-135410F_20160809-135431I, 20160809-135410F_20160809-135438I", + " INFO: remove expired backup 20160809-135410F_20160809-135438I", + " INFO: remove expired backup 20160809-135410F_20160809-135431I", " [filtered 3 lines of output]" ] } @@ -995,7 +995,7 @@ "type" : "exe", "value" : { "output" : [ - "20160730-130442F_20160730-130446D" + "20160809-135449F_20160809-135453D" ] } }, @@ -1019,7 +1019,7 @@ "filter" : true, "filter-context" : 2, "list" : [ - "expire diff backup set: 20160730-130442F_20160730-130446D" + "expire diff backup set: 20160809-135449F_20160809-135453D" ] }, "host" : "db-master", @@ -1028,12 +1028,12 @@ "type" : "exe", "value" : { "output" : [ - " [filtered 11 lines of output]", + " [filtered 10 lines of output]", " INFO: backup stop", " INFO: expire start: --log-level-console=info --repo-path=/var/lib/pgbackrest --retention-diff=1 --retention-full=2 --stanza=demo", - " INFO: expire diff backup set: 20160730-130442F_20160730-130446D, 20160730-130442F_20160730-130449I", - " INFO: remove expired backup 20160730-130442F_20160730-130449I", - " INFO: remove expired backup 20160730-130442F_20160730-130446D" + " INFO: expire diff backup set: 20160809-135449F_20160809-135453D, 20160809-135449F_20160809-135456I", + " INFO: remove expired backup 20160809-135449F_20160809-135456I", + " INFO: remove expired backup 20160809-135449F_20160809-135453D" ] } }, @@ -1070,7 +1070,7 @@ "DETAIL: restore file /var/lib/pgsql/9.4/data/base/1/11886 - exists and is zero size (0B, 100%)", " INFO: wrote /var/lib/pgsql/9.4/data/recovery.conf", " INFO: restore global/pg_control (copied last to ensure aborted restores cannot be started)", - " INFO: restore file /var/lib/pgsql/9.4/data/global/pg_control (8KB) checksum 50213adb6f305e14573df63c999b6bbc3ff697bf", + " INFO: restore file /var/lib/pgsql/9.4/data/global/pg_control (8KB) checksum 50ea2c475c115521f22c6fe665c4e68561e7b2c4", " INFO: restore stop" ] } @@ -1372,7 +1372,7 @@ "type" : "exe", "value" : { "output" : [ - "2016-07-30 13:05:14.354069+00" + "2016-08-09 13:55:21.327017+00" ] } }, @@ -1418,7 +1418,7 @@ "key" : { "cmd" : [ "sudo -u postgres pgbackrest --stanza=demo --delta \\", - " --type=time \"--target=2016-07-30 13:05:14.354069+00\" restore" + " --type=time \"--target=2016-08-09 13:55:21.327017+00\" restore" ], "host" : "db-master", "output" : false @@ -1454,7 +1454,7 @@ "value" : { "output" : [ "restore_command = '/usr/bin/pgbackrest --stanza=demo archive-get %f \"%p\"'", - "recovery_target_time = '2016-07-30 13:05:14.354069+00'" + "recovery_target_time = '2016-08-09 13:55:21.327017+00'" ] } }, @@ -1521,17 +1521,17 @@ "type" : "exe", "value" : { "output" : [ - "LOG: database system was interrupted; last known up at 2016-07-30 13:05:11 UTC", + "LOG: database system was interrupted; last known up at 2016-08-09 13:55:17 UTC", "LOG: creating missing WAL directory \"pg_xlog/archive_status\"", - "LOG: starting point-in-time recovery to 2016-07-30 13:05:14.354069+00", + "LOG: starting point-in-time recovery to 2016-08-09 13:55:21.327017+00", "LOG: restored log file \"00000004.history\" from archive", "LOG: restored log file \"000000040000000000000013\" from archive", - " [filtered 2 lines of output]", - "FATAL: the database system is starting up", + "LOG: redo starts at 0/13000028", + "LOG: consistent recovery state reached at 0/130000F0", "LOG: restored log file \"000000040000000000000014\" from archive", - "LOG: recovery stopping before commit of transaction 689, time 2016-07-30 13:05:15.010028+00", + "LOG: recovery stopping before commit of transaction 689, time 2016-08-09 13:55:21.425744+00", "LOG: redo done at 0/140157F0", - "LOG: last completed transaction was at log time 2016-07-30 13:05:14.2556+00", + "LOG: last completed transaction was at log time 2016-08-09 13:55:21.213763+00", "LOG: selected new timeline ID: 5", "LOG: restored log file \"00000004.history\" from archive", " [filtered 3 lines of output]" @@ -1577,7 +1577,7 @@ "type" : "exe", "value" : { "output" : [ - "20160730-130442F_20160730-130514D" + "20160809-135449F_20160809-135521D" ] } }, @@ -1605,7 +1605,7 @@ "key" : { "cmd" : [ "sudo -u postgres pgbackrest --stanza=demo --delta \\", - " --type=time \"--target=2016-07-30 13:05:14.354069+00\" restore" + " --type=time \"--target=2016-08-09 13:55:21.327017+00\" restore" ], "host" : "db-master", "output" : false @@ -1685,12 +1685,11 @@ "type" : "exe", "value" : { "output" : [ - "LOG: database system was interrupted; last known up at 2016-07-30 13:05:22 UTC", + "LOG: database system was interrupted; last known up at 2016-08-09 13:55:28 UTC", "LOG: creating missing WAL directory \"pg_xlog/archive_status\"", - "LOG: starting point-in-time recovery to 2016-07-30 13:05:14.354069+00", + "LOG: starting point-in-time recovery to 2016-08-09 13:55:21.327017+00", "LOG: restored log file \"00000005.history\" from archive", "LOG: restored log file \"000000050000000000000015\" from archive", - "FATAL: the database system is starting up", "LOG: redo starts at 0/15000028", "LOG: consistent recovery state reached at 0/150000F0", "LOG: redo done at 0/150000F0", @@ -1708,7 +1707,7 @@ "filter" : false, "filter-context" : 2, "list" : [ - "20160730-130442F_20160730-130514D" + "20160809-135449F_20160809-135521D" ] }, "host" : "db-master", @@ -1720,27 +1719,27 @@ "stanza: demo", " status: ok", "", - " full backup: 20160730-130437F", - " start / stop timestamp: 2016-07-30 13:04:32 / 2016-07-30 13:04:37", + " full backup: 20160809-135444F", + " start / stop timestamp: 2016-08-09 13:54:39 / 2016-08-09 13:54:44", " database size: 19.3MB, backup size: 19.3MB", " repository size: 2.2MB, repository backup size: 2.2MB", "", - " full backup: 20160730-130442F", - " start / stop timestamp: 2016-07-30 13:04:37 / 2016-07-30 13:04:42", + " full backup: 20160809-135449F", + " start / stop timestamp: 2016-08-09 13:54:44 / 2016-08-09 13:54:49", " database size: 19.3MB, backup size: 19.3MB", " repository size: 2.2MB, repository backup size: 2.2MB", "", - " diff backup: 20160730-130442F_20160730-130514D", - " start / stop timestamp: 2016-07-30 13:05:10 / 2016-07-30 13:05:14", + " diff backup: 20160809-135449F_20160809-135521D", + " start / stop timestamp: 2016-08-09 13:55:17 / 2016-08-09 13:55:21", " database size: 25.7MB, backup size: 6.5MB", " repository size: 3MB, repository backup size: 790.2KB", - " backup reference list: 20160730-130442F", + " backup reference list: 20160809-135449F", "", - " incr backup: 20160730-130442F_20160730-130525I", - " start / stop timestamp: 2016-07-30 13:05:22 / 2016-07-30 13:05:25", + " incr backup: 20160809-135449F_20160809-135530I", + " start / stop timestamp: 2016-08-09 13:55:27 / 2016-08-09 13:55:30", " database size: 25.6MB, backup size: 1.9MB", " repository size: 3MB, repository backup size: 214.9KB", - " backup reference list: 20160730-130442F, 20160730-130442F_20160730-130514D" + " backup reference list: 20160809-135449F, 20160809-135449F_20160809-135521D" ] } }, @@ -1758,8 +1757,8 @@ "key" : { "cmd" : [ "sudo -u postgres pgbackrest --stanza=demo --delta \\", - " --type=time \"--target=2016-07-30 13:05:14.354069+00\" \\", - " --set=20160730-130442F_20160730-130514D restore" + " --type=time \"--target=2016-08-09 13:55:21.327017+00\" \\", + " --set=20160809-135449F_20160809-135521D restore" ], "host" : "db-master", "output" : false @@ -1839,17 +1838,17 @@ "type" : "exe", "value" : { "output" : [ - "LOG: database system was interrupted; last known up at 2016-07-30 13:05:11 UTC", + "LOG: database system was interrupted; last known up at 2016-08-09 13:55:17 UTC", "LOG: creating missing WAL directory \"pg_xlog/archive_status\"", - "LOG: starting point-in-time recovery to 2016-07-30 13:05:14.354069+00", + "LOG: starting point-in-time recovery to 2016-08-09 13:55:21.327017+00", "LOG: restored log file \"00000004.history\" from archive", "LOG: restored log file \"000000040000000000000013\" from archive", "LOG: redo starts at 0/13000028", "LOG: consistent recovery state reached at 0/130000F0", "LOG: restored log file \"000000040000000000000014\" from archive", - "LOG: recovery stopping before commit of transaction 689, time 2016-07-30 13:05:15.010028+00", + "LOG: recovery stopping before commit of transaction 689, time 2016-08-09 13:55:21.425744+00", "LOG: redo done at 0/140157F0", - "LOG: last completed transaction was at log time 2016-07-30 13:05:14.2556+00", + "LOG: last completed transaction was at log time 2016-08-09 13:55:21.213763+00", "LOG: restored log file \"00000005.history\" from archive", "LOG: restored log file \"00000006.history\" from archive", " [filtered 5 lines of output]" @@ -1866,7 +1865,7 @@ }, "type" : "host", "value" : { - "ip" : "172.17.0.3" + "ip" : "172.17.0.5" } }, { @@ -2133,7 +2132,7 @@ "output" : [ " INFO: check start: --backup-host=backup --backup-user=backrest --db-path=/var/lib/pgsql/9.4/data --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo", " INFO: switch xlog 00000008000000000000001A", - " INFO: WAL segment 00000008000000000000001A successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000800000000/00000008000000000000001A-ac1abc665ac22b6325a799a446652701bb778093.gz'", + " INFO: WAL segment 00000008000000000000001A successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000800000000/00000008000000000000001A-ac438235952494c51a36c1b3eefb5e03949c6da0.gz'", " INFO: check stop" ] } @@ -2249,7 +2248,7 @@ }, "type" : "host", "value" : { - "ip" : "172.17.0.4" + "ip" : "172.17.0.6" } }, { @@ -2379,7 +2378,7 @@ "type" : "exe", "value" : { "output" : [ - "LOG: database system was interrupted; last known up at 2016-07-30 13:05:57 UTC", + "LOG: database system was interrupted; last known up at 2016-08-09 13:56:02 UTC", "LOG: creating missing WAL directory \"pg_xlog/archive_status\"", "LOG: entering standby mode", "LOG: restored log file \"00000008.history\" from archive", @@ -2459,7 +2458,7 @@ "output" : [ " pg_switch_xlog | now ", "----------------+-------------------------------", - " 0/1B017918 | 2016-07-30 13:06:19.595884+00", + " 0/1B017918 | 2016-08-09 13:56:24.092707+00", "(1 row)" ] } @@ -2485,7 +2484,7 @@ "output" : [ " message | now ", "----------------+-------------------------------", - " Important Data | 2016-07-30 13:06:23.062865+00", + " Important Data | 2016-08-09 13:56:26.619501+00", "(1 row)" ] } @@ -2510,7 +2509,7 @@ "key" : { "cmd" : [ "sudo -u postgres sh -c 'echo \\", - " \"host replication replicator 172.17.0.4/32 md5\" \\", + " \"host replication replicator 172.17.0.6/32 md5\" \\", " >> /var/lib/pgsql/9.4/data/pg_hba.conf'" ], "host" : "db-master", @@ -2535,7 +2534,7 @@ "option" : { "demo" : { "recovery-option" : { - "value" : "primary_conninfo=host=172.17.0.2 port=5432 user=replicator" + "value" : "primary_conninfo=host=172.17.0.4 port=5432 user=replicator" } } } @@ -2546,7 +2545,7 @@ "[demo]", "db-path=/var/lib/pgsql/9.4/data", "recovery-option=standby_mode=on", - "recovery-option=primary_conninfo=host=172.17.0.2 port=5432 user=replicator", + "recovery-option=primary_conninfo=host=172.17.0.4 port=5432 user=replicator", "", "[global]", "backup-host=backup", @@ -2558,7 +2557,7 @@ "key" : { "cmd" : [ "sudo -u postgres sh -c 'echo \\", - " \"172.17.0.2:*:replication:replicator:jw8s0F4\" \\", + " \"172.17.0.4:*:replication:replicator:jw8s0F4\" \\", " >> /home/postgres/.pgpass'" ], "host" : "db-standby", @@ -2607,7 +2606,7 @@ "type" : "exe", "value" : { "output" : [ - "primary_conninfo = 'host=172.17.0.2 port=5432 user=replicator'", + "primary_conninfo = 'host=172.17.0.4 port=5432 user=replicator'", "standby_mode = 'on'", "restore_command = '/usr/bin/pgbackrest --stanza=demo archive-get %f \"%p\"'" ] @@ -2710,7 +2709,7 @@ "output" : [ " message | now ", "----------------+-------------------------------", - " Important Data | 2016-07-30 13:06:31.098118+00", + " Important Data | 2016-08-09 13:56:34.246435+00", "(1 row)" ] } @@ -2734,9 +2733,9 @@ "type" : "exe", "value" : { "output" : [ - " message | now ", - "----------------+------------------------------", - " Important Data | 2016-07-30 13:06:31.27905+00", + " message | now ", + "----------------+-------------------------------", + " Important Data | 2016-08-09 13:56:34.429238+00", "(1 row)" ] } @@ -2757,7 +2756,7 @@ }, "type" : "host", "value" : { - "ip" : "172.17.0.2" + "ip" : "172.17.0.4" } }, { @@ -2834,7 +2833,7 @@ { "key" : { "cmd" : [ - "sudo cp -r ~/pgbackrest-release-1.04/lib/pgBackRest \\", + "sudo cp -r ~/pgbackrest-release-1.05/lib/pgBackRest \\", " /usr/share/perl5" ], "host" : "db-master", @@ -2865,7 +2864,7 @@ { "key" : { "cmd" : [ - "sudo cp ~/pgbackrest-release-1.04/bin/pgbackrest /usr/bin/pgbackrest" + "sudo cp ~/pgbackrest-release-1.05/bin/pgbackrest /usr/bin/pgbackrest" ], "host" : "db-master", "output" : false @@ -2913,7 +2912,7 @@ "type" : "exe", "value" : { "output" : [ - "pgBackRest 1.04 - General help", + "pgBackRest 1.05 - General help", "", "Usage:", " pgbackrest [options] [command]", @@ -3135,7 +3134,7 @@ " INFO: check start: --db-path=/var/lib/postgresql/9.4/demo --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo", " INFO: switch xlog 000000010000000000000001", " ERROR: [148]: /var/lib/pgbackrest/backup/demo does not exist", - " INFO: WAL segment 000000010000000000000001 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000100000000/000000010000000000000001-2cd8033d2b8827c228f3f16981e129eb9434c201.gz'", + " INFO: WAL segment 000000010000000000000001 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000100000000/000000010000000000000001-dcb086ea01ea9fa7145c3ee270fb108d20b60407.gz'", " INFO: check stop" ] } @@ -3161,11 +3160,11 @@ "output" : [ " INFO: backup start: --db-path=/var/lib/postgresql/9.4/demo --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo", " WARN: no prior backup exists, incr backup has been changed to full", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:06:51\": backup begins after the next regular checkpoint completes", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:56:56\": backup begins after the next regular checkpoint completes", " INFO: archive start: 0/2000028", " [filtered 758 lines of output]", " INFO: backup file /var/lib/postgresql/9.4/demo/base/1/11885 (0B, 100%)", - " INFO: backup file /var/lib/postgresql/9.4/demo/global/pg_control (8KB) checksum a625bca7e562067910692287219facc8be2fdc96", + " INFO: backup file /var/lib/postgresql/9.4/demo/global/pg_control (8KB) checksum 0c46806f245fbae698a467f6591cfead758e1694", " INFO: full backup size = 19.3MB", " INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive", " INFO: archive stop: 0/20000F0", @@ -3184,7 +3183,7 @@ "type" : "exe", "value" : { "output" : [ - "20160730-130656F" + "20160809-135702F" ] } }, @@ -3208,8 +3207,8 @@ "value" : { "output" : [ " [filtered 4 lines of output]", - " INFO: backup file /var/lib/postgresql/9.4/demo/backup_label (236B, 100%) checksum a7bcadbe1c4c0ffd3406017ec50139898a3b8d67", - " INFO: backup file /var/lib/postgresql/9.4/demo/global/pg_control (8KB) checksum f915a711d8d4733c864e67b9b13a327b78bc2d64", + " INFO: backup file /var/lib/postgresql/9.4/demo/backup_label (236B, 100%) checksum 94a6be46134439038320d1b6894cd37200ea8bfc", + " INFO: backup file /var/lib/postgresql/9.4/demo/global/pg_control (8KB) checksum d413d33480d0cd03d99f1970d54a1e6ee7e15871", " INFO: diff backup size = 8.2KB", " INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive", " INFO: archive stop: 0/30000F0", @@ -3238,16 +3237,16 @@ "stanza: demo", " status: ok", "", - " full backup: 20160730-130656F", - " start / stop timestamp: 2016-07-30 13:06:51 / 2016-07-30 13:06:56", + " full backup: 20160809-135702F", + " start / stop timestamp: 2016-08-09 13:56:56 / 2016-08-09 13:57:02", " database size: 19.3MB, backup size: 19.3MB", " repository size: 2.2MB, repository backup size: 2.2MB", "", - " diff backup: 20160730-130656F_20160730-130659D", - " start / stop timestamp: 2016-07-30 13:06:56 / 2016-07-30 13:06:59", + " diff backup: 20160809-135702F_20160809-135706D", + " start / stop timestamp: 2016-08-09 13:57:03 / 2016-08-09 13:57:06", " database size: 19.3MB, backup size: 8.2KB", - " repository size: 2.2MB, repository backup size: 346B", - " backup reference list: 20160730-130656F" + " repository size: 2.2MB, repository backup size: 343B", + " backup reference list: 20160809-135702F" ] } }, @@ -3367,10 +3366,10 @@ "value" : { "output" : [ " INFO: backup start: --db-path=/var/lib/postgresql/9.4/demo --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo --type=incr", - " INFO: last backup label = 20160730-130656F_20160730-130659D, version = 1.04", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:07:08\": backup begins after the next regular checkpoint completes", + " INFO: last backup label = 20160809-135702F_20160809-135706D, version = 1.05", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:57:15\": backup begins after the next regular checkpoint completes", " INFO: archive start: 0/5000028", - " INFO: backup file /var/lib/postgresql/9.4/demo/base/12139/pg_internal.init (115.2KB, 72%) checksum c74474ad98fce025f1aaad1747b3a352e2fa6911", + " INFO: backup file /var/lib/postgresql/9.4/demo/base/12139/pg_internal.init (115.2KB, 72%) checksum 6109524a216f12b4b8429d31ff8e36722922858f", " [filtered 14 lines of output]" ] } @@ -3419,10 +3418,10 @@ "value" : { "output" : [ " INFO: backup start: --db-path=/var/lib/postgresql/9.4/demo --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo --start-fast --type=incr", - " INFO: last backup label = 20160730-130656F_20160730-130711I, version = 1.04", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:07:12\": backup begins after the requested immediate checkpoint completes", + " INFO: last backup label = 20160809-135702F_20160809-135718I, version = 1.05", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:57:19\": backup begins after the requested immediate checkpoint completes", " INFO: archive start: 0/6000028", - " INFO: backup file /var/lib/postgresql/9.4/demo/backup_label (236B, 100%) checksum 24584e154b8d3b8b8b4e3e1d7d05e4e6870a7b2e", + " INFO: backup file /var/lib/postgresql/9.4/demo/backup_label (236B, 100%) checksum 6a3dda90603b70748277eef071b95b721fe58f2a", " [filtered 8 lines of output]" ] } @@ -3458,7 +3457,7 @@ "value" : { "output" : [ " [filtered 2 lines of output]", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:07:15\": backup begins after the requested immediate checkpoint completes", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:57:21\": backup begins after the requested immediate checkpoint completes", " INFO: archive start: 0/7000028", " ERROR: [122]: unable to create /var/lib/pgbackrest/temp/demo.tmp: Permission denied", " INFO: backup stop" @@ -3496,11 +3495,11 @@ "value" : { "output" : [ " INFO: backup start: --db-path=/var/lib/postgresql/9.4/demo --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo --start-fast --type=incr", - " INFO: last backup label = 20160730-130656F_20160730-130715I, version = 1.04", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:07:17\": backup begins after the requested immediate checkpoint completes", + " INFO: last backup label = 20160809-135702F_20160809-135721I, version = 1.05", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:57:23\": backup begins after the requested immediate checkpoint completes", " ERROR: [132]: ERROR: a backup is already in progress", " HINT: Run pg_stop_backup() and try again.:", - " select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS.US TZ'), lsn::text from pg_start_backup('pgBackRest backup started at 2016-07-30 13:07:17', true) as lsn" + " select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS.US TZ'), lsn::text from pg_start_backup('pgBackRest backup started at 2016-08-09 13:57:23', true) as lsn" ] } }, @@ -3549,12 +3548,12 @@ "value" : { "output" : [ " INFO: backup start: --db-path=/var/lib/postgresql/9.4/demo --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo --start-fast --stop-auto --type=incr", - " INFO: last backup label = 20160730-130656F_20160730-130715I, version = 1.04", + " INFO: last backup label = 20160809-135702F_20160809-135721I, version = 1.05", " WARN: the cluster is already in backup mode but no backup process is running. pg_stop_backup() will be called so a new backup can be started.", " INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive", - " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-07-30 13:07:18\": backup begins after the requested immediate checkpoint completes", - " INFO: archive start: 0/9000028", - " INFO: backup file /var/lib/postgresql/9.4/demo/backup_label (236B, 100%) checksum 221a053c9cd0297ae5cca6ec1702667eb089ec23", + " INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2016-08-09 13:57:24\": backup begins after the requested immediate checkpoint completes", + " INFO: archive start: 0/8000028", + " INFO: backup file /var/lib/postgresql/9.4/demo/backup_label (236B, 100%) checksum 92f7a3337294207a8bf52d1e16c895a251c10e8f", " [filtered 8 lines of output]" ] } @@ -3595,7 +3594,7 @@ "filter" : true, "filter-context" : 2, "list" : [ - "archive retention on backup 20160730-130656F|remove archive" + "archive retention on backup 20160809-135702F|remove archive" ] }, "host" : "db-master", @@ -3607,7 +3606,7 @@ " [filtered 767 lines of output]", " INFO: backup stop", " INFO: expire start: --log-level-console=detail --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo", - "DETAIL: archive retention on backup 20160730-130656F, start = 000000010000000000000002", + "DETAIL: archive retention on backup 20160809-135702F, start = 000000010000000000000002", "DETAIL: remove archive: start = 000000010000000000000001, stop = 000000010000000000000001", " INFO: expire stop" ] @@ -3624,7 +3623,7 @@ "type" : "exe", "value" : { "output" : [ - "20160730-130728F" + "20160809-135734F" ] } }, @@ -3638,7 +3637,7 @@ "filter" : true, "filter-context" : 2, "list" : [ - "expire full backup set\\: 20160730-130656F|archive retention on backup 20160730-130728F|remove archive" + "expire full backup set\\: 20160809-135702F|archive retention on backup 20160809-135734F|remove archive" ] }, "host" : "db-master", @@ -3650,9 +3649,9 @@ " [filtered 767 lines of output]", " INFO: backup stop", " INFO: expire start: --log-level-console=info --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo", - " INFO: expire full backup set: 20160730-130656F, 20160730-130656F_20160730-130659D, 20160730-130656F_20160730-130711I, 20160730-130656F_20160730-130715I, 20160730-130656F_20160730-130722I", - " INFO: remove expired backup 20160730-130656F_20160730-130722I", - " INFO: remove expired backup 20160730-130656F_20160730-130715I", + " INFO: expire full backup set: 20160809-135702F, 20160809-135702F_20160809-135706D, 20160809-135702F_20160809-135718I, 20160809-135702F_20160809-135721I, 20160809-135702F_20160809-135728I", + " INFO: remove expired backup 20160809-135702F_20160809-135728I", + " INFO: remove expired backup 20160809-135702F_20160809-135721I", " [filtered 3 lines of output]" ] } @@ -3705,7 +3704,7 @@ "type" : "exe", "value" : { "output" : [ - "20160730-130733F_20160730-130737D" + "20160809-135738F_20160809-135742D" ] } }, @@ -3729,7 +3728,7 @@ "filter" : true, "filter-context" : 2, "list" : [ - "expire diff backup set: 20160730-130733F_20160730-130737D" + "expire diff backup set: 20160809-135738F_20160809-135742D" ] }, "host" : "db-master", @@ -3741,9 +3740,9 @@ " [filtered 10 lines of output]", " INFO: backup stop", " INFO: expire start: --log-level-console=info --repo-path=/var/lib/pgbackrest --retention-diff=1 --retention-full=2 --stanza=demo", - " INFO: expire diff backup set: 20160730-130733F_20160730-130737D, 20160730-130733F_20160730-130740I", - " INFO: remove expired backup 20160730-130733F_20160730-130740I", - " INFO: remove expired backup 20160730-130733F_20160730-130737D" + " INFO: expire diff backup set: 20160809-135738F_20160809-135742D, 20160809-135738F_20160809-135745I", + " INFO: remove expired backup 20160809-135738F_20160809-135745I", + " INFO: remove expired backup 20160809-135738F_20160809-135742D" ] } }, @@ -3786,7 +3785,7 @@ "DETAIL: restore file /var/lib/postgresql/9.4/demo/base/1/11885 - exists and is zero size (0B, 100%)", " INFO: wrote /var/lib/postgresql/9.4/demo/recovery.conf", " INFO: restore global/pg_control (copied last to ensure aborted restores cannot be started)", - " INFO: restore file /var/lib/postgresql/9.4/demo/global/pg_control (8KB) checksum a0bfae1982e09920470de4da219d3ddfad8b9e08", + " INFO: restore file /var/lib/postgresql/9.4/demo/global/pg_control (8KB) checksum bcbadf6e2b939dac65225c1405dc519e483c3cbf", " INFO: restore stop" ] } @@ -4088,7 +4087,7 @@ "type" : "exe", "value" : { "output" : [ - "2016-07-30 13:08:07.382557+00" + "2016-08-09 13:58:15.89565+00" ] } }, @@ -4134,7 +4133,7 @@ "key" : { "cmd" : [ "sudo -u postgres pgbackrest --stanza=demo --delta \\", - " --type=time \"--target=2016-07-30 13:08:07.382557+00\" restore" + " --type=time \"--target=2016-08-09 13:58:15.89565+00\" restore" ], "host" : "db-master", "output" : false @@ -4170,7 +4169,7 @@ "value" : { "output" : [ "restore_command = '/usr/bin/pgbackrest --stanza=demo archive-get %f \"%p\"'", - "recovery_target_time = '2016-07-30 13:08:07.382557+00'" + "recovery_target_time = '2016-08-09 13:58:15.89565+00'" ] } }, @@ -4237,20 +4236,20 @@ "type" : "exe", "value" : { "output" : [ - "LOG: database system was interrupted; last known up at 2016-07-30 13:08:04 UTC", + "LOG: database system was interrupted; last known up at 2016-08-09 13:58:12 UTC", "LOG: creating missing WAL directory \"pg_xlog/archive_status\"", - "LOG: starting point-in-time recovery to 2016-07-30 13:08:07.382557+00", + "LOG: starting point-in-time recovery to 2016-08-09 13:58:15.89565+00", "LOG: restored log file \"00000004.history\" from archive", - "LOG: restored log file \"000000040000000000000013\" from archive", + "LOG: restored log file \"000000040000000000000014\" from archive", " [filtered 2 lines of output]", "LOG: incomplete startup packet", - "LOG: restored log file \"000000040000000000000014\" from archive", - "LOG: recovery stopping before commit of transaction 689, time 2016-07-30 13:08:07.522151+00", - "LOG: redo done at 0/140157F0", - "LOG: last completed transaction was at log time 2016-07-30 13:08:07.226591+00", + "LOG: restored log file \"000000040000000000000015\" from archive", + "LOG: recovery stopping before commit of transaction 689, time 2016-08-09 13:58:16.080924+00", + "LOG: redo done at 0/150157F0", + "LOG: last completed transaction was at log time 2016-08-09 13:58:15.677286+00", "LOG: selected new timeline ID: 5", "LOG: restored log file \"00000004.history\" from archive", - " [filtered 6 lines of output]" + " [filtered 5 lines of output]" ] } }, @@ -4293,7 +4292,7 @@ "type" : "exe", "value" : { "output" : [ - "20160730-130733F_20160730-130806D" + "20160809-135738F_20160809-135815D" ] } }, @@ -4321,7 +4320,7 @@ "key" : { "cmd" : [ "sudo -u postgres pgbackrest --stanza=demo --delta \\", - " --type=time \"--target=2016-07-30 13:08:07.382557+00\" restore" + " --type=time \"--target=2016-08-09 13:58:15.89565+00\" restore" ], "host" : "db-master", "output" : false @@ -4401,15 +4400,15 @@ "type" : "exe", "value" : { "output" : [ - "LOG: database system was interrupted; last known up at 2016-07-30 13:08:15 UTC", + "LOG: database system was interrupted; last known up at 2016-08-09 13:58:23 UTC", "LOG: creating missing WAL directory \"pg_xlog/archive_status\"", - "LOG: starting point-in-time recovery to 2016-07-30 13:08:07.382557+00", + "LOG: starting point-in-time recovery to 2016-08-09 13:58:15.89565+00", "LOG: restored log file \"00000005.history\" from archive", - "LOG: restored log file \"000000050000000000000015\" from archive", - "LOG: redo starts at 0/15000028", - "LOG: consistent recovery state reached at 0/150000F0", + "LOG: restored log file \"000000050000000000000016\" from archive", + "LOG: redo starts at 0/16000028", + "LOG: consistent recovery state reached at 0/160000F0", "LOG: incomplete startup packet", - "LOG: redo done at 0/150000F0", + "LOG: redo done at 0/160000F0", " [filtered 11 lines of output]" ] } @@ -4423,7 +4422,7 @@ "filter" : false, "filter-context" : 2, "list" : [ - "20160730-130733F_20160730-130806D" + "20160809-135738F_20160809-135815D" ] }, "host" : "db-master", @@ -4435,27 +4434,27 @@ "stanza: demo", " status: ok", "", - " full backup: 20160730-130728F", - " start / stop timestamp: 2016-07-30 13:07:23 / 2016-07-30 13:07:28", + " full backup: 20160809-135734F", + " start / stop timestamp: 2016-08-09 13:57:29 / 2016-08-09 13:57:34", " database size: 19.3MB, backup size: 19.3MB", " repository size: 2.2MB, repository backup size: 2.2MB", "", - " full backup: 20160730-130733F", - " start / stop timestamp: 2016-07-30 13:07:28 / 2016-07-30 13:07:33", + " full backup: 20160809-135738F", + " start / stop timestamp: 2016-08-09 13:57:34 / 2016-08-09 13:57:38", " database size: 19.3MB, backup size: 19.3MB", " repository size: 2.2MB, repository backup size: 2.2MB", "", - " diff backup: 20160730-130733F_20160730-130806D", - " start / stop timestamp: 2016-07-30 13:08:03 / 2016-07-30 13:08:06", + " diff backup: 20160809-135738F_20160809-135815D", + " start / stop timestamp: 2016-08-09 13:58:11 / 2016-08-09 13:58:15", " database size: 25.7MB, backup size: 6.5MB", " repository size: 3MB, repository backup size: 788.7KB", - " backup reference list: 20160730-130733F", + " backup reference list: 20160809-135738F", "", - " incr backup: 20160730-130733F_20160730-130817I", - " start / stop timestamp: 2016-07-30 13:08:14 / 2016-07-30 13:08:17", + " incr backup: 20160809-135738F_20160809-135825I", + " start / stop timestamp: 2016-08-09 13:58:22 / 2016-08-09 13:58:25", " database size: 25.6MB, backup size: 1.9MB", " repository size: 2.9MB, repository backup size: 214.3KB", - " backup reference list: 20160730-130733F, 20160730-130733F_20160730-130806D" + " backup reference list: 20160809-135738F, 20160809-135738F_20160809-135815D" ] } }, @@ -4473,8 +4472,8 @@ "key" : { "cmd" : [ "sudo -u postgres pgbackrest --stanza=demo --delta \\", - " --type=time \"--target=2016-07-30 13:08:07.382557+00\" \\", - " --set=20160730-130733F_20160730-130806D restore" + " --type=time \"--target=2016-08-09 13:58:15.89565+00\" \\", + " --set=20160809-135738F_20160809-135815D restore" ], "host" : "db-master", "output" : false @@ -4554,17 +4553,17 @@ "type" : "exe", "value" : { "output" : [ - "LOG: database system was interrupted; last known up at 2016-07-30 13:08:04 UTC", + "LOG: database system was interrupted; last known up at 2016-08-09 13:58:12 UTC", "LOG: creating missing WAL directory \"pg_xlog/archive_status\"", - "LOG: starting point-in-time recovery to 2016-07-30 13:08:07.382557+00", + "LOG: starting point-in-time recovery to 2016-08-09 13:58:15.89565+00", "LOG: restored log file \"00000004.history\" from archive", - "LOG: restored log file \"000000040000000000000013\" from archive", + "LOG: restored log file \"000000040000000000000014\" from archive", " [filtered 2 lines of output]", "LOG: incomplete startup packet", - "LOG: restored log file \"000000040000000000000014\" from archive", - "LOG: recovery stopping before commit of transaction 689, time 2016-07-30 13:08:07.522151+00", - "LOG: redo done at 0/140157F0", - "LOG: last completed transaction was at log time 2016-07-30 13:08:07.226591+00", + "LOG: restored log file \"000000040000000000000015\" from archive", + "LOG: recovery stopping before commit of transaction 689, time 2016-08-09 13:58:16.080924+00", + "LOG: redo done at 0/150157F0", + "LOG: last completed transaction was at log time 2016-08-09 13:58:15.677286+00", "LOG: restored log file \"00000005.history\" from archive", "LOG: restored log file \"00000006.history\" from archive", " [filtered 8 lines of output]" @@ -4581,7 +4580,7 @@ }, "type" : "host", "value" : { - "ip" : "172.17.0.3" + "ip" : "172.17.0.5" } }, { @@ -4847,8 +4846,8 @@ "value" : { "output" : [ " INFO: check start: --backup-host=backup --backup-user=backrest --db-path=/var/lib/postgresql/9.4/demo --log-level-console=info --repo-path=/var/lib/pgbackrest --stanza=demo", - " INFO: switch xlog 000000080000000000000019", - " INFO: WAL segment 000000080000000000000019 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000800000000/000000080000000000000019-2556116c95421cd8fefb2ccab6d8884a77c66b1e.gz'", + " INFO: switch xlog 00000008000000000000001B", + " INFO: WAL segment 00000008000000000000001B successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000800000000/00000008000000000000001B-87119ab1b27854bcdc2ccebfa4ce6d524d8be499.gz'", " INFO: check stop" ] } @@ -4964,7 +4963,7 @@ }, "type" : "host", "value" : { - "ip" : "172.17.0.4" + "ip" : "172.17.0.6" } }, { @@ -5117,16 +5116,16 @@ "type" : "exe", "value" : { "output" : [ - "LOG: database system was interrupted; last known up at 2016-07-30 13:08:52 UTC", + "LOG: database system was interrupted; last known up at 2016-08-09 13:58:59 UTC", "LOG: creating missing WAL directory \"pg_xlog/archive_status\"", "LOG: entering standby mode", "LOG: restored log file \"00000008.history\" from archive", "LOG: incomplete startup packet", - "LOG: restored log file \"000000080000000000000018\" from archive", - "LOG: redo starts at 0/18000028", - "LOG: consistent recovery state reached at 0/180000F0", + "LOG: restored log file \"00000008000000000000001A\" from archive", + "LOG: redo starts at 0/1A000028", + "LOG: consistent recovery state reached at 0/1A0000F0", "LOG: database system is ready to accept read only connections", - "LOG: restored log file \"000000080000000000000019\" from archive" + "LOG: restored log file \"00000008000000000000001B\" from archive" ] } }, @@ -5196,9 +5195,9 @@ "type" : "exe", "value" : { "output" : [ - " pg_switch_xlog | now ", - "----------------+-------------------------------", - " 0/1A017918 | 2016-07-30 13:09:12.199735+00", + " pg_switch_xlog | now ", + "----------------+------------------------------", + " 0/1C017918 | 2016-08-09 13:59:20.03915+00", "(1 row)" ] } @@ -5222,9 +5221,9 @@ "type" : "exe", "value" : { "output" : [ - " message | now ", - "----------------+-------------------------------", - " Important Data | 2016-07-30 13:09:15.298556+00", + " message | now ", + "----------------+------------------------------", + " Important Data | 2016-08-09 13:59:23.13136+00", "(1 row)" ] } @@ -5249,7 +5248,7 @@ "key" : { "cmd" : [ "sudo -u postgres sh -c 'echo \\", - " \"host replication replicator 172.17.0.4/32 md5\" \\", + " \"host replication replicator 172.17.0.6/32 md5\" \\", " >> /etc/postgresql/9.4/demo/pg_hba.conf'" ], "host" : "db-master", @@ -5274,7 +5273,7 @@ "option" : { "demo" : { "recovery-option" : { - "value" : "primary_conninfo=host=172.17.0.2 port=5432 user=replicator" + "value" : "primary_conninfo=host=172.17.0.4 port=5432 user=replicator" } } } @@ -5285,7 +5284,7 @@ "[demo]", "db-path=/var/lib/postgresql/9.4/demo", "recovery-option=standby_mode=on", - "recovery-option=primary_conninfo=host=172.17.0.2 port=5432 user=replicator", + "recovery-option=primary_conninfo=host=172.17.0.4 port=5432 user=replicator", "", "[global]", "backup-host=backup", @@ -5297,7 +5296,7 @@ "key" : { "cmd" : [ "sudo -u postgres sh -c 'echo \\", - " \"172.17.0.2:*:replication:replicator:jw8s0F4\" \\", + " \"172.17.0.4:*:replication:replicator:jw8s0F4\" \\", " >> /home/postgres/.pgpass'" ], "host" : "db-standby", @@ -5346,7 +5345,7 @@ "type" : "exe", "value" : { "output" : [ - "primary_conninfo = 'host=172.17.0.2 port=5432 user=replicator'", + "primary_conninfo = 'host=172.17.0.4 port=5432 user=replicator'", "standby_mode = 'on'", "restore_command = '/usr/bin/pgbackrest --stanza=demo archive-get %f \"%p\"'" ] @@ -5401,9 +5400,9 @@ "value" : { "output" : [ " [filtered 9 lines of output]", - "LOG: restored log file \"000000080000000000000019\" from archive", - "LOG: restored log file \"00000008000000000000001A\" from archive", - "LOG: started streaming WAL from primary at 0/1B000000 on timeline 8" + "LOG: restored log file \"00000008000000000000001B\" from archive", + "LOG: restored log file \"00000008000000000000001C\" from archive", + "LOG: started streaming WAL from primary at 0/1D000000 on timeline 8" ] } }, @@ -5432,7 +5431,7 @@ "output" : [ " message | now ", "----------------+-------------------------------", - " Important Data | 2016-07-30 13:09:22.538264+00", + " Important Data | 2016-08-09 13:59:30.077421+00", "(1 row)" ] } @@ -5458,7 +5457,7 @@ "output" : [ " message | now ", "----------------+-------------------------------", - " Important Data | 2016-07-30 13:09:22.707572+00", + " Important Data | 2016-08-09 13:59:30.307857+00", "(1 row)" ] } diff --git a/doc/xml/release.xml b/doc/xml/release.xml index 945ff6f0b..73071ae5e 100644 --- a/doc/xml/release.xml +++ b/doc/xml/release.xml @@ -109,7 +109,7 @@ </contributor-list> <release-list> - <release date="XXXX-XX-XX" version="1.05dev" title="UNDER DEVELOPMENT"> + <release date="2016-08-09" version="1.05" title="Bug Fix for Tablespace Link Checking"> <release-core-list> <release-bug-list> <release-item> diff --git a/lib/pgBackRest/Version.pm b/lib/pgBackRest/Version.pm index f0f4ed214..42ed494f0 100644 --- a/lib/pgBackRest/Version.pm +++ b/lib/pgBackRest/Version.pm @@ -27,7 +27,7 @@ use constant BACKREST_CONF => BACKREST_ # Defines the current version of the BackRest executable. The version number is used to track features but does not affect what # repositories or manifests can be read - that's the job of the format number. #----------------------------------------------------------------------------------------------------------------------------------- -use constant BACKREST_VERSION => '1.05dev'; +use constant BACKREST_VERSION => '1.05'; push @EXPORT, qw(BACKREST_VERSION); # Format Format Number [parent: 34afe5e85b68]