pgbackrest.git / summary / log / commit / refs
commit d0bf946857d73dcca2ce2a7bf0b78fd8aee2a19b
Author: David Steele <david@pgmasters.net>
Date: Thu Sep 28 23:06:41 2017 +0000
v1.24: New Backup Exclusions
Bug Fixes:
* Fixed an issue where warnings were being emitted in place of lower priority log messages during backup from standby initialization. (Reported by Uspen.)
* Fixed an issue where some db-* options (e.g. db-port) were not being passed to remotes. (Reported by Uspen.)
Features:
* Exclude contents of pg_snapshots, pg_serial, pg_notify, and pg_dynshmem from backup since they are rebuilt on startup.
* Exclude pg_internal.init files from backup since they are rebuilt on startup.
README.md | 2 +-
doc/resource/exe.cache | 3986 ++++++++++++++++++++-----------
doc/xml/release.xml | 17 +-
lib/pgBackRest/Config/ConfigHelpData.pm | 6 +-
lib/pgBackRest/Version.pm | 2 +-
5 files changed, 2626 insertions(+), 1387 deletions(-)
diff --git a/README.md b/README.md
index 750590bfd..a5fbbf072 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.23](https://github.com/pgbackrest/pgbackrest/releases/tag/release/1.23) is the current stable release. Release notes are on the [Releases](http://www.pgbackrest.org/release.html) page.
+pgBackRest [v1.24](https://github.com/pgbackrest/pgbackrest/releases/tag/release/1.24) 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 36fc89c68..f2009040f 100644
--- a/doc/resource/exe.cache
+++ b/doc/resource/exe.cache
@@ -15,8 +15,8 @@
},
{
"key" : {
- "image" : "pgbackrest/test:co6-doc-db",
- "name" : "db-master",
+ "image" : "pgbackrest/test:co6-base",
+ "name" : "db-primary",
"os" : "co6"
},
"type" : "host",
@@ -24,6 +24,66 @@
"ip" : "172.17.0.3"
}
},
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -f /usr/bin/pgbackrest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -f /usr/bin/pg_backrest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -rf /usr/lib/perl5/BackRest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -rf /usr/share/perl5/BackRest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -rf /usr/lib/perl5/pgBackRest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -rf /usr/share/perl5/pgBackRest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
{
"key" : {
"cmd" : [
@@ -31,7 +91,7 @@
" perl-Digest-SHA perl-DBD-Pg perl-XML-LibXML perl-IO-Socket-SSL"
],
"cmd-extra" : "-y",
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -39,9 +99,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -f /usr/bin/pgbackrest"
+ "sudo mkdir /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -49,9 +109,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -f /usr/bin/pg_backrest"
+ "sudo cp -r /backrest/bin /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -59,9 +119,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -rf /usr/lib/perl5/BackRest"
+ "sudo cp -r /backrest/build /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -69,9 +129,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -rf /usr/share/perl5/BackRest"
+ "sudo cp -r /backrest/lib /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -79,9 +139,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -rf /usr/lib/perl5/pgBackRest"
+ "sudo cp -r /backrest/libc /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -89,9 +149,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -rf /usr/share/perl5/pgBackRest"
+ "sudo cp -r /backrest/src /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -99,10 +159,10 @@
{
"key" : {
"cmd" : [
- "sudo cp -r /root/pgbackrest-release-1.23/lib/pgBackRest \\",
+ "sudo cp -r /root/pgbackrest-release-1.24/lib/pgBackRest \\",
" /usr/share/perl5"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -112,7 +172,7 @@
"cmd" : [
"sudo find /usr/share/perl5/pgBackRest -type f -exec chmod 644 {} +"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -122,7 +182,7 @@
"cmd" : [
"sudo find /usr/share/perl5/pgBackRest -type d -exec chmod 755 {} +"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -130,9 +190,9 @@
{
"key" : {
"cmd" : [
- "sudo cp /root/pgbackrest-release-1.23/bin/pgbackrest /usr/bin/pgbackrest"
+ "sudo cp /root/pgbackrest-release-1.24/bin/pgbackrest /usr/bin/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -142,7 +202,7 @@
"cmd" : [
"sudo chmod 755 /usr/bin/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -152,7 +212,7 @@
"cmd" : [
"sudo mkdir -m 770 /var/log/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -162,7 +222,7 @@
"cmd" : [
"sudo chown postgres:postgres /var/log/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -172,7 +232,7 @@
"cmd" : [
"sudo touch /etc/pgbackrest.conf"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -182,7 +242,7 @@
"cmd" : [
"sudo chmod 640 /etc/pgbackrest.conf"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -192,7 +252,7 @@
"cmd" : [
"sudo chown postgres:postgres /etc/pgbackrest.conf"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -202,13 +262,13 @@
"cmd" : [
"sudo -u postgres pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "pgBackRest 1.23 - General help",
+ "pgBackRest 1.24 - General help",
"",
"Usage:",
" pgbackrest [options] [command]",
@@ -237,7 +297,7 @@
"cmd" : [
"sudo service postgresql-9.5 initdb"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -250,7 +310,7 @@
{
"key" : {
"file" : "/var/lib/pgsql/9.5/data/postgresql.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"listen_addresses" : {
"value" : "'*'"
@@ -267,7 +327,7 @@
{
"key" : {
"file" : "/var/lib/pgsql/9.5/data/postgresql.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"log_line_prefix" : {
"value" : "''"
@@ -285,7 +345,7 @@
{
"key" : {
"file" : "/var/lib/pgsql/9.5/data/postgresql.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"log_filename" : {
"value" : "'postgresql.log'"
@@ -304,7 +364,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"demo" : {
"db-path" : {
@@ -334,7 +394,7 @@
"cmd" : [
"sudo mkdir /var/lib/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -344,7 +404,7 @@
"cmd" : [
"sudo chmod 750 /var/lib/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -354,7 +414,7 @@
"cmd" : [
"sudo chown postgres:postgres /var/lib/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -362,7 +422,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"repo-path" : {
@@ -385,7 +445,7 @@
{
"key" : {
"file" : "/var/lib/pgsql/9.5/data/postgresql.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"archive_command" : {
"value" : "'pgbackrest --stanza=demo archive-push %p'"
@@ -419,7 +479,7 @@
"cmd" : [
"sudo service postgresql-9.5 restart"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -427,9 +487,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -437,7 +497,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"retention-full" : {
@@ -470,13 +530,13 @@
"completed successfully"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: stanza-create command begin 1.23: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --no-log-timestamp --repo-path=/var/lib/pgbackrest --stanza=demo",
+ "P00 INFO: stanza-create command begin 1.24: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --no-log-timestamp --repo-path=/var/lib/pgbackrest --stanza=demo",
"P00 INFO: stanza-create command end: completed successfully"
]
}
@@ -493,14 +553,14 @@
" successfully stored in the archive at "
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: check command begin 1.23: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --stanza=demo",
- "P00 INFO: WAL segment 000000010000000000000001 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.5-1/0000000100000000/000000010000000000000001-a6082a8c0ad6f84a3b6854cdfd9d1786dbf871c0.gz'",
+ "P00 INFO: check command begin 1.24: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --stanza=demo",
+ "P00 INFO: WAL segment 000000010000000000000001 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.5-1/0000000100000000/000000010000000000000001-d4ae499c06bdcd3039e104d015f4e81274185716.gz'",
"P00 INFO: check command end: completed successfully"
]
}
@@ -518,20 +578,20 @@
"no prior backup exists|full backup size"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo",
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo",
"P00 WARN: no prior backup exists, incr backup has been changed to full",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:28:50\": backup begins after the next regular checkpoint completes",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:50:20\": backup begins after the next regular checkpoint completes",
"P00 INFO: backup start archive = 000000010000000000000002, lsn = 0/2000028",
- " [filtered 854 lines of output]",
+ " [filtered 851 lines of output]",
"P01 INFO: backup file /var/lib/pgsql/9.5/data/base/1/12216 (0B, 100%)",
"P01 INFO: backup file /var/lib/pgsql/9.5/data/base/1/12211 (0B, 100%)",
- "P00 INFO: full backup size = 20.7MB",
+ "P00 INFO: full backup size = 20.5MB",
"P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
"P00 INFO: backup stop archive = 000000010000000000000002, lsn = 0/20000F8",
" [filtered 4 lines of output]"
@@ -543,13 +603,13 @@
"cmd" : [
"sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-212850F"
+ "20170928-225020F"
]
}
},
@@ -566,18 +626,18 @@
"diff backup size"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
" [filtered 4 lines of output]",
- "P01 INFO: backup file /var/lib/pgsql/9.5/data/global/pg_control (8KB, 97%) checksum 4937d688df54d48bf0b37f6c81ec03eb3ede3c5c",
- "P01 INFO: backup file /var/lib/pgsql/9.5/data/backup_label (236B, 100%) checksum a5d7851244380ec01429976dfcd7859eac3145e6",
+ "P01 INFO: backup file /var/lib/pgsql/9.5/data/global/pg_control (8KB, 97%) checksum 14d438f3004ab961bd9faff8b2cb0c6a8d835412",
+ "P01 INFO: backup file /var/lib/pgsql/9.5/data/backup_label (236B, 100%) checksum c653b11d95f06711f4b17541a4da747bc659d0ce",
"P00 INFO: diff backup size = 8.2KB",
"P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
- "P00 INFO: backup stop archive = 000000010000000000000003, lsn = 0/3000130",
+ "P00 INFO: backup stop archive = 000000010000000000000003, lsn = 0/30000F8",
" [filtered 4 lines of output]"
]
}
@@ -594,7 +654,7 @@
"(full|incr|diff) backup"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -606,18 +666,18 @@
" db (current)",
" wal archive min/max (9.5-1): 000000010000000000000002 / 000000010000000000000003",
"",
- " full backup: 20170903-212850F",
- " timestamp start/stop: 2017-09-03 21:28:50 / 2017-09-03 21:28:55",
+ " full backup: 20170928-225020F",
+ " timestamp start/stop: 2017-09-28 22:50:20 / 2017-09-28 22:50:25",
" wal start/stop: 000000010000000000000002 / 000000010000000000000002",
- " database size: 20.7MB, backup size: 20.7MB",
+ " database size: 20.5MB, backup size: 20.5MB",
" repository size: 2.3MB, repository backup size: 2.3MB",
"",
- " diff backup: 20170903-212850F_20170903-212856D",
- " timestamp start/stop: 2017-09-03 21:28:56 / 2017-09-03 21:29:00",
+ " diff backup: 20170928-225020F_20170928-225026D",
+ " timestamp start/stop: 2017-09-28 22:50:26 / 2017-09-28 22:50:29",
" wal start/stop: 000000010000000000000003 / 000000010000000000000003",
- " database size: 20.7MB, backup size: 8.2KB",
- " repository size: 2.3MB, repository backup size: 344B",
- " backup reference list: 20170903-212850F"
+ " database size: 20.5MB, backup size: 8.2KB",
+ " repository size: 2.3MB, repository backup size: 347B",
+ " backup reference list: 20170928-225020F"
]
}
},
@@ -626,7 +686,7 @@
"cmd" : [
"sudo service postgresql-9.5 stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -636,7 +696,7 @@
"cmd" : [
"sudo -u postgres rm /var/lib/pgsql/9.5/data/global/pg_control"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -644,9 +704,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -656,7 +716,7 @@
"cmd" : [
"sudo rm -f /var/lib/pgsql/9.5/pgstartup.log"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -667,7 +727,7 @@
"sudo service postgresql-9.5 start"
],
"err-expect" : "1",
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -684,7 +744,7 @@
"could not find the database system"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -701,7 +761,7 @@
"cmd" : [
"sudo -u postgres find /var/lib/pgsql/9.5/data -mindepth 1 -delete"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -711,7 +771,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo restore"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -721,7 +781,7 @@
"cmd" : [
"sudo service postgresql-9.5 start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -729,9 +789,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -749,25 +809,25 @@
"backup begins after the next regular checkpoint completes"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --type=incr",
- "P00 INFO: last backup label = 20170903-212850F_20170903-212856D, version = 1.23",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:29:12\": backup begins after the next regular checkpoint completes",
- "P00 INFO: backup start archive = 000000020000000000000005, lsn = 0/5000028",
- "P01 INFO: backup file /var/lib/pgsql/9.5/data/base/12378/pg_internal.init (119.6KB, 71%) checksum f21c95103a2645f1e8eb0b0844e7040c4b5b3161",
- " [filtered 14 lines of output]"
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --type=incr",
+ "P00 INFO: last backup label = 20170928-225020F_20170928-225026D, version = 1.24",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:50:43\": backup begins after the next regular checkpoint completes",
+ "P00 INFO: backup start archive = 000000020000000000000006, lsn = 0/6000028",
+ "P01 INFO: backup file /var/lib/pgsql/9.5/data/pg_multixact/offsets/0000 (8KB, 31%) checksum 0631457264ff7f8d5fb1edc2c0211992a67c73e6",
+ " [filtered 11 lines of output]"
]
}
},
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"start-fast" : {
@@ -802,17 +862,17 @@
"backup begins after the requested immediate checkpoint completes"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --type=incr",
- "P00 INFO: last backup label = 20170903-212850F_20170903-212912I, version = 1.23",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:29:16\": backup begins after the requested immediate checkpoint completes",
- "P00 INFO: backup start archive = 000000020000000000000006, lsn = 0/6000028",
- "P01 INFO: backup file /var/lib/pgsql/9.5/data/global/pg_control (8KB, 97%) checksum 83cca92b10c5764bfd5c79f34ec31a6f4b65f90e",
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --type=incr",
+ "P00 INFO: last backup label = 20170928-225020F_20170928-225043I, version = 1.24",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:50:47\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup start archive = 000000020000000000000007, lsn = 0/7000028",
+ "P01 INFO: backup file /var/lib/pgsql/9.5/data/global/pg_control (8KB, 97%) checksum d79d7c10f5c8761441114df329c80e2fb3a10836",
" [filtered 8 lines of output]"
]
}
@@ -822,7 +882,7 @@
"cmd" : [
"sudo chmod 550 /var/lib/pgbackrest/backup/demo/"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -841,16 +901,16 @@
"ERROR:"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
" [filtered 2 lines of output]",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:29:21\": backup begins after the requested immediate checkpoint completes",
- "P00 INFO: backup start archive = 000000020000000000000007, lsn = 0/7000028",
- "P00 ERROR: [047]: unable to create path '/var/lib/pgbackrest/backup/demo/20170903-212850F_20170903-212921I': Permission denied",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:50:51\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup start archive = 000000020000000000000008, lsn = 0/8000028",
+ "P00 ERROR: [047]: unable to create path '/var/lib/pgbackrest/backup/demo/20170928-225020F_20170928-225051I': Permission denied",
"P00 INFO: backup command end: aborted with exception [047]"
]
}
@@ -860,7 +920,7 @@
"cmd" : [
"sudo chmod 750 /var/lib/pgbackrest/backup/demo/"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -879,25 +939,25 @@
"ERROR:"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --type=incr",
- "P00 INFO: last backup label = 20170903-212850F_20170903-212916I, version = 1.23",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:29:23\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --type=incr",
+ "P00 INFO: last backup label = 20170928-225020F_20170928-225047I, version = 1.24",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:50:53\": backup begins after the requested immediate checkpoint completes",
"P00 ERROR: [057]: 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'), pg_xlogfile_name(lsn), lsn::text from pg_start_backup('pgBackRest backup started at 2017-09-03 21:29:23', true) as lsn"
+ " select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS.US TZ'), pg_xlogfile_name(lsn), lsn::text from pg_start_backup('pgBackRest backup started at 2017-09-28 22:50:53', true) as lsn"
]
}
},
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"stop-auto" : {
@@ -933,19 +993,19 @@
"cluster is already in backup mode|backup begins after the requested immediate checkpoint completes"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --stop-auto --type=incr",
- "P00 INFO: last backup label = 20170903-212850F_20170903-212916I, version = 1.23",
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --stop-auto --type=incr",
+ "P00 INFO: last backup label = 20170928-225020F_20170928-225047I, version = 1.24",
"P00 WARN: the cluster is already in backup mode but no pgBackRest backup process is running. pg_stop_backup() will be called so a new backup can be started.",
"P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:29:25\": backup begins after the requested immediate checkpoint completes",
- "P00 INFO: backup start archive = 000000020000000000000008, lsn = 0/8000028",
- "P01 INFO: backup file /var/lib/pgsql/9.5/data/global/pg_control (8KB, 85%) checksum 0229f7479418f28b7ef47bf9a3e5ad00dfe1b983",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:50:55\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup start archive = 000000020000000000000009, lsn = 0/9000028",
+ "P01 INFO: backup file /var/lib/pgsql/9.5/data/global/pg_control (8KB, 84%) checksum 84f3fbd9bae3153e77d4e006dc67967a384ff47d",
" [filtered 9 lines of output]"
]
}
@@ -953,7 +1013,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"retention-full" : {
@@ -986,19 +1046,19 @@
"filter" : true,
"filter-context" : 2,
"list" : [
- "archive retention on backup 20170903-212850F|remove archive"
+ "archive retention on backup 20170928-225020F|remove archive"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " [filtered 863 lines of output]",
+ " [filtered 860 lines of output]",
"P00 INFO: backup command end: completed successfully",
- "P00 INFO: expire command begin 1.23: --log-level-console=detail --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-full=2 --stanza=demo",
- "P00 DETAIL: archive retention on backup 20170903-212850F, archiveId = 9.5-1, start = 000000010000000000000002",
+ "P00 INFO: expire command begin 1.24: --log-level-console=detail --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-full=2 --stanza=demo",
+ "P00 DETAIL: archive retention on backup 20170928-225020F, archiveId = 9.5-1, start = 000000010000000000000002",
"P00 DETAIL: no archive to remove, archiveId = 9.5-1",
"P00 INFO: expire command end: completed successfully"
]
@@ -1009,13 +1069,13 @@
"cmd" : [
"sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-212930F"
+ "20170928-225100F"
]
}
},
@@ -1029,21 +1089,21 @@
"filter" : true,
"filter-context" : 2,
"list" : [
- "expire full backup set\\: 20170903-212850F|archive retention on backup 20170903-212930F|remove archive"
+ "expire full backup set\\: 20170928-225020F|archive retention on backup 20170928-225100F|remove archive"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " [filtered 863 lines of output]",
+ " [filtered 860 lines of output]",
"P00 INFO: backup command end: completed successfully",
- "P00 INFO: expire command begin 1.23: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-full=2 --stanza=demo",
- "P00 INFO: expire full backup set: 20170903-212850F, 20170903-212850F_20170903-212856D, 20170903-212850F_20170903-212912I, 20170903-212850F_20170903-212916I, 20170903-212850F_20170903-212925I",
- "P00 INFO: remove expired backup 20170903-212850F_20170903-212925I",
- "P00 INFO: remove expired backup 20170903-212850F_20170903-212916I",
+ "P00 INFO: expire command begin 1.24: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-full=2 --stanza=demo",
+ "P00 INFO: expire full backup set: 20170928-225020F, 20170928-225020F_20170928-225026D, 20170928-225020F_20170928-225043I, 20170928-225020F_20170928-225047I, 20170928-225020F_20170928-225055I",
+ "P00 INFO: remove expired backup 20170928-225020F_20170928-225055I",
+ "P00 INFO: remove expired backup 20170928-225020F_20170928-225047I",
" [filtered 3 lines of output]"
]
}
@@ -1051,7 +1111,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"retention-diff" : {
@@ -1080,7 +1140,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --type=diff backup"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1090,13 +1150,13 @@
"cmd" : [
"sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-212937F_20170903-212946D"
+ "20170928-225107F_20170928-225116D"
]
}
},
@@ -1105,7 +1165,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --type=incr backup"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1120,10 +1180,10 @@
"filter" : true,
"filter-context" : 2,
"list" : [
- "expire diff backup set: 20170903-212937F_20170903-212946D"
+ "expire diff backup set: 20170928-225107F_20170928-225116D"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1131,17 +1191,17 @@
"output" : [
" [filtered 10 lines of output]",
"P00 INFO: backup command end: completed successfully",
- "P00 INFO: expire command begin 1.23: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-diff=1 --retention-full=2 --stanza=demo",
- "P00 INFO: expire diff backup set: 20170903-212937F_20170903-212946D, 20170903-212937F_20170903-212951I",
- "P00 INFO: remove expired backup 20170903-212937F_20170903-212951I",
- "P00 INFO: remove expired backup 20170903-212937F_20170903-212946D"
+ "P00 INFO: expire command begin 1.24: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-diff=1 --retention-full=2 --stanza=demo",
+ "P00 INFO: expire diff backup set: 20170928-225107F_20170928-225116D, 20170928-225107F_20170928-225120I",
+ "P00 INFO: remove expired backup 20170928-225107F_20170928-225120I",
+ "P00 INFO: remove expired backup 20170928-225107F_20170928-225116D"
]
}
},
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"retention-diff" : {
@@ -1170,13 +1230,13 @@
"cmd" : [
"sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-212937F_20170903-212956D"
+ "20170928-225107F_20170928-225125D"
]
}
},
@@ -1187,7 +1247,7 @@
" select pg_create_restore_point('generate WAL'); select pg_switch_xlog(); \\",
" select pg_create_restore_point('generate WAL'); select pg_switch_xlog();\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1205,7 +1265,7 @@
"new backup label"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1213,10 +1273,10 @@
"output" : [
" [filtered 8 lines of output]",
"P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
- "P00 INFO: backup stop archive = 000000020000000000000010, lsn = 0/100000F8",
- "P00 INFO: new backup label = 20170903-212937F_20170903-213002D",
+ "P00 INFO: backup stop archive = 000000020000000000000012, lsn = 0/120000F8",
+ "P00 INFO: new backup label = 20170928-225107F_20170928-225130D",
"P00 INFO: backup command end: completed successfully",
- "P00 INFO: expire command begin 1.23: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-diff=2 --retention-full=2 --stanza=demo"
+ "P00 INFO: expire command begin 1.24: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-diff=2 --retention-full=2 --stanza=demo"
]
}
},
@@ -1225,13 +1285,13 @@
"cmd" : [
"sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-212937F_20170903-213002D"
+ "20170928-225107F_20170928-225130D"
]
}
},
@@ -1245,22 +1305,22 @@
"filter" : true,
"filter-context" : 2,
"list" : [
- "archive retention on backup 20170903-212937F_20170903-212956D|remove archive"
+ "archive retention on backup 20170928-225107F_20170928-225125D|remove archive"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: expire command begin 1.23: --log-level-console=detail --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=1 --retention-archive-type=diff --retention-diff=2 --retention-full=2 --stanza=demo",
- "P00 DETAIL: archive retention on backup 20170903-212930F, archiveId = 9.5-1, start = 000000020000000000000009, stop = 000000020000000000000009",
- "P00 DETAIL: archive retention on backup 20170903-212937F, archiveId = 9.5-1, start = 00000002000000000000000A, stop = 00000002000000000000000A",
- "P00 DETAIL: archive retention on backup 20170903-212937F_20170903-212956D, archiveId = 9.5-1, start = 00000002000000000000000D, stop = 00000002000000000000000D",
- "P00 DETAIL: archive retention on backup 20170903-212937F_20170903-213002D, archiveId = 9.5-1, start = 000000020000000000000010",
- "P00 DETAIL: remove archive: archiveId = 9.5-1, start = 00000002000000000000000B, stop = 00000002000000000000000C",
- "P00 DETAIL: remove archive: archiveId = 9.5-1, start = 00000002000000000000000E, stop = 00000002000000000000000F",
+ "P00 INFO: expire command begin 1.24: --log-level-console=detail --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=1 --retention-archive-type=diff --retention-diff=2 --retention-full=2 --stanza=demo",
+ "P00 DETAIL: archive retention on backup 20170928-225100F, archiveId = 9.5-1, start = 00000002000000000000000A, stop = 00000002000000000000000A",
+ "P00 DETAIL: archive retention on backup 20170928-225107F, archiveId = 9.5-1, start = 00000002000000000000000B, stop = 00000002000000000000000B",
+ "P00 DETAIL: archive retention on backup 20170928-225107F_20170928-225125D, archiveId = 9.5-1, start = 00000002000000000000000F, stop = 00000002000000000000000F",
+ "P00 DETAIL: archive retention on backup 20170928-225107F_20170928-225130D, archiveId = 9.5-1, start = 000000020000000000000012",
+ "P00 DETAIL: remove archive: archiveId = 9.5-1, start = 00000002000000000000000C, stop = 00000002000000000000000E",
+ "P00 DETAIL: remove archive: archiveId = 9.5-1, start = 000000020000000000000010, stop = 000000020000000000000011",
"P00 INFO: expire command end: completed successfully"
]
}
@@ -1270,7 +1330,7 @@
"cmd" : [
"sudo service postgresql-9.5 stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1288,13 +1348,13 @@
"demo\\/PG_VERSION - exists and matches backup|check\\/clean db path|restore global\\/pg_control"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " [filtered 877 lines of output]",
+ " [filtered 878 lines of output]",
"P01 DETAIL: restore file /var/lib/pgsql/9.5/data/base/1/12211 - exists and is zero size (0B, 100%)",
"P00 INFO: write /var/lib/pgsql/9.5/data/recovery.conf",
"P00 INFO: restore global/pg_control (performed last to ensure aborted restores cannot be started)",
@@ -1307,7 +1367,7 @@
"cmd" : [
"sudo service postgresql-9.5 start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1315,9 +1375,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1327,7 +1387,7 @@
"cmd" : [
"sudo -u postgres psql -c \"create database test1;\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1342,7 +1402,7 @@
"cmd" : [
"sudo -u postgres psql -c \"create database test2;\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1357,7 +1417,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --type=incr backup"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1368,7 +1428,7 @@
"sudo -u postgres psql -c \"create table test1_table (id int); \\",
" insert into test1_table (id) values (1);\" test1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1384,7 +1444,7 @@
"sudo -u postgres psql -c \"create table test2_table (id int); \\",
" insert into test2_table (id) values (2);\" test2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1399,7 +1459,7 @@
"cmd" : [
"sudo -u postgres du -sh /var/lib/pgsql/9.5/data/base/16384"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1414,7 +1474,7 @@
"cmd" : [
"sudo service postgresql-9.5 stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1425,7 +1485,7 @@
"sudo -u postgres pgbackrest --stanza=demo --delta \\",
" --db-include=test2 restore"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1435,7 +1495,7 @@
"cmd" : [
"sudo service postgresql-9.5 start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1443,9 +1503,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1455,7 +1515,7 @@
"cmd" : [
"sudo -u postgres psql -c \"select * from test2_table;\" test2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1481,7 +1541,7 @@
"relation mapping file.*contains invalid data"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1496,7 +1556,7 @@
"cmd" : [
"sudo -u postgres du -sh /var/lib/pgsql/9.5/data/base/16384"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1511,7 +1571,7 @@
"cmd" : [
"sudo -u postgres psql -c \"drop database test1;\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1533,7 +1593,7 @@
"test2"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1554,7 +1614,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --type=diff backup"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1575,7 +1635,7 @@
"Important Data"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1593,13 +1653,13 @@
"cmd" : [
"sudo -u postgres psql -Atc \"select current_timestamp\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "2017-09-03 21:30:36.307009+00"
+ "2017-09-28 22:52:06.003712+00"
]
}
},
@@ -1619,7 +1679,7 @@
"does not exist"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1636,7 +1696,7 @@
"cmd" : [
"sudo service postgresql-9.5 stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1645,9 +1705,9 @@
"key" : {
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --delta \\",
- " --type=time \"--target=2017-09-03 21:30:36.307009+00\" restore"
+ " --type=time \"--target=2017-09-28 22:52:06.003712+00\" restore"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1657,7 +1717,7 @@
"cmd" : [
"sudo rm /var/lib/pgsql/9.5/data/pg_log/postgresql.log"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1674,14 +1734,14 @@
"recovery_target_time"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
"restore_command = '/usr/bin/pgbackrest --stanza=demo archive-get %f \"%p\"'",
- "recovery_target_time = '2017-09-03 21:30:36.307009+00'"
+ "recovery_target_time = '2017-09-28 22:52:06.003712+00'"
]
}
},
@@ -1690,7 +1750,7 @@
"cmd" : [
"sudo service postgresql-9.5 start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1698,9 +1758,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1717,7 +1777,7 @@
"Important Data"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1742,22 +1802,22 @@
"recovery stopping before|last completed transaction|starting point-in-time recovery"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "LOG: database system was interrupted; last known up at 2017-09-03 21:30:31 UTC",
- "LOG: starting point-in-time recovery to 2017-09-03 21:30:36.307009+00",
+ "LOG: database system was interrupted; last known up at 2017-09-28 22:52:00 UTC",
+ "LOG: starting point-in-time recovery to 2017-09-28 22:52:06.003712+00",
"LOG: restored log file \"00000004.history\" from archive",
- "LOG: restored log file \"000000040000000000000015\" from archive",
- "LOG: redo starts at 0/15000028",
- "LOG: consistent recovery state reached at 0/150000F8",
- "LOG: restored log file \"000000040000000000000016\" from archive",
- "LOG: recovery stopping before commit of transaction 627, time 2017-09-03 21:30:36.406358+00",
- "LOG: redo done at 0/1601CF08",
- "LOG: last completed transaction was at log time 2017-09-03 21:30:36.198516+00",
+ "LOG: restored log file \"000000040000000000000017\" from archive",
+ "LOG: redo starts at 0/17000028",
+ "LOG: consistent recovery state reached at 0/170000F8",
+ "LOG: restored log file \"000000040000000000000018\" from archive",
+ "LOG: recovery stopping before commit of transaction 627, time 2017-09-28 22:52:06.106591+00",
+ "LOG: redo done at 0/1801CF08",
+ "LOG: last completed transaction was at log time 2017-09-28 22:52:05.896582+00",
"LOG: selected new timeline ID: 5",
"LOG: restored log file \"00000004.history\" from archive",
" [filtered 3 lines of output]"
@@ -1780,7 +1840,7 @@
"does not exist"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1797,13 +1857,13 @@
"cmd" : [
"sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-212937F_20170903-213030D"
+ "20170928-225107F_20170928-225159D"
]
}
},
@@ -1812,7 +1872,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --type=incr backup"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1822,7 +1882,7 @@
"cmd" : [
"sudo service postgresql-9.5 stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1831,9 +1891,9 @@
"key" : {
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --delta \\",
- " --type=time \"--target=2017-09-03 21:30:36.307009+00\" restore"
+ " --type=time \"--target=2017-09-28 22:52:06.003712+00\" restore"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1843,7 +1903,7 @@
"cmd" : [
"sudo rm /var/lib/pgsql/9.5/data/pg_log/postgresql.log"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1853,7 +1913,7 @@
"cmd" : [
"sudo service postgresql-9.5 start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1861,9 +1921,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -1881,7 +1941,7 @@
"does not exist"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1905,20 +1965,20 @@
"starting point-in-time recovery|consistent recovery state reached"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "LOG: database system was interrupted; last known up at 2017-09-03 21:30:45 UTC",
- "LOG: starting point-in-time recovery to 2017-09-03 21:30:36.307009+00",
+ "LOG: database system was interrupted; last known up at 2017-09-28 22:52:15 UTC",
+ "LOG: starting point-in-time recovery to 2017-09-28 22:52:06.003712+00",
"LOG: restored log file \"00000005.history\" from archive",
- "LOG: restored log file \"000000050000000000000017\" from archive",
- "LOG: redo starts at 0/17000028",
- "LOG: consistent recovery state reached at 0/170000F8",
- "LOG: redo done at 0/170000F8",
- "LOG: restored log file \"000000050000000000000017\" from archive",
+ "LOG: restored log file \"000000050000000000000019\" from archive",
+ "LOG: redo starts at 0/19000028",
+ "LOG: consistent recovery state reached at 0/190000F8",
+ "LOG: redo done at 0/190000F8",
+ "LOG: restored log file \"000000050000000000000019\" from archive",
" [filtered 7 lines of output]"
]
}
@@ -1932,10 +1992,10 @@
"filter" : false,
"filter-context" : 2,
"list" : [
- "20170903-212937F_20170903-213030D"
+ "20170928-225107F_20170928-225159D"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -1945,47 +2005,47 @@
" status: ok",
"",
" db (current)",
- " wal archive min/max (9.5-1): 000000020000000000000009 / 000000050000000000000017",
+ " wal archive min/max (9.5-1): 00000002000000000000000A / 000000050000000000000019",
"",
- " full backup: 20170903-212930F",
- " timestamp start/stop: 2017-09-03 21:29:30 / 2017-09-03 21:29:36",
- " wal start/stop: 000000020000000000000009 / 000000020000000000000009",
- " database size: 20.7MB, backup size: 20.7MB",
+ " full backup: 20170928-225100F",
+ " timestamp start/stop: 2017-09-28 22:51:00 / 2017-09-28 22:51:06",
+ " wal start/stop: 00000002000000000000000A / 00000002000000000000000A",
+ " database size: 20.5MB, backup size: 20.5MB",
" repository size: 2.3MB, repository backup size: 2.3MB",
"",
- " full backup: 20170903-212937F",
- " timestamp start/stop: 2017-09-03 21:29:37 / 2017-09-03 21:29:43",
- " wal start/stop: 00000002000000000000000A / 00000002000000000000000A",
- " database size: 20.7MB, backup size: 20.7MB",
+ " full backup: 20170928-225107F",
+ " timestamp start/stop: 2017-09-28 22:51:07 / 2017-09-28 22:51:13",
+ " wal start/stop: 00000002000000000000000B / 00000002000000000000000B",
+ " database size: 20.5MB, backup size: 20.5MB",
" repository size: 2.3MB, repository backup size: 2.3MB",
"",
- " diff backup: 20170903-212937F_20170903-213002D",
- " timestamp start/stop: 2017-09-03 21:30:02 / 2017-09-03 21:30:06",
- " wal start/stop: 000000020000000000000010 / 000000020000000000000010",
- " database size: 20.7MB, backup size: 9.8KB",
- " repository size: 2.3MB, repository backup size: 945B",
- " backup reference list: 20170903-212937F",
+ " diff backup: 20170928-225107F_20170928-225130D",
+ " timestamp start/stop: 2017-09-28 22:51:30 / 2017-09-28 22:51:34",
+ " wal start/stop: 000000020000000000000012 / 000000020000000000000012",
+ " database size: 20.5MB, backup size: 9.9KB",
+ " repository size: 2.3MB, repository backup size: 957B",
+ " backup reference list: 20170928-225107F",
"",
- " incr backup: 20170903-212937F_20170903-213015I",
- " timestamp start/stop: 2017-09-03 21:30:15 / 2017-09-03 21:30:20",
- " wal start/stop: 000000030000000000000012 / 000000030000000000000012",
- " database size: 34.1MB, backup size: 13.5MB",
+ " incr backup: 20170928-225107F_20170928-225144I",
+ " timestamp start/stop: 2017-09-28 22:51:44 / 2017-09-28 22:51:49",
+ " wal start/stop: 000000030000000000000014 / 000000030000000000000014",
+ " database size: 33.9MB, backup size: 13.4MB",
" repository size: 3.9MB, repository backup size: 1.5MB",
- " backup reference list: 20170903-212937F",
+ " backup reference list: 20170928-225107F",
"",
- " diff backup: 20170903-212937F_20170903-213030D",
- " timestamp start/stop: 2017-09-03 21:30:30 / 2017-09-03 21:30:34",
- " wal start/stop: 000000040000000000000015 / 000000040000000000000015",
- " database size: 27.5MB, backup size: 7MB",
- " repository size: 3.1MB, repository backup size: 838.6KB",
- " backup reference list: 20170903-212937F",
+ " diff backup: 20170928-225107F_20170928-225159D",
+ " timestamp start/stop: 2017-09-28 22:51:59 / 2017-09-28 22:52:04",
+ " wal start/stop: 000000040000000000000017 / 000000040000000000000017",
+ " database size: 27.2MB, backup size: 6.7MB",
+ " repository size: 3.1MB, repository backup size: 809.2KB",
+ " backup reference list: 20170928-225107F",
"",
- " incr backup: 20170903-212937F_20170903-213044I",
- " timestamp start/stop: 2017-09-03 21:30:44 / 2017-09-03 21:30:47",
- " wal start/stop: 000000050000000000000017 / 000000050000000000000017",
- " database size: 27.4MB, backup size: 2.1MB",
- " repository size: 3.1MB, repository backup size: 223.7KB",
- " backup reference list: 20170903-212937F, 20170903-212937F_20170903-213030D"
+ " incr backup: 20170928-225107F_20170928-225214I",
+ " timestamp start/stop: 2017-09-28 22:52:14 / 2017-09-28 22:52:18",
+ " wal start/stop: 000000050000000000000019 / 000000050000000000000019",
+ " database size: 27.2MB, backup size: 2MB",
+ " repository size: 3.1MB, repository backup size: 208KB",
+ " backup reference list: 20170928-225107F, 20170928-225107F_20170928-225159D"
]
}
},
@@ -1994,7 +2054,7 @@
"cmd" : [
"sudo service postgresql-9.5 stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -2003,10 +2063,10 @@
"key" : {
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --delta \\",
- " --type=time \"--target=2017-09-03 21:30:36.307009+00\" \\",
- " --set=20170903-212937F_20170903-213030D restore"
+ " --type=time \"--target=2017-09-28 22:52:06.003712+00\" \\",
+ " --set=20170928-225107F_20170928-225159D restore"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -2016,7 +2076,7 @@
"cmd" : [
"sudo rm /var/lib/pgsql/9.5/data/pg_log/postgresql.log"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -2026,7 +2086,7 @@
"cmd" : [
"sudo service postgresql-9.5 start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -2034,9 +2094,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -2053,7 +2113,7 @@
"Important Data"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -2078,22 +2138,22 @@
"recovery stopping before|last completed transaction|starting point-in-time recovery"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "LOG: database system was interrupted; last known up at 2017-09-03 21:30:31 UTC",
- "LOG: starting point-in-time recovery to 2017-09-03 21:30:36.307009+00",
+ "LOG: database system was interrupted; last known up at 2017-09-28 22:52:00 UTC",
+ "LOG: starting point-in-time recovery to 2017-09-28 22:52:06.003712+00",
"LOG: restored log file \"00000004.history\" from archive",
- "LOG: restored log file \"000000040000000000000015\" from archive",
- "LOG: redo starts at 0/15000028",
- "LOG: consistent recovery state reached at 0/150000F8",
- "LOG: restored log file \"000000040000000000000016\" from archive",
- "LOG: recovery stopping before commit of transaction 627, time 2017-09-03 21:30:36.406358+00",
- "LOG: redo done at 0/1601CF08",
- "LOG: last completed transaction was at log time 2017-09-03 21:30:36.198516+00",
+ "LOG: restored log file \"000000040000000000000017\" from archive",
+ "LOG: redo starts at 0/17000028",
+ "LOG: consistent recovery state reached at 0/170000F8",
+ "LOG: restored log file \"000000040000000000000018\" from archive",
+ "LOG: recovery stopping before commit of transaction 627, time 2017-09-28 22:52:06.106591+00",
+ "LOG: redo done at 0/1801CF08",
+ "LOG: last completed transaction was at log time 2017-09-28 22:52:05.896582+00",
"LOG: restored log file \"00000005.history\" from archive",
"LOG: restored log file \"00000006.history\" from archive",
" [filtered 5 lines of output]"
@@ -2103,7 +2163,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"process-max" : {
@@ -2164,7 +2224,7 @@
"sudo echo \"172.17.0.2 demo-bucket.s3.amazonaws.com s3.amazonaws.com\" | \\",
" sudo tee -a /etc/hosts"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -2174,7 +2234,7 @@
"cmd" : [
"aws s3 --no-verify-ssl mb s3://demo-bucket 2>&1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -2191,13 +2251,13 @@
"completed successfully"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: stanza-create command begin 1.23: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --no-log-timestamp --repo-path=/ --repo-s3-bucket=demo-bucket --repo-s3-endpoint=s3.amazonaws.com --repo-s3-region=us-east-1 --no-repo-s3-verify-ssl --repo-type=s3 --stanza=demo",
+ "P00 INFO: stanza-create command begin 1.24: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --no-log-timestamp --repo-path=/ --repo-s3-bucket=demo-bucket --repo-s3-endpoint=s3.amazonaws.com --repo-s3-region=us-east-1 --no-repo-s3-verify-ssl --repo-type=s3 --stanza=demo",
"P00 INFO: stanza-create command end: completed successfully"
]
}
@@ -2215,29 +2275,29 @@
"no prior backup exists|full backup size"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --process-max=4 --repo-path=/ --repo-s3-bucket=demo-bucket --repo-s3-endpoint=s3.amazonaws.com --repo-s3-region=us-east-1 --no-repo-s3-verify-ssl --repo-type=s3 --retention-diff=2 --retention-full=2 --stanza=demo --start-fast --stop-auto",
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --process-max=4 --repo-path=/ --repo-s3-bucket=demo-bucket --repo-s3-endpoint=s3.amazonaws.com --repo-s3-region=us-east-1 --no-repo-s3-verify-ssl --repo-type=s3 --retention-diff=2 --retention-full=2 --stanza=demo --start-fast --stop-auto",
"P00 WARN: no prior backup exists, incr backup has been changed to full",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:31:06\": backup begins after the requested immediate checkpoint completes",
- "P00 INFO: backup start archive = 000000070000000000000017, lsn = 0/17000028",
- " [filtered 1122 lines of output]",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:52:39\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup start archive = 000000070000000000000019, lsn = 0/19000028",
+ " [filtered 1119 lines of output]",
"P01 INFO: backup file /var/lib/pgsql/9.5/data/base/1/12216 (0B, 100%)",
"P03 INFO: backup file /var/lib/pgsql/9.5/data/base/1/12211 (0B, 100%)",
- "P00 INFO: full backup size = 27.4MB",
+ "P00 INFO: full backup size = 27.3MB",
"P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
- "P00 INFO: backup stop archive = 000000070000000000000017, lsn = 0/17000130",
+ "P00 INFO: backup stop archive = 000000070000000000000019, lsn = 0/19000130",
" [filtered 4 lines of output]"
]
}
},
{
"key" : {
- "image" : "pgbackrest/test:co6-doc-backup",
+ "image" : "pgbackrest/test:co6-base",
"name" : "backup",
"os" : "co6"
},
@@ -2248,120 +2308,42 @@
},
{
"key" : {
- "file" : "/etc/pgbackrest.conf",
+ "cmd" : [
+ "sudo groupadd backrest"
+ ],
"host" : "backup",
- "option" : {
- "global" : {
- "repo-path" : {
- "value" : "/var/lib/pgbackrest"
- }
- }
- }
+ "output" : false
},
- "type" : "cfg-pgbackrest",
- "value" : {
- "config" : [
- "[global]",
- "repo-path=/var/lib/pgbackrest"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
- "file" : "/etc/pgbackrest.conf",
+ "cmd" : [
+ "sudo adduser -gbackrest -n backrest"
+ ],
"host" : "backup",
- "option" : {
- "demo" : {
- "db1-host" : {
- "value" : "db-master"
- },
- "db1-path" : {
- "value" : "/var/lib/pgsql/9.5/data"
- },
- "db1-user" : {
- "value" : "postgres"
- }
- },
- "global" : {
- "log-level-stderr" : {
- "value" : "off"
- },
- "log-timestamp" : {
- "value" : "n"
- },
- "retention-full" : {
- "value" : "2"
- },
- "start-fast" : {
- "value" : "y"
- }
- }
- }
+ "output" : false
},
- "type" : "cfg-pgbackrest",
- "value" : {
- "config" : [
- "[demo]",
- "db1-host=db-master",
- "db1-path=/var/lib/pgsql/9.5/data",
- "db1-user=postgres",
- "",
- "[global]",
- "repo-path=/var/lib/pgbackrest",
- "retention-full=2",
- "start-fast=y"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
- "file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
- "option" : {
- "demo" : {
- "db-path" : {
- "value" : "/var/lib/pgsql/9.5/data"
- }
- },
- "global" : {
- "backup-host" : {
- "value" : "backup"
- },
- "backup-user" : {
- "value" : "backrest"
- },
- "log-level-file" : {
- "value" : "detail"
- },
- "log-level-stderr" : {
- "value" : "off"
- },
- "log-timestamp" : {
- "value" : "n"
- }
- }
- },
- "reset" : true
+ "cmd" : [
+ "sudo yum install perl perl-Time-HiRes perl-parent perl-JSON \\",
+ " perl-Digest-SHA perl-DBD-Pg perl-XML-LibXML perl-IO-Socket-SSL"
+ ],
+ "cmd-extra" : "-y",
+ "host" : "backup",
+ "output" : false
},
- "type" : "cfg-pgbackrest",
- "value" : {
- "config" : [
- "[demo]",
- "db-path=/var/lib/pgsql/9.5/data",
- "",
- "[global]",
- "backup-host=backup",
- "backup-user=backrest",
- "log-level-file=detail"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo find /var/lib/pgbackrest -delete"
+ "sudo mkdir /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -2369,54 +2351,49 @@
{
"key" : {
"cmd" : [
- "sudo -u backrest pgbackrest --stanza=demo stanza-create"
+ "sudo cp -r /backrest/bin /root/pgbackrest-release-1.24"
],
"host" : "backup",
- "output" : true
+ "output" : false
},
"type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo check"
+ "sudo cp -r /backrest/build /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
- "output" : true
+ "host" : "backup",
+ "output" : false
},
"type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u backrest pgbackrest --stanza=demo check"
+ "sudo cp -r /backrest/lib /root/pgbackrest-release-1.24"
],
"host" : "backup",
- "output" : true
+ "output" : false
},
"type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u backrest pgbackrest --stanza=demo backup"
+ "sudo cp -r /backrest/libc /root/pgbackrest-release-1.24"
],
"host" : "backup",
- "output" : true
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- "P00 WARN: no prior backup exists, incr backup has been changed to full"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo service postgresql-9.5 stop"
+ "sudo cp -r /backrest/src /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -2424,9 +2401,10 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --delta restore"
+ "sudo cp -r /root/pgbackrest-release-1.24/lib/pgBackRest \\",
+ " /usr/share/perl5"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -2434,9 +2412,9 @@
{
"key" : {
"cmd" : [
- "sudo service postgresql-9.5 start"
+ "sudo find /usr/share/perl5/pgBackRest -type f -exec chmod 644 {} +"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -2444,9 +2422,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo find /usr/share/perl5/pgBackRest -type d -exec chmod 755 {} +"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -2454,7 +2432,7 @@
{
"key" : {
"cmd" : [
- "sudo -u backrest pgbackrest --stanza=demo backup"
+ "sudo cp /root/pgbackrest-release-1.24/bin/pgbackrest /usr/bin/pgbackrest"
],
"host" : "backup",
"output" : false
@@ -2464,9 +2442,9 @@
{
"key" : {
"cmd" : [
- "sudo mkdir -m 750 /var/spool/pgbackrest"
+ "sudo chmod 755 /usr/bin/pgbackrest"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -2474,32 +2452,421 @@
{
"key" : {
"cmd" : [
- "sudo chown postgres:postgres /var/spool/pgbackrest"
+ "sudo mkdir -m 770 /var/log/pgbackrest"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
},
{
"key" : {
- "file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
- "option" : {
- "global" : {
- "archive-async" : {
- "value" : "y"
- },
- "spool-path" : {
- "value" : "/var/spool/pgbackrest"
- }
- },
- "global:archive-push" : {
- "process-max" : {
- "value" : "2"
- }
- }
- }
+ "cmd" : [
+ "sudo chown backrest:backrest /var/log/pgbackrest"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo touch /etc/pgbackrest.conf"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chmod 640 /etc/pgbackrest.conf"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chown backrest:backrest /etc/pgbackrest.conf"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo mkdir /var/lib/pgbackrest"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chmod 750 /var/lib/pgbackrest"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chown backrest:backrest /var/lib/pgbackrest"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u backrest mkdir -m 750 /home/backrest/.ssh"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u backrest ssh-keygen -f /home/backrest/.ssh/id_rsa -t rsa -b 4096 -N \"\""
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres mkdir -m 750 -p /home/postgres/.ssh"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres ssh-keygen -f /home/postgres/.ssh/id_rsa -t rsa -b 4096 -N \"\""
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo ssh root@db-primary cat /home/postgres/.ssh/id_rsa.pub | \\",
+ " sudo -u backrest tee -a /home/backrest/.ssh/authorized_keys"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo ssh root@backup cat /home/backrest/.ssh/id_rsa.pub | \\",
+ " sudo -u postgres tee -a /home/postgres/.ssh/authorized_keys"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u backrest ssh postgres@db-primary"
+ ],
+ "cmd-extra" : "-o StrictHostKeyChecking=no ls",
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres ssh backrest@backup"
+ ],
+ "cmd-extra" : "-o StrictHostKeyChecking=no ls",
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "file" : "/etc/pgbackrest.conf",
+ "host" : "backup",
+ "option" : {
+ "global" : {
+ "repo-path" : {
+ "value" : "/var/lib/pgbackrest"
+ }
+ }
+ }
+ },
+ "type" : "cfg-pgbackrest",
+ "value" : {
+ "config" : [
+ "[global]",
+ "repo-path=/var/lib/pgbackrest"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "file" : "/etc/pgbackrest.conf",
+ "host" : "backup",
+ "option" : {
+ "demo" : {
+ "db1-host" : {
+ "value" : "db-primary"
+ },
+ "db1-path" : {
+ "value" : "/var/lib/pgsql/9.5/data"
+ },
+ "db1-user" : {
+ "value" : "postgres"
+ }
+ },
+ "global" : {
+ "log-level-stderr" : {
+ "value" : "off"
+ },
+ "log-timestamp" : {
+ "value" : "n"
+ },
+ "retention-full" : {
+ "value" : "2"
+ },
+ "start-fast" : {
+ "value" : "y"
+ }
+ }
+ }
+ },
+ "type" : "cfg-pgbackrest",
+ "value" : {
+ "config" : [
+ "[demo]",
+ "db1-host=db-primary",
+ "db1-path=/var/lib/pgsql/9.5/data",
+ "db1-user=postgres",
+ "",
+ "[global]",
+ "repo-path=/var/lib/pgbackrest",
+ "retention-full=2",
+ "start-fast=y"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "file" : "/etc/pgbackrest.conf",
+ "host" : "db-primary",
+ "option" : {
+ "demo" : {
+ "db-path" : {
+ "value" : "/var/lib/pgsql/9.5/data"
+ }
+ },
+ "global" : {
+ "backup-host" : {
+ "value" : "backup"
+ },
+ "backup-user" : {
+ "value" : "backrest"
+ },
+ "log-level-file" : {
+ "value" : "detail"
+ },
+ "log-level-stderr" : {
+ "value" : "off"
+ },
+ "log-timestamp" : {
+ "value" : "n"
+ }
+ }
+ },
+ "reset" : true
+ },
+ "type" : "cfg-pgbackrest",
+ "value" : {
+ "config" : [
+ "[demo]",
+ "db-path=/var/lib/pgsql/9.5/data",
+ "",
+ "[global]",
+ "backup-host=backup",
+ "backup-user=backrest",
+ "log-level-file=detail"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo find /var/lib/pgbackrest -delete"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u backrest pgbackrest --stanza=demo stanza-create"
+ ],
+ "host" : "backup",
+ "output" : true
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo check"
+ ],
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u backrest pgbackrest --stanza=demo check"
+ ],
+ "host" : "backup",
+ "output" : true
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u backrest pgbackrest --stanza=demo backup"
+ ],
+ "host" : "backup",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ "P00 WARN: no prior backup exists, incr backup has been changed to full"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo service postgresql-9.5 stop"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --delta restore"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo service postgresql-9.5 start"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres sleep 2"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u backrest pgbackrest --stanza=demo backup"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo mkdir -m 750 /var/spool/pgbackrest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chown postgres:postgres /var/spool/pgbackrest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "file" : "/etc/pgbackrest.conf",
+ "host" : "db-primary",
+ "option" : {
+ "global" : {
+ "archive-async" : {
+ "value" : "y"
+ },
+ "spool-path" : {
+ "value" : "/var/spool/pgbackrest"
+ }
+ },
+ "global:archive-push" : {
+ "process-max" : {
+ "value" : "2"
+ }
+ }
+ }
},
"type" : "cfg-pgbackrest",
"value" : {
@@ -2524,7 +2891,7 @@
"cmd" : [
"sudo -u postgres rm -f /var/log/pgbackrest/demo-archive-async.log"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -2539,7 +2906,7 @@
" select pg_create_restore_point('test async push'); select pg_switch_xlog(); \\",
" select pg_create_restore_point('test async push'); select pg_switch_xlog();\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -2556,14 +2923,14 @@
"WAL segment"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: check command begin 1.23: --backup-host=backup --backup-user=backrest --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-file=detail --log-level-stderr=off --no-log-timestamp --stanza=demo",
- "P00 INFO: WAL segment 000000080000000000000022 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.5-1/0000000800000000/000000080000000000000022-d1b35a5dc89483916d8d0c0672054b5ac6ff479e.gz'",
+ "P00 INFO: check command begin 1.24: --backup-host=backup --backup-user=backrest --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-file=detail --log-level-stderr=off --no-log-timestamp --stanza=demo",
+ "P00 INFO: WAL segment 000000080000000000000024 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.5-1/0000000800000000/000000080000000000000024-256af425d02585173fcee6c52f7beff872a1e93d.gz'",
"P00 INFO: check command end: completed successfully"
]
}
@@ -2580,26 +2947,31 @@
" WAL file\\(s\\) to archive|pushed WAL file 0000000"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
"-------------------PROCESS START-------------------",
- "P00 INFO: archive-push command begin 1.23: --archive-async --backup-host=backup --backup-user=backrest --db1-path=/var/lib/pgsql/9.5/data --log-level-file=detail --log-level-stderr=off --no-log-timestamp --process-max=2 --spool-path=/var/spool/pgbackrest --stanza=demo",
- "P00 INFO: push 3 WAL file(s) to archive: 00000008000000000000001D...00000008000000000000001F",
- "P01 DETAIL: pushed WAL file 00000008000000000000001D to archive",
- "P02 DETAIL: pushed WAL file 00000008000000000000001E to archive",
+ "P00 INFO: archive-push command begin 1.24: --archive-async --backup-host=backup --backup-user=backrest --db1-path=/var/lib/pgsql/9.5/data --log-level-file=detail --log-level-stderr=off --no-log-timestamp --process-max=2 --spool-path=/var/spool/pgbackrest --stanza=demo",
+ "P00 INFO: push 2 WAL file(s) to archive: 00000008000000000000001F...000000080000000000000020",
"P01 DETAIL: pushed WAL file 00000008000000000000001F to archive",
+ "P02 DETAIL: pushed WAL file 000000080000000000000020 to archive",
+ "P00 INFO: archive-push command end: completed successfully",
+ "",
+ "-------------------PROCESS START-------------------",
+ "P00 INFO: archive-push command begin 1.24: --archive-async --backup-host=backup --backup-user=backrest --db1-path=/var/lib/pgsql/9.5/data --log-level-file=detail --log-level-stderr=off --no-log-timestamp --process-max=2 --spool-path=/var/spool/pgbackrest --stanza=demo",
+ "P00 INFO: push 3 WAL file(s) to archive: 000000080000000000000021...000000080000000000000023",
+ "P02 DETAIL: pushed WAL file 000000080000000000000022 to archive",
+ "P01 DETAIL: pushed WAL file 000000080000000000000021 to archive",
+ "P02 DETAIL: pushed WAL file 000000080000000000000023 to archive",
"P00 INFO: archive-push command end: completed successfully",
"",
"-------------------PROCESS START-------------------",
- "P00 INFO: archive-push command begin 1.23: --archive-async --backup-host=backup --backup-user=backrest --db1-path=/var/lib/pgsql/9.5/data --log-level-file=detail --log-level-stderr=off --no-log-timestamp --process-max=2 --spool-path=/var/spool/pgbackrest --stanza=demo",
- "P00 INFO: push 3 WAL file(s) to archive: 000000080000000000000020...000000080000000000000022",
- "P02 DETAIL: pushed WAL file 000000080000000000000021 to archive",
- "P01 DETAIL: pushed WAL file 000000080000000000000020 to archive",
- "P02 DETAIL: pushed WAL file 000000080000000000000022 to archive",
+ "P00 INFO: archive-push command begin 1.24: --archive-async --backup-host=backup --backup-user=backrest --db1-path=/var/lib/pgsql/9.5/data --log-level-file=detail --log-level-stderr=off --no-log-timestamp --process-max=2 --spool-path=/var/spool/pgbackrest --stanza=demo",
+ "P00 INFO: push 1 WAL file(s) to archive: 000000080000000000000024",
+ "P01 DETAIL: pushed WAL file 000000080000000000000024 to archive",
"P00 INFO: archive-push command end: completed successfully"
]
}
@@ -2658,7 +3030,7 @@
"value" : {
"config" : [
"[demo]",
- "db1-host=db-master",
+ "db1-host=db-primary",
"db1-path=/var/lib/pgsql/9.5/data",
"db1-user=postgres",
"",
@@ -2702,18 +3074,18 @@
" status: ok",
"",
" db (current)",
- " wal archive min/max (9.5-1): 000000080000000000000023 / 000000080000000000000024",
+ " wal archive min/max (9.5-1): 000000080000000000000025 / 000000080000000000000026",
"",
- " full backup: 20170903-213211F",
- " timestamp start/stop: 2017-09-03 21:32:11 / 2017-09-03 21:32:19",
- " wal start/stop: 000000080000000000000023 / 000000080000000000000023",
- " database size: 27.4MB, backup size: 27.4MB",
+ " full backup: 20170928-225352F",
+ " timestamp start/stop: 2017-09-28 22:53:52 / 2017-09-28 22:54:01",
+ " wal start/stop: 000000080000000000000025 / 000000080000000000000025",
+ " database size: 27.3MB, backup size: 27.3MB",
" repository size: 3.1MB, repository backup size: 3.1MB",
"",
- " full backup: 20170903-213222F",
- " timestamp start/stop: 2017-09-03 21:32:22 / 2017-09-03 21:32:28",
- " wal start/stop: 000000080000000000000024 / 000000080000000000000024",
- " database size: 27.4MB, backup size: 27.4MB",
+ " full backup: 20170928-225403F",
+ " timestamp start/stop: 2017-09-28 22:54:03 / 2017-09-28 22:54:10",
+ " wal start/stop: 000000080000000000000026 / 000000080000000000000026",
+ " database size: 27.3MB, backup size: 27.3MB",
" repository size: 3.1MB, repository backup size: 3.1MB"
]
}
@@ -2723,7 +3095,7 @@
"cmd" : [
"sudo -u postgres pgbackrest stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -2747,7 +3119,7 @@
"type" : "exe",
"value" : {
"output" : [
- "P00 ERROR: [062]: process 'db-master remote' terminated unexpectedly [062]: stop file exists for all stanzas",
+ "P00 ERROR: [062]: process 'db-primary remote' terminated unexpectedly [062]: stop file exists for all stanzas",
" "
]
}
@@ -2757,7 +3129,7 @@
"cmd" : [
"sudo -u postgres pgbackrest stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -2772,7 +3144,276 @@
"cmd" : [
"sudo -u postgres pgbackrest start"
],
- "host" : "db-master",
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo stop"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u backrest pgbackrest --stanza=demo backup"
+ ],
+ "err-expect" : "62",
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "process .* terminated unexpectedly.*: stop file exists for stanza demo"
+ ]
+ },
+ "host" : "backup",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ "P00 ERROR: [062]: process 'db-primary remote' terminated unexpectedly [062]: stop file exists for stanza demo",
+ " "
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo start"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "image" : "pgbackrest/test:co6-base",
+ "name" : "db-standby",
+ "os" : "co6"
+ },
+ "type" : "host",
+ "value" : {
+ "ip" : "172.17.0.5"
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo yum install perl perl-Time-HiRes perl-parent perl-JSON \\",
+ " perl-Digest-SHA perl-DBD-Pg perl-XML-LibXML perl-IO-Socket-SSL"
+ ],
+ "cmd-extra" : "-y",
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo mkdir /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/bin /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/build /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/lib /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/libc /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/src /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /root/pgbackrest-release-1.24/lib/pgBackRest \\",
+ " /usr/share/perl5"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo find /usr/share/perl5/pgBackRest -type f -exec chmod 644 {} +"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo find /usr/share/perl5/pgBackRest -type d -exec chmod 755 {} +"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp /root/pgbackrest-release-1.24/bin/pgbackrest /usr/bin/pgbackrest"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chmod 755 /usr/bin/pgbackrest"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo mkdir -m 770 /var/log/pgbackrest"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chown postgres:postgres /var/log/pgbackrest"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo touch /etc/pgbackrest.conf"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chmod 640 /etc/pgbackrest.conf"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chown postgres:postgres /etc/pgbackrest.conf"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo service postgresql-9.5 initdb"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres mkdir -m 750 -p /home/postgres/.ssh"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres ssh-keygen -f /home/postgres/.ssh/id_rsa -t rsa -b 4096 -N \"\""
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo ssh root@db-standby cat /home/postgres/.ssh/id_rsa.pub | \\",
+ " sudo -u backrest tee -a /home/backrest/.ssh/authorized_keys"
+ ],
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -2780,9 +3421,10 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo stop"
+ "sudo ssh root@backup cat /home/backrest/.ssh/id_rsa.pub | \\",
+ " sudo -u postgres tee -a /home/postgres/.ssh/authorized_keys"
],
- "host" : "db-master",
+ "host" : "db-standby",
"output" : false
},
"type" : "exe"
@@ -2790,48 +3432,25 @@
{
"key" : {
"cmd" : [
- "sudo -u backrest pgbackrest --stanza=demo backup"
+ "sudo -u backrest ssh postgres@db-standby"
],
- "err-expect" : "62",
- "highlight" : {
- "filter" : true,
- "filter-context" : 2,
- "list" : [
- "process .* terminated unexpectedly.*: stop file exists for stanza demo"
- ]
- },
+ "cmd-extra" : "-o StrictHostKeyChecking=no ls",
"host" : "backup",
- "output" : true
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- "P00 ERROR: [062]: process 'db-master remote' terminated unexpectedly [062]: stop file exists for stanza demo",
- " "
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo start"
+ "sudo -u postgres ssh backrest@backup"
],
- "host" : "db-master",
+ "cmd-extra" : "-o StrictHostKeyChecking=no ls",
+ "host" : "db-standby",
"output" : false
},
"type" : "exe"
},
- {
- "key" : {
- "image" : "pgbackrest/test:co6-doc-db",
- "name" : "db-standby",
- "os" : "co6"
- },
- "type" : "host",
- "value" : {
- "ip" : "172.17.0.5"
- }
- },
{
"key" : {
"file" : "/etc/pgbackrest.conf",
@@ -2936,7 +3555,7 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
"host" : "db-standby",
"output" : false
@@ -2961,12 +3580,12 @@
"type" : "exe",
"value" : {
"output" : [
- "LOG: database system was interrupted; last known up at 2017-09-03 21:32:22 UTC",
+ "LOG: database system was interrupted; last known up at 2017-09-28 22:54:04 UTC",
"LOG: entering standby mode",
"LOG: restored log file \"00000008.history\" from archive",
- "LOG: restored log file \"000000080000000000000024\" from archive",
- "LOG: redo starts at 0/24000028",
- "LOG: consistent recovery state reached at 0/240000F8",
+ "LOG: restored log file \"000000080000000000000026\" from archive",
+ "LOG: redo starts at 0/26000028",
+ "LOG: consistent recovery state reached at 0/260000F8",
"LOG: database system is ready to accept read only connections"
]
}
@@ -2988,7 +3607,7 @@
"Important Data"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -3031,15 +3650,15 @@
"cmd" : [
"sudo -u postgres psql -c \"select *, current_timestamp from pg_switch_xlog()\";"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " pg_switch_xlog | now ",
- "----------------+------------------------------",
- " 0/2501CDA8 | 2017-09-03 21:32:54.09532+00",
+ " pg_switch_xlog | now ",
+ "----------------+-------------------------------",
+ " 0/2701CDA8 | 2017-09-28 22:54:31.601483+00",
"(1 row)"
]
}
@@ -3065,7 +3684,7 @@
"output" : [
" message | now ",
"----------------+-------------------------------",
- " Important Data | 2017-09-03 21:32:56.986849+00",
+ " Important Data | 2017-09-28 22:54:33.480823+00",
"(1 row)"
]
}
@@ -3088,7 +3707,7 @@
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: check command begin 1.23: --backup-host=backup --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --stanza=demo",
+ "P00 INFO: check command begin 1.24: --backup-host=backup --db1-path=/var/lib/pgsql/9.5/data --log-level-console=info --log-level-stderr=off --no-log-timestamp --stanza=demo",
"P00 INFO: switch xlog cannot be performed on the standby, all other checks passed successfully",
"P00 INFO: check command end: completed successfully"
]
@@ -3100,7 +3719,7 @@
"sudo -u postgres psql -c \" \\",
" create user replicator password 'jw8s0F4' replication\";"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -3117,7 +3736,7 @@
" \"host replication replicator 172.17.0.5/32 md5\" \\",
" >> /var/lib/pgsql/9.5/data/pg_hba.conf'"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3127,7 +3746,7 @@
"cmd" : [
"sudo service postgresql-9.5 reload"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3256,7 +3875,7 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
"host" : "db-standby",
"output" : false
@@ -3283,8 +3902,8 @@
"output" : [
" [filtered 6 lines of output]",
"LOG: database system is ready to accept read only connections",
- "LOG: restored log file \"000000080000000000000025\" from archive",
- "LOG: started streaming WAL from primary at 0/26000000 on timeline 8"
+ "LOG: restored log file \"000000080000000000000027\" from archive",
+ "LOG: started streaming WAL from primary at 0/28000000 on timeline 8"
]
}
},
@@ -3305,7 +3924,7 @@
"Important Data"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -3313,7 +3932,7 @@
"output" : [
" message | now ",
"----------------+-------------------------------",
- " Important Data | 2017-09-03 21:33:06.907979+00",
+ " Important Data | 2017-09-28 22:54:44.505687+00",
"(1 row)"
]
}
@@ -3339,7 +3958,7 @@
"output" : [
" message | now ",
"----------------+-------------------------------",
- " Important Data | 2017-09-03 21:33:07.057257+00",
+ " Important Data | 2017-09-28 22:54:44.672567+00",
"(1 row)"
]
}
@@ -3371,7 +3990,7 @@
"value" : {
"config" : [
"[demo]",
- "db1-host=db-master",
+ "db1-host=db-primary",
"db1-path=/var/lib/pgsql/9.5/data",
"db1-user=postgres",
"db2-host=db-standby",
@@ -3396,7 +4015,7 @@
"filter" : true,
"filter-context" : 2,
"list" : [
- "backup file db-master|replay on the standby"
+ "backup file db-primary|replay on the standby"
]
},
"host" : "backup",
@@ -3406,19 +4025,17 @@
"value" : {
"output" : [
" [filtered 2 lines of output]",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:33:07\": backup begins after the requested immediate checkpoint completes",
- "P00 INFO: backup start archive = 000000080000000000000027, lsn = 0/27000028",
- "P00 INFO: wait for replay on the standby to reach 0/27000028",
- "P00 INFO: replay on the standby reached 0/270000D0",
- "P01 INFO: backup file db-master:/var/lib/pgsql/9.5/data/global/pg_control (8KB, 0%) checksum cae6dcb82397e2aef079c7b55d79f1b993a3426d",
- "P01 INFO: backup file db-master:/var/lib/pgsql/9.5/data/pg_log/postgresql.log (4.3KB, 0%) checksum 829fe4b9ee7a14762eb593bc8b13999c6847c917",
- "P03 INFO: backup file db-standby:/var/lib/pgsql/9.5/data/base/12378/2674 (360KB, 17%) checksum 307c758b88aefab6a9ce078aaa4595572785b8ab",
- "P01 INFO: backup file db-master:/var/lib/pgsql/9.5/data/pg_hba.conf (4.1KB, 17%) checksum dbda288edbce6486fab7ca9f9db0864316754bee",
- "P02 INFO: backup file db-standby:/var/lib/pgsql/9.5/data/base/12378/2608 (432KB, 37%) checksum c502d75d66d405d78f3263e4526558ec5bf9d9c6",
- "P01 INFO: backup file db-master:/var/lib/pgsql/9.5/data/backup_label (238B, 37%) checksum 19717911701f61c02469f54aaf35bab7e3ce7f3a",
- "P02 INFO: backup file db-standby:/var/lib/pgsql/9.5/data/base/12378/2658 (112KB, 42%) checksum 594c3456d99405c5f88f7bc7885c9cb1d640856d",
- "P03 INFO: backup file db-standby:/var/lib/pgsql/9.5/data/base/12378/2673 (320KB, 57%) checksum bf38f3496cb234793741c9750027ade909699b36",
- " [filtered 34 lines of output]"
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:54:45\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup start archive = 000000080000000000000029, lsn = 0/29000028",
+ "P00 INFO: wait for replay on the standby to reach 0/29000028",
+ "P00 INFO: replay on the standby reached 0/290000D0",
+ "P01 INFO: backup file db-primary:/var/lib/pgsql/9.5/data/global/pg_control (8KB, 0%) checksum fd7881f7eae2c9e9ac9119e623c97e8686d6bd61",
+ "P01 INFO: backup file db-primary:/var/lib/pgsql/9.5/data/pg_log/postgresql.log (4.3KB, 0%) checksum 2c50145cb3e4c13cdeba587af51c9d2d5805c172",
+ "P01 INFO: backup file db-primary:/var/lib/pgsql/9.5/data/pg_hba.conf (4.1KB, 0%) checksum dbda288edbce6486fab7ca9f9db0864316754bee",
+ "P01 INFO: backup file db-primary:/var/lib/pgsql/9.5/data/backup_label (238B, 0%) checksum da898b0184ecaf3891485189299e65e4f68de5bd",
+ "P03 INFO: backup file db-standby:/var/lib/pgsql/9.5/data/base/12378/2674 (360KB, 17%) checksum 98f713606bca2a3bf2f4150884f9707aad9aec4c",
+ "P04 INFO: backup file db-standby:/var/lib/pgsql/9.5/data/base/12378/1249 (360KB, 33%) checksum 8e8ade9b9d61cd6d8adc7518cb07eb2b35528274",
+ " [filtered 36 lines of output]"
]
}
},
@@ -3428,7 +4045,7 @@
"sudo yum install postgresql96-server"
],
"cmd-extra" : "-y",
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3438,7 +4055,7 @@
"cmd" : [
"sudo service postgresql-9.6 initdb"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -3474,7 +4091,7 @@
"cmd" : [
"sudo service postgresql-9.5 stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3498,7 +4115,7 @@
"Upgrade Complete"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -3517,7 +4134,7 @@
{
"key" : {
"file" : "/var/lib/pgsql/9.6/data/postgresql.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"archive_command" : {
"value" : "'pgbackrest --stanza=demo archive-push %p'"
@@ -3558,7 +4175,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"demo" : {
"db-path" : {
@@ -3634,7 +4251,7 @@
"value" : {
"config" : [
"[demo]",
- "db1-host=db-master",
+ "db1-host=db-primary",
"db1-path=/var/lib/pgsql/9.6/data",
"db1-user=postgres",
"db2-host=db-standby",
@@ -3656,7 +4273,7 @@
"sudo cp /var/lib/pgsql/9.5/data/pg_hba.conf \\",
" /var/lib/pgsql/9.6/data/pg_hba.conf"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3680,7 +4297,7 @@
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: stanza-upgrade command begin 1.23: --no-backup-standby --db1-host=db-master --db1-path=/var/lib/pgsql/9.6/data --db1-user=postgres --db2-host=db-standby --db2-path=/var/lib/pgsql/9.6/data --db2-user=postgres --log-level-console=info --no-log-timestamp --no-online --repo-path=/var/lib/pgbackrest --stanza=demo",
+ "P00 INFO: stanza-upgrade command begin 1.24: --no-backup-standby --db1-host=db-primary --db1-path=/var/lib/pgsql/9.6/data --db1-user=postgres --db2-host=db-standby --db2-path=/var/lib/pgsql/9.6/data --db2-user=postgres --log-level-console=info --no-log-timestamp --no-online --repo-path=/var/lib/pgbackrest --stanza=demo",
"P00 INFO: stanza-upgrade command end: completed successfully"
]
}
@@ -3690,7 +4307,7 @@
"cmd" : [
"sudo service postgresql-9.6 start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -3705,13 +4322,13 @@
"cmd" : [
"sudo -u postgres service postgresql-9.6 status"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "postgresql-9.6 (pid 4415) is running..."
+ "postgresql-9.6 (pid 4473) is running..."
]
}
},
@@ -3720,7 +4337,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo check"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe"
@@ -3747,7 +4364,7 @@
"cmd" : [
"sudo rm -rf /var/lib/pgsql/9.5/data"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3827,7 +4444,7 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
"host" : "db-standby",
"output" : false
@@ -3850,7 +4467,7 @@
"value" : {
"config" : [
"[demo]",
- "db1-host=db-master",
+ "db1-host=db-primary",
"db1-path=/var/lib/pgsql/9.6/data",
"db1-user=postgres",
"db2-host=db-standby",
@@ -3885,8 +4502,8 @@
},
{
"key" : {
- "image" : "pgbackrest/test:u16-doc-db",
- "name" : "db-master",
+ "image" : "pgbackrest/test:u16-base",
+ "name" : "db-primary",
"os" : "u16"
},
"type" : "host",
@@ -3894,13 +4511,73 @@
"ip" : "172.17.0.3"
}
},
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -f /usr/bin/pgbackrest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -f /usr/bin/pg_backrest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -rf /usr/lib/perl5/BackRest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -rf /usr/share/perl5/BackRest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -rf /usr/lib/perl5/pgBackRest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm -rf /usr/share/perl5/pgBackRest"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
{
"key" : {
"cmd" : [
"sudo apt-get install libdbd-pg-perl libio-socket-ssl-perl libxml-libxml-perl"
],
"cmd-extra" : "-y 2>&1",
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3908,9 +4585,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -f /usr/bin/pgbackrest"
+ "sudo mkdir /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3918,9 +4595,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -f /usr/bin/pg_backrest"
+ "sudo cp -r /backrest/bin /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3928,9 +4605,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -rf /usr/lib/perl5/BackRest"
+ "sudo cp -r /backrest/build /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3938,9 +4615,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -rf /usr/share/perl5/BackRest"
+ "sudo cp -r /backrest/lib /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3948,9 +4625,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -rf /usr/lib/perl5/pgBackRest"
+ "sudo cp -r /backrest/libc /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3958,9 +4635,9 @@
{
"key" : {
"cmd" : [
- "sudo rm -rf /usr/share/perl5/pgBackRest"
+ "sudo cp -r /backrest/src /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3968,10 +4645,10 @@
{
"key" : {
"cmd" : [
- "sudo cp -r /root/pgbackrest-release-1.23/lib/pgBackRest \\",
+ "sudo cp -r /root/pgbackrest-release-1.24/lib/pgBackRest \\",
" /usr/share/perl5"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3981,7 +4658,7 @@
"cmd" : [
"sudo find /usr/share/perl5/pgBackRest -type f -exec chmod 644 {} +"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3991,7 +4668,7 @@
"cmd" : [
"sudo find /usr/share/perl5/pgBackRest -type d -exec chmod 755 {} +"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -3999,9 +4676,9 @@
{
"key" : {
"cmd" : [
- "sudo cp /root/pgbackrest-release-1.23/bin/pgbackrest /usr/bin/pgbackrest"
+ "sudo cp /root/pgbackrest-release-1.24/bin/pgbackrest /usr/bin/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4011,7 +4688,7 @@
"cmd" : [
"sudo chmod 755 /usr/bin/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4021,7 +4698,7 @@
"cmd" : [
"sudo mkdir -m 770 /var/log/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4031,7 +4708,7 @@
"cmd" : [
"sudo chown postgres:postgres /var/log/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4041,7 +4718,7 @@
"cmd" : [
"sudo touch /etc/pgbackrest.conf"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4051,7 +4728,7 @@
"cmd" : [
"sudo chmod 640 /etc/pgbackrest.conf"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4061,7 +4738,7 @@
"cmd" : [
"sudo chown postgres:postgres /etc/pgbackrest.conf"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4071,13 +4748,13 @@
"cmd" : [
"sudo -u postgres pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "pgBackRest 1.23 - General help",
+ "pgBackRest 1.24 - General help",
"",
"Usage:",
" pgbackrest [options] [command]",
@@ -4107,7 +4784,7 @@
"sudo -u postgres /usr/lib/postgresql/9.4/bin/initdb \\",
" -D /var/lib/postgresql/9.4/demo -k -A peer"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4117,7 +4794,7 @@
"cmd" : [
"sudo pg_createcluster 9.4 demo"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -4132,7 +4809,7 @@
{
"key" : {
"file" : "/etc/postgresql/9.4/demo/postgresql.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"listen_addresses" : {
"value" : "'*'"
@@ -4149,7 +4826,7 @@
{
"key" : {
"file" : "/etc/postgresql/9.4/demo/postgresql.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"log_line_prefix" : {
"value" : "''"
@@ -4167,7 +4844,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"demo" : {
"db-path" : {
@@ -4197,7 +4874,7 @@
"cmd" : [
"sudo mkdir /var/lib/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4207,7 +4884,7 @@
"cmd" : [
"sudo chmod 750 /var/lib/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4217,7 +4894,7 @@
"cmd" : [
"sudo chown postgres:postgres /var/lib/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4225,7 +4902,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"repo-path" : {
@@ -4248,7 +4925,7 @@
{
"key" : {
"file" : "/etc/postgresql/9.4/demo/postgresql.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"archive_command" : {
"value" : "'pgbackrest --stanza=demo archive-push %p'"
@@ -4281,7 +4958,7 @@
"cmd" : [
"sudo pg_ctlcluster 9.4 demo restart"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4289,9 +4966,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4299,7 +4976,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"retention-full" : {
@@ -4332,13 +5009,13 @@
"completed successfully"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: stanza-create command begin 1.23: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --no-log-timestamp --repo-path=/var/lib/pgbackrest --stanza=demo",
+ "P00 INFO: stanza-create command begin 1.24: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --no-log-timestamp --repo-path=/var/lib/pgbackrest --stanza=demo",
"P00 INFO: stanza-create command end: completed successfully"
]
}
@@ -4355,14 +5032,14 @@
" successfully stored in the archive at "
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: check command begin 1.23: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --stanza=demo",
- "P00 INFO: WAL segment 000000010000000000000001 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000100000000/000000010000000000000001-7d20ff5ccb2c12584f1710a9a546f5afcc8e8ac5.gz'",
+ "P00 INFO: check command begin 1.24: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --stanza=demo",
+ "P00 INFO: WAL segment 000000010000000000000001 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000100000000/000000010000000000000001-54c49dc8193b3e3bacead5fd3e519383d774edb6.gz'",
"P00 INFO: check command end: completed successfully"
]
}
@@ -4380,20 +5057,20 @@
"no prior backup exists|full backup size"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo",
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo",
"P00 WARN: no prior backup exists, incr backup has been changed to full",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:34:27\": backup begins after the next regular checkpoint completes",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:56:08\": backup begins after the next regular checkpoint completes",
"P00 INFO: backup start archive = 000000010000000000000002, lsn = 0/2000028",
- " [filtered 757 lines of output]",
+ " [filtered 754 lines of output]",
"P01 INFO: backup file /var/lib/postgresql/9.4/demo/base/1/11895 (0B, 100%)",
"P01 INFO: backup file /var/lib/postgresql/9.4/demo/base/1/11885 (0B, 100%)",
- "P00 INFO: full backup size = 19.3MB",
+ "P00 INFO: full backup size = 19.2MB",
"P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
"P00 INFO: backup stop archive = 000000010000000000000002, lsn = 0/20000F0",
" [filtered 4 lines of output]"
@@ -4405,13 +5082,13 @@
"cmd" : [
"sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-213427F"
+ "20170928-225608F"
]
}
},
@@ -4428,18 +5105,18 @@
"diff backup size"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
" [filtered 4 lines of output]",
- "P01 INFO: backup file /var/lib/postgresql/9.4/demo/global/pg_control (8KB, 97%) checksum 9724470ec0b9e4f126a303d4845bf11d05eb6404",
- "P01 INFO: backup file /var/lib/postgresql/9.4/demo/backup_label (236B, 100%) checksum fb318e319e75661bf1d7954cf7a7eec88b9a16b4",
+ "P01 INFO: backup file /var/lib/postgresql/9.4/demo/global/pg_control (8KB, 97%) checksum 780487f8a1a001ee40192bec4c7c8bc2f2d7c21a",
+ "P01 INFO: backup file /var/lib/postgresql/9.4/demo/backup_label (236B, 100%) checksum 372012b196a890f28d401a5723dd92bbe4735146",
"P00 INFO: diff backup size = 8.2KB",
"P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
- "P00 INFO: backup stop archive = 000000010000000000000003, lsn = 0/30000F0",
+ "P00 INFO: backup stop archive = 000000010000000000000003, lsn = 0/3000128",
" [filtered 4 lines of output]"
]
}
@@ -4456,7 +5133,7 @@
"(full|incr|diff) backup"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -4468,18 +5145,18 @@
" db (current)",
" wal archive min/max (9.4-1): 000000010000000000000002 / 000000010000000000000003",
"",
- " full backup: 20170903-213427F",
- " timestamp start/stop: 2017-09-03 21:34:27 / 2017-09-03 21:34:32",
+ " full backup: 20170928-225608F",
+ " timestamp start/stop: 2017-09-28 22:56:08 / 2017-09-28 22:56:13",
" wal start/stop: 000000010000000000000002 / 000000010000000000000002",
- " database size: 19.3MB, backup size: 19.3MB",
+ " database size: 19.2MB, backup size: 19.2MB",
" repository size: 2.2MB, repository backup size: 2.2MB",
"",
- " diff backup: 20170903-213427F_20170903-213433D",
- " timestamp start/stop: 2017-09-03 21:34:33 / 2017-09-03 21:34:36",
+ " diff backup: 20170928-225608F_20170928-225614D",
+ " timestamp start/stop: 2017-09-28 22:56:14 / 2017-09-28 22:56:17",
" wal start/stop: 000000010000000000000003 / 000000010000000000000003",
- " database size: 19.3MB, backup size: 8.2KB",
- " repository size: 2.2MB, repository backup size: 344B",
- " backup reference list: 20170903-213427F"
+ " database size: 19.2MB, backup size: 8.2KB",
+ " repository size: 2.2MB, repository backup size: 345B",
+ " backup reference list: 20170928-225608F"
]
}
},
@@ -4488,7 +5165,7 @@
"cmd" : [
"sudo pg_ctlcluster 9.4 demo stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4498,7 +5175,7 @@
"cmd" : [
"sudo -u postgres rm /var/lib/postgresql/9.4/demo/global/pg_control"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4516,7 +5193,7 @@
"could not find the database system"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -4532,9 +5209,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4544,7 +5221,7 @@
"cmd" : [
"sudo -u postgres find /var/lib/postgresql/9.4/demo -mindepth 1 -delete"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4554,7 +5231,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo restore"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4564,7 +5241,7 @@
"cmd" : [
"sudo pg_ctlcluster 9.4 demo start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4572,9 +5249,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4592,25 +5269,25 @@
"backup begins after the next regular checkpoint completes"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --type=incr",
- "P00 INFO: last backup label = 20170903-213427F_20170903-213433D, version = 1.23",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:34:47\": backup begins after the next regular checkpoint completes",
- "P00 INFO: backup start archive = 000000020000000000000006, lsn = 0/6000028",
- "P01 INFO: backup file /var/lib/postgresql/9.4/demo/base/12139/pg_internal.init (115.2KB, 72%) checksum 0a8999bdda6c8b69a9eb2d34aac1c5e26eda47ea",
- " [filtered 13 lines of output]"
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --type=incr",
+ "P00 INFO: last backup label = 20170928-225608F_20170928-225614D, version = 1.24",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:56:28\": backup begins after the next regular checkpoint completes",
+ "P00 INFO: backup start archive = 000000020000000000000005, lsn = 0/5000028",
+ "P01 INFO: backup file /var/lib/postgresql/9.4/demo/pg_multixact/offsets/0000 (8KB, 33%) checksum 0631457264ff7f8d5fb1edc2c0211992a67c73e6",
+ " [filtered 10 lines of output]"
]
}
},
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"start-fast" : {
@@ -4645,17 +5322,17 @@
"backup begins after the requested immediate checkpoint completes"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --type=incr",
- "P00 INFO: last backup label = 20170903-213427F_20170903-213447I, version = 1.23",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:34:51\": backup begins after the requested immediate checkpoint completes",
- "P00 INFO: backup start archive = 000000020000000000000007, lsn = 0/7000028",
- "P01 INFO: backup file /var/lib/postgresql/9.4/demo/global/pg_control (8KB, 97%) checksum 09f403fce1c542666a9ef8982b4fb7fdc09ad877",
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --type=incr",
+ "P00 INFO: last backup label = 20170928-225608F_20170928-225628I, version = 1.24",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:56:33\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup start archive = 000000020000000000000006, lsn = 0/6000028",
+ "P01 INFO: backup file /var/lib/postgresql/9.4/demo/global/pg_control (8KB, 97%) checksum 2f6a5eadc88a61fc27443f302ccdcd9a70690fd6",
" [filtered 8 lines of output]"
]
}
@@ -4665,7 +5342,7 @@
"cmd" : [
"sudo chmod 550 /var/lib/pgbackrest/backup/demo/"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4684,16 +5361,16 @@
"ERROR:"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
" [filtered 2 lines of output]",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:34:55\": backup begins after the requested immediate checkpoint completes",
- "P00 INFO: backup start archive = 000000020000000000000008, lsn = 0/8000028",
- "P00 ERROR: [047]: unable to create path '/var/lib/pgbackrest/backup/demo/20170903-213427F_20170903-213455I': Permission denied",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:56:37\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup start archive = 000000020000000000000007, lsn = 0/7000028",
+ "P00 ERROR: [047]: unable to create path '/var/lib/pgbackrest/backup/demo/20170928-225608F_20170928-225637I': Permission denied",
"P00 INFO: backup command end: aborted with exception [047]"
]
}
@@ -4703,7 +5380,7 @@
"cmd" : [
"sudo chmod 750 /var/lib/pgbackrest/backup/demo/"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4722,25 +5399,25 @@
"ERROR:"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --type=incr",
- "P00 INFO: last backup label = 20170903-213427F_20170903-213451I, version = 1.23",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:34:57\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --type=incr",
+ "P00 INFO: last backup label = 20170928-225608F_20170928-225633I, version = 1.24",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:56:39\": backup begins after the requested immediate checkpoint completes",
"P00 ERROR: [057]: 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'), pg_xlogfile_name(lsn), lsn::text from pg_start_backup('pgBackRest backup started at 2017-09-03 21:34:57', true) as lsn"
+ " select to_char(current_timestamp, 'YYYY-MM-DD HH24:MI:SS.US TZ'), pg_xlogfile_name(lsn), lsn::text from pg_start_backup('pgBackRest backup started at 2017-09-28 22:56:39', true) as lsn"
]
}
},
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"stop-auto" : {
@@ -4766,40 +5443,228 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --type=incr \\",
+ "sudo -u postgres pgbackrest --stanza=demo --type=incr \\",
+ " --log-level-console=info backup"
+ ],
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "cluster is already in backup mode|backup begins after the requested immediate checkpoint completes"
+ ]
+ },
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --stop-auto --type=incr",
+ "P00 INFO: last backup label = 20170928-225608F_20170928-225633I, version = 1.24",
+ "P00 WARN: the cluster is already in backup mode but no pgBackRest backup process is running. pg_stop_backup() will be called so a new backup can be started.",
+ "P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:56:41\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup start archive = 000000020000000000000008, lsn = 0/8000028",
+ "P01 INFO: backup file /var/lib/postgresql/9.4/demo/global/pg_control (8KB, 97%) checksum e83ec411bacabe3684d79a7ffe98d2b18243b4be",
+ " [filtered 8 lines of output]"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "file" : "/etc/pgbackrest.conf",
+ "host" : "db-primary",
+ "option" : {
+ "global" : {
+ "retention-full" : {
+ "value" : "2"
+ }
+ }
+ }
+ },
+ "type" : "cfg-pgbackrest",
+ "value" : {
+ "config" : [
+ "[demo]",
+ "db-path=/var/lib/postgresql/9.4/demo",
+ "",
+ "[global]",
+ "repo-path=/var/lib/pgbackrest",
+ "retention-full=2",
+ "start-fast=y",
+ "stop-auto=y"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --type=full \\",
+ " --log-level-console=detail backup"
+ ],
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "archive retention on backup 20170928-225608F|remove archive"
+ ]
+ },
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ " [filtered 763 lines of output]",
+ "P00 INFO: backup command end: completed successfully",
+ "P00 INFO: expire command begin 1.24: --log-level-console=detail --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-full=2 --stanza=demo",
+ "P00 DETAIL: archive retention on backup 20170928-225608F, archiveId = 9.4-1, start = 000000010000000000000002",
+ "P00 DETAIL: no archive to remove, archiveId = 9.4-1",
+ "P00 INFO: expire command end: completed successfully"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
+ ],
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ "20170928-225646F"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --type=full \\",
+ " --log-level-console=info backup"
+ ],
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "expire full backup set\\: 20170928-225608F|archive retention on backup 20170928-225646F|remove archive"
+ ]
+ },
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ " [filtered 763 lines of output]",
+ "P00 INFO: backup command end: completed successfully",
+ "P00 INFO: expire command begin 1.24: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-full=2 --stanza=demo",
+ "P00 INFO: expire full backup set: 20170928-225608F, 20170928-225608F_20170928-225614D, 20170928-225608F_20170928-225628I, 20170928-225608F_20170928-225633I, 20170928-225608F_20170928-225641I",
+ "P00 INFO: remove expired backup 20170928-225608F_20170928-225641I",
+ "P00 INFO: remove expired backup 20170928-225608F_20170928-225633I",
+ " [filtered 3 lines of output]"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "file" : "/etc/pgbackrest.conf",
+ "host" : "db-primary",
+ "option" : {
+ "global" : {
+ "retention-diff" : {
+ "value" : "1"
+ }
+ }
+ }
+ },
+ "type" : "cfg-pgbackrest",
+ "value" : {
+ "config" : [
+ "[demo]",
+ "db-path=/var/lib/postgresql/9.4/demo",
+ "",
+ "[global]",
+ "repo-path=/var/lib/pgbackrest",
+ "retention-diff=1",
+ "retention-full=2",
+ "start-fast=y",
+ "stop-auto=y"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --type=diff backup"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
+ ],
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ "20170928-225652F_20170928-225700D"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --type=incr backup"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --type=diff \\",
" --log-level-console=info backup"
],
"highlight" : {
"filter" : true,
"filter-context" : 2,
"list" : [
- "cluster is already in backup mode|backup begins after the requested immediate checkpoint completes"
+ "expire diff backup set: 20170928-225652F_20170928-225700D"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-full=2 --stanza=demo --start-fast --stop-auto --type=incr",
- "P00 INFO: last backup label = 20170903-213427F_20170903-213451I, version = 1.23",
- "P00 WARN: the cluster is already in backup mode but no pgBackRest backup process is running. pg_stop_backup() will be called so a new backup can be started.",
- "P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:34:58\": backup begins after the requested immediate checkpoint completes",
- "P00 INFO: backup start archive = 000000020000000000000009, lsn = 0/9000028",
- "P01 INFO: backup file /var/lib/postgresql/9.4/demo/global/pg_control (8KB, 97%) checksum 8d583e9f1010cbb549b2326985b1de0092caea99",
- " [filtered 8 lines of output]"
+ " [filtered 10 lines of output]",
+ "P00 INFO: backup command end: completed successfully",
+ "P00 INFO: expire command begin 1.24: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-diff=1 --retention-full=2 --stanza=demo",
+ "P00 INFO: expire diff backup set: 20170928-225652F_20170928-225700D, 20170928-225652F_20170928-225704I",
+ "P00 INFO: remove expired backup 20170928-225652F_20170928-225704I",
+ "P00 INFO: remove expired backup 20170928-225652F_20170928-225700D"
]
}
},
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
- "retention-full" : {
+ "retention-diff" : {
"value" : "2"
}
}
@@ -4813,6 +5678,7 @@
"",
"[global]",
"repo-path=/var/lib/pgbackrest",
+ "retention-diff=2",
"retention-full=2",
"start-fast=y",
"stop-auto=y"
@@ -4822,28 +5688,55 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --type=full \\",
- " --log-level-console=detail backup"
+ "sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
+ ],
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ "20170928-225652F_20170928-225708D"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres psql -c \" \\",
+ " select pg_create_restore_point('generate WAL'); select pg_switch_xlog(); \\",
+ " select pg_create_restore_point('generate WAL'); select pg_switch_xlog();\""
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --type=diff \\",
+ " --log-level-console=info backup"
],
"highlight" : {
"filter" : true,
"filter-context" : 2,
"list" : [
- "archive retention on backup 20170903-213427F|remove archive"
+ "new backup label"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " [filtered 766 lines of output]",
+ " [filtered 7 lines of output]",
+ "P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
+ "P00 INFO: backup stop archive = 000000020000000000000011, lsn = 0/110000F0",
+ "P00 INFO: new backup label = 20170928-225652F_20170928-225713D",
"P00 INFO: backup command end: completed successfully",
- "P00 INFO: expire command begin 1.23: --log-level-console=detail --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-full=2 --stanza=demo",
- "P00 DETAIL: archive retention on backup 20170903-213427F, archiveId = 9.4-1, start = 000000010000000000000002",
- "P00 DETAIL: no archive to remove, archiveId = 9.4-1",
- "P00 INFO: expire command end: completed successfully"
+ "P00 INFO: expire command begin 1.24: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-diff=2 --retention-full=2 --stanza=demo"
]
}
},
@@ -4852,78 +5745,95 @@
"cmd" : [
"sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-213504F"
+ "20170928-225652F_20170928-225713D"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --type=full \\",
- " --log-level-console=info backup"
+ "sudo -u postgres pgbackrest --stanza=demo --log-level-console=detail \\",
+ " --retention-archive-type=diff --retention-archive=1 expire"
],
"highlight" : {
"filter" : true,
"filter-context" : 2,
"list" : [
- "expire full backup set\\: 20170903-213427F|archive retention on backup 20170903-213504F|remove archive"
+ "archive retention on backup 20170928-225652F_20170928-225708D|remove archive"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " [filtered 766 lines of output]",
- "P00 INFO: backup command end: completed successfully",
- "P00 INFO: expire command begin 1.23: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-full=2 --stanza=demo",
- "P00 INFO: expire full backup set: 20170903-213427F, 20170903-213427F_20170903-213433D, 20170903-213427F_20170903-213447I, 20170903-213427F_20170903-213451I, 20170903-213427F_20170903-213458I",
- "P00 INFO: remove expired backup 20170903-213427F_20170903-213458I",
- "P00 INFO: remove expired backup 20170903-213427F_20170903-213451I",
- " [filtered 3 lines of output]"
+ "P00 INFO: expire command begin 1.24: --log-level-console=detail --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=1 --retention-archive-type=diff --retention-diff=2 --retention-full=2 --stanza=demo",
+ "P00 DETAIL: archive retention on backup 20170928-225646F, archiveId = 9.4-1, start = 000000020000000000000009, stop = 000000020000000000000009",
+ "P00 DETAIL: archive retention on backup 20170928-225652F, archiveId = 9.4-1, start = 00000002000000000000000A, stop = 00000002000000000000000A",
+ "P00 DETAIL: archive retention on backup 20170928-225652F_20170928-225708D, archiveId = 9.4-1, start = 00000002000000000000000D, stop = 00000002000000000000000D",
+ "P00 DETAIL: archive retention on backup 20170928-225652F_20170928-225713D, archiveId = 9.4-1, start = 000000020000000000000011",
+ "P00 DETAIL: remove archive: archiveId = 9.4-1, start = 00000002000000000000000B, stop = 00000002000000000000000C",
+ "P00 DETAIL: remove archive: archiveId = 9.4-1, start = 00000002000000000000000E, stop = 000000020000000000000010",
+ "P00 INFO: expire command end: completed successfully"
]
}
},
{
"key" : {
- "file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
- "option" : {
- "global" : {
- "retention-diff" : {
- "value" : "1"
- }
- }
- }
+ "cmd" : [
+ "sudo pg_ctlcluster 9.4 demo stop"
+ ],
+ "host" : "db-primary",
+ "output" : false
},
- "type" : "cfg-pgbackrest",
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --delta \\",
+ " --log-level-console=detail restore"
+ ],
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "demo\\/PG_VERSION - exists and matches backup|check\\/clean db path|restore global\\/pg_control"
+ ]
+ },
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe",
"value" : {
- "config" : [
- "[demo]",
- "db-path=/var/lib/postgresql/9.4/demo",
- "",
- "[global]",
- "repo-path=/var/lib/pgbackrest",
- "retention-diff=1",
- "retention-full=2",
- "start-fast=y",
- "stop-auto=y"
+ "output" : [
+ " [filtered 692 lines of output]",
+ "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/base/12134/PG_VERSION - exists and matches backup (4B, 99%) checksum 8dbabb96e032b8d9f1993c0e4b9141e71ade01a1",
+ "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/base/1/PG_VERSION - exists and matches backup (4B, 99%) checksum 8dbabb96e032b8d9f1993c0e4b9141e71ade01a1",
+ "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/PG_VERSION - exists and matches backup (4B, 100%) checksum 8dbabb96e032b8d9f1993c0e4b9141e71ade01a1",
+ "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/global/12086 - exists and is zero size (0B, 100%)",
+ "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/global/12038 - exists and is zero size (0B, 100%)",
+ " [filtered 83 lines of output]",
+ "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/base/1/11885 - exists and is zero size (0B, 100%)",
+ "P00 INFO: write /var/lib/postgresql/9.4/demo/recovery.conf",
+ "P00 INFO: restore global/pg_control (performed last to ensure aborted restores cannot be started)",
+ "P00 INFO: restore command end: completed successfully"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --type=diff backup"
+ "sudo pg_ctlcluster 9.4 demo start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4931,15 +5841,40 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
+ "sudo -u postgres sleep 2"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres psql -c \"create database test1;\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-213510F_20170903-213517D"
+ "CREATE DATABASE"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres psql -c \"create database test2;\""
+ ],
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ "CREATE DATABASE"
]
}
},
@@ -4948,7 +5883,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --type=incr backup"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -4956,81 +5891,87 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --type=diff \\",
- " --log-level-console=info backup"
+ "sudo -u postgres psql -c \"create table test1_table (id int); \\",
+ " insert into test1_table (id) values (1);\" test1"
],
- "highlight" : {
- "filter" : true,
- "filter-context" : 2,
- "list" : [
- "expire diff backup set: 20170903-213510F_20170903-213517D"
- ]
- },
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " [filtered 10 lines of output]",
- "P00 INFO: backup command end: completed successfully",
- "P00 INFO: expire command begin 1.23: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-diff=1 --retention-full=2 --stanza=demo",
- "P00 INFO: expire diff backup set: 20170903-213510F_20170903-213517D, 20170903-213510F_20170903-213521I",
- "P00 INFO: remove expired backup 20170903-213510F_20170903-213521I",
- "P00 INFO: remove expired backup 20170903-213510F_20170903-213517D"
+ "INSERT 0 1"
]
}
},
{
"key" : {
- "file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
- "option" : {
- "global" : {
- "retention-diff" : {
- "value" : "2"
- }
- }
- }
+ "cmd" : [
+ "sudo -u postgres psql -c \"create table test2_table (id int); \\",
+ " insert into test2_table (id) values (2);\" test2"
+ ],
+ "host" : "db-primary",
+ "output" : true
},
- "type" : "cfg-pgbackrest",
+ "type" : "exe",
"value" : {
- "config" : [
- "[demo]",
- "db-path=/var/lib/postgresql/9.4/demo",
- "",
- "[global]",
- "repo-path=/var/lib/pgbackrest",
- "retention-diff=2",
- "retention-full=2",
- "start-fast=y",
- "stop-auto=y"
+ "output" : [
+ "INSERT 0 1"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
+ "sudo -u postgres du -sh /var/lib/postgresql/9.4/demo/base/16384"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-213510F_20170903-213525D"
+ "6.4M\t/var/lib/postgresql/9.4/demo/base/16384"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \" \\",
- " select pg_create_restore_point('generate WAL'); select pg_switch_xlog(); \\",
- " select pg_create_restore_point('generate WAL'); select pg_switch_xlog();\""
+ "sudo pg_ctlcluster 9.4 demo stop"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --delta \\",
+ " --db-include=test2 restore"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo pg_ctlcluster 9.4 demo start"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -5038,82 +5979,108 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --type=diff \\",
- " --log-level-console=info backup"
+ "sudo -u postgres psql -c \"select * from test2_table;\" test2"
+ ],
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ " id ",
+ "----",
+ " 2",
+ "(1 row)"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres psql -c \"select * from test1_table;\" test1"
+ ],
+ "err-expect" : "2",
+ "highlight" : {
+ "filter" : false,
+ "filter-context" : 2,
+ "list" : [
+ "relation mapping file.*contains invalid data"
+ ]
+ },
+ "host" : "db-primary",
+ "output" : true
+ },
+ "type" : "exe",
+ "value" : {
+ "output" : [
+ "psql: FATAL: relation mapping file \"base/16384/pg_filenode.map\" contains invalid data"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres du -sh /var/lib/postgresql/9.4/demo/base/16384"
],
- "highlight" : {
- "filter" : true,
- "filter-context" : 2,
- "list" : [
- "new backup label"
- ]
- },
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " [filtered 7 lines of output]",
- "P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
- "P00 INFO: backup stop archive = 000000020000000000000012, lsn = 0/120000F0",
- "P00 INFO: new backup label = 20170903-213510F_20170903-213530D",
- "P00 INFO: backup command end: completed successfully",
- "P00 INFO: expire command begin 1.23: --log-level-console=info --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=2 --retention-diff=2 --retention-full=2 --stanza=demo"
+ "152K\t/var/lib/postgresql/9.4/demo/base/16384"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
+ "sudo -u postgres psql -c \"drop database test1;\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-213510F_20170903-213530D"
+ "DROP DATABASE"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --log-level-console=detail \\",
- " --retention-archive-type=diff --retention-archive=1 expire"
+ "sudo -u postgres psql -c \"select oid, datname from pg_database order by oid;\""
],
"highlight" : {
- "filter" : true,
+ "filter" : false,
"filter-context" : 2,
"list" : [
- "archive retention on backup 20170903-213510F_20170903-213525D|remove archive"
+ "test2"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: expire command begin 1.23: --log-level-console=detail --log-level-stderr=off --no-log-timestamp --repo-path=/var/lib/pgbackrest --retention-archive=1 --retention-archive-type=diff --retention-diff=2 --retention-full=2 --stanza=demo",
- "P00 DETAIL: archive retention on backup 20170903-213504F, archiveId = 9.4-1, start = 00000002000000000000000A, stop = 00000002000000000000000A",
- "P00 DETAIL: archive retention on backup 20170903-213510F, archiveId = 9.4-1, start = 00000002000000000000000B, stop = 00000002000000000000000B",
- "P00 DETAIL: archive retention on backup 20170903-213510F_20170903-213525D, archiveId = 9.4-1, start = 00000002000000000000000E, stop = 00000002000000000000000E",
- "P00 DETAIL: archive retention on backup 20170903-213510F_20170903-213530D, archiveId = 9.4-1, start = 000000020000000000000012",
- "P00 DETAIL: remove archive: archiveId = 9.4-1, start = 00000002000000000000000C, stop = 00000002000000000000000D",
- "P00 DETAIL: remove archive: archiveId = 9.4-1, start = 00000002000000000000000F, stop = 000000020000000000000011",
- "P00 INFO: expire command end: completed successfully"
+ " oid | datname ",
+ "-------+-----------",
+ " 1 | template1",
+ " 12134 | template0",
+ " 12139 | postgres",
+ " 16385 | test2",
+ "(4 rows)"
]
}
},
{
"key" : {
"cmd" : [
- "sudo pg_ctlcluster 9.4 demo stop"
+ "sudo -u postgres pgbackrest --stanza=demo --type=diff backup"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -5121,92 +6088,81 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --delta \\",
- " --log-level-console=detail restore"
+ "sudo -u postgres psql -c \"begin; \\",
+ " create table important_table (message text); \\",
+ " insert into important_table values ('Important Data'); \\",
+ " commit; \\",
+ " select * from important_table;\""
],
"highlight" : {
"filter" : true,
"filter-context" : 2,
"list" : [
- "demo\\/PG_VERSION - exists and matches backup|check\\/clean db path|restore global\\/pg_control"
+ "Important Data"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " [filtered 692 lines of output]",
- "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/base/12134/PG_VERSION - exists and matches backup (4B, 99%) checksum 8dbabb96e032b8d9f1993c0e4b9141e71ade01a1",
- "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/base/1/PG_VERSION - exists and matches backup (4B, 99%) checksum 8dbabb96e032b8d9f1993c0e4b9141e71ade01a1",
- "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/PG_VERSION - exists and matches backup (4B, 100%) checksum 8dbabb96e032b8d9f1993c0e4b9141e71ade01a1",
- "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/global/12086 - exists and is zero size (0B, 100%)",
- "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/global/12038 - exists and is zero size (0B, 100%)",
- " [filtered 83 lines of output]",
- "P01 DETAIL: restore file /var/lib/postgresql/9.4/demo/base/1/11885 - exists and is zero size (0B, 100%)",
- "P00 INFO: write /var/lib/postgresql/9.4/demo/recovery.conf",
- "P00 INFO: restore global/pg_control (performed last to ensure aborted restores cannot be started)",
- "P00 INFO: restore command end: completed successfully"
+ " message ",
+ "----------------",
+ " Important Data",
+ "(1 row)"
]
}
},
{
"key" : {
"cmd" : [
- "sudo pg_ctlcluster 9.4 demo start"
- ],
- "host" : "db-master",
- "output" : false
- },
- "type" : "exe"
- },
- {
- "key" : {
- "cmd" : [
- "sudo -u postgres sleep 1"
- ],
- "host" : "db-master",
- "output" : false
- },
- "type" : "exe"
- },
- {
- "key" : {
- "cmd" : [
- "sudo -u postgres psql -c \"create database test1;\""
+ "sudo -u postgres psql -Atc \"select current_timestamp\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "CREATE DATABASE"
+ "2017-09-28 22:57:47.520063+00"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"create database test2;\""
+ "sudo -u postgres psql -c \"begin; \\",
+ " drop table important_table; \\",
+ " commit; \\",
+ " select * from important_table;\""
],
- "host" : "db-master",
+ "err-expect" : "1",
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "does not exist"
+ ]
+ },
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "CREATE DATABASE"
+ "ERROR: relation \"important_table\" does not exist",
+ "LINE 1: ...le important_table; commit; select * from important_...",
+ " ^"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --type=incr backup"
+ "sudo pg_ctlcluster 9.4 demo stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -5214,77 +6170,53 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"create table test1_table (id int); \\",
- " insert into test1_table (id) values (1);\" test1"
+ "sudo -u postgres pgbackrest --stanza=demo --delta \\",
+ " --type=time \"--target=2017-09-28 22:57:47.520063+00\" restore"
],
- "host" : "db-master",
- "output" : true
+ "host" : "db-primary",
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- "INSERT 0 1"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"create table test2_table (id int); \\",
- " insert into test2_table (id) values (2);\" test2"
+ "sudo rm /var/log/postgresql/postgresql-9.4-demo.log"
],
- "host" : "db-master",
- "output" : true
+ "host" : "db-primary",
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- "INSERT 0 1"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u postgres du -sh /var/lib/postgresql/9.4/demo/base/16384"
+ "sudo -u postgres cat /var/lib/postgresql/9.4/demo/recovery.conf"
],
- "host" : "db-master",
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "recovery_target_time"
+ ]
+ },
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "6.4M\t/var/lib/postgresql/9.4/demo/base/16384"
+ "restore_command = '/usr/bin/pgbackrest --stanza=demo archive-get %f \"%p\"'",
+ "recovery_target_time = '2017-09-28 22:57:47.520063+00'"
]
}
},
- {
- "key" : {
- "cmd" : [
- "sudo pg_ctlcluster 9.4 demo stop"
- ],
- "host" : "db-master",
- "output" : false
- },
- "type" : "exe"
- },
- {
- "key" : {
- "cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --delta \\",
- " --db-include=test2 restore"
- ],
- "host" : "db-master",
- "output" : false
- },
- "type" : "exe"
- },
{
"key" : {
"cmd" : [
"sudo pg_ctlcluster 9.4 demo start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -5292,9 +6224,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -5302,17 +6234,24 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"select * from test2_table;\" test2"
+ "sudo -u postgres psql -c \"select * from important_table\""
],
- "host" : "db-master",
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "Important Data"
+ ]
+ },
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " id ",
- "----",
- " 2",
+ " message ",
+ "----------------",
+ " Important Data",
"(1 row)"
]
}
@@ -5320,90 +6259,137 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"select * from test1_table;\" test1"
+ "sudo -u postgres cat /var/log/postgresql/postgresql-9.4-demo.log"
],
- "err-expect" : "2",
"highlight" : {
- "filter" : false,
+ "filter" : true,
"filter-context" : 2,
"list" : [
- "relation mapping file.*contains invalid data"
+ "recovery stopping before|last completed transaction|starting point-in-time recovery"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "psql: FATAL: relation mapping file \"base/16384/pg_filenode.map\" contains invalid data"
+ "LOG: database system was interrupted; last known up at 2017-09-28 22:57:42 UTC",
+ "LOG: starting point-in-time recovery to 2017-09-28 22:57:47.520063+00",
+ "LOG: restored log file \"00000004.history\" from archive",
+ "LOG: restored log file \"000000040000000000000016\" from archive",
+ " [filtered 2 lines of output]",
+ "LOG: incomplete startup packet",
+ "LOG: restored log file \"000000040000000000000017\" from archive",
+ "LOG: recovery stopping before commit of transaction 686, time 2017-09-28 22:57:47.631866+00",
+ "LOG: redo done at 0/170157F0",
+ "LOG: last completed transaction was at log time 2017-09-28 22:57:47.41566+00",
+ "LOG: selected new timeline ID: 5",
+ "LOG: restored log file \"00000004.history\" from archive",
+ " [filtered 4 lines of output]"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres du -sh /var/lib/postgresql/9.4/demo/base/16384"
+ "sudo -u postgres psql -c \"begin; \\",
+ " drop table important_table; \\",
+ " commit; \\",
+ " select * from important_table;\""
],
- "host" : "db-master",
+ "err-expect" : "1",
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "does not exist"
+ ]
+ },
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "152K\t/var/lib/postgresql/9.4/demo/base/16384"
+ "ERROR: relation \"important_table\" does not exist",
+ "LINE 1: ...le important_table; commit; select * from important_...",
+ " ^"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"drop database test1;\""
+ "sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "DROP DATABASE"
+ "20170928-225652F_20170928-225741D"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"select oid, datname from pg_database order by oid;\""
+ "sudo -u postgres pgbackrest --stanza=demo --type=incr backup"
],
- "highlight" : {
- "filter" : false,
- "filter-context" : 2,
- "list" : [
- "test2"
- ]
- },
- "host" : "db-master",
- "output" : true
+ "host" : "db-primary",
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- " oid | datname ",
- "-------+-----------",
- " 1 | template1",
- " 12134 | template0",
- " 12139 | postgres",
- " 16385 | test2",
- "(4 rows)"
- ]
- }
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo pg_ctlcluster 9.4 demo stop"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --delta \\",
+ " --type=time \"--target=2017-09-28 22:57:47.520063+00\" restore"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo rm /var/log/postgresql/postgresql-9.4-demo.log"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo pg_ctlcluster 9.4 demo start"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --type=diff backup"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -5411,72 +6397,121 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"begin; \\",
- " create table important_table (message text); \\",
- " insert into important_table values ('Important Data'); \\",
- " commit; \\",
- " select * from important_table;\""
+ "sudo -u postgres psql -c \"select * from important_table\""
],
+ "err-expect" : "1",
"highlight" : {
"filter" : true,
"filter-context" : 2,
"list" : [
- "Important Data"
+ "does not exist"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " message ",
- "----------------",
- " Important Data",
- "(1 row)"
+ "ERROR: relation \"important_table\" does not exist",
+ "LINE 1: select * from important_table",
+ " ^"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -Atc \"select current_timestamp\""
+ "sudo -u postgres cat /var/log/postgresql/postgresql-9.4-demo.log"
],
- "host" : "db-master",
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "starting point-in-time recovery|consistent recovery state reached"
+ ]
+ },
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "2017-09-03 21:36:03.665349+00"
+ "LOG: database system was interrupted; last known up at 2017-09-28 22:57:57 UTC",
+ "LOG: starting point-in-time recovery to 2017-09-28 22:57:47.520063+00",
+ "LOG: restored log file \"00000005.history\" from archive",
+ "LOG: restored log file \"000000050000000000000018\" from archive",
+ "LOG: redo starts at 0/18000028",
+ "LOG: consistent recovery state reached at 0/180000F0",
+ "FATAL: the database system is starting up",
+ "LOG: redo done at 0/180000F0",
+ " [filtered 10 lines of output]"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"begin; \\",
- " drop table important_table; \\",
- " commit; \\",
- " select * from important_table;\""
+ "sudo -u postgres pgbackrest info"
],
- "err-expect" : "1",
"highlight" : {
- "filter" : true,
+ "filter" : false,
"filter-context" : 2,
"list" : [
- "does not exist"
+ "20170928-225652F_20170928-225741D"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "ERROR: relation \"important_table\" does not exist",
- "LINE 1: ...le important_table; commit; select * from important_...",
- " ^"
+ "stanza: demo",
+ " status: ok",
+ "",
+ " db (current)",
+ " wal archive min/max (9.4-1): 000000020000000000000009 / 000000050000000000000018",
+ "",
+ " full backup: 20170928-225646F",
+ " timestamp start/stop: 2017-09-28 22:56:46 / 2017-09-28 22:56:51",
+ " wal start/stop: 000000020000000000000009 / 000000020000000000000009",
+ " database size: 19.2MB, backup size: 19.2MB",
+ " repository size: 2.2MB, repository backup size: 2.2MB",
+ "",
+ " full backup: 20170928-225652F",
+ " timestamp start/stop: 2017-09-28 22:56:52 / 2017-09-28 22:56:58",
+ " wal start/stop: 00000002000000000000000A / 00000002000000000000000A",
+ " database size: 19.2MB, backup size: 19.2MB",
+ " repository size: 2.2MB, repository backup size: 2.2MB",
+ "",
+ " diff backup: 20170928-225652F_20170928-225713D",
+ " timestamp start/stop: 2017-09-28 22:57:13 / 2017-09-28 22:57:16",
+ " wal start/stop: 000000020000000000000011 / 000000020000000000000011",
+ " database size: 19.2MB, backup size: 8.2KB",
+ " repository size: 2.2MB, repository backup size: 348B",
+ " backup reference list: 20170928-225652F",
+ "",
+ " incr backup: 20170928-225652F_20170928-225726I",
+ " timestamp start/stop: 2017-09-28 22:57:26 / 2017-09-28 22:57:30",
+ " wal start/stop: 000000030000000000000013 / 000000030000000000000013",
+ " database size: 31.7MB, backup size: 12.5MB",
+ " repository size: 3.7MB, repository backup size: 1.5MB",
+ " backup reference list: 20170928-225652F",
+ "",
+ " diff backup: 20170928-225652F_20170928-225741D",
+ " timestamp start/stop: 2017-09-28 22:57:41 / 2017-09-28 22:57:46",
+ " wal start/stop: 000000040000000000000016 / 000000040000000000000016",
+ " database size: 25.5MB, backup size: 6.3MB",
+ " repository size: 3MB, repository backup size: 765.2KB",
+ " backup reference list: 20170928-225652F",
+ "",
+ " incr backup: 20170928-225652F_20170928-225756I",
+ " timestamp start/stop: 2017-09-28 22:57:56 / 2017-09-28 22:57:59",
+ " wal start/stop: 000000050000000000000018 / 000000050000000000000018",
+ " database size: 25.5MB, backup size: 1.7MB",
+ " repository size: 2.9MB, repository backup size: 200.3KB",
+ " backup reference list: 20170928-225652F, 20170928-225652F_20170928-225741D"
]
}
},
@@ -5485,7 +6520,7 @@
"cmd" : [
"sudo pg_ctlcluster 9.4 demo stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -5494,9 +6529,10 @@
"key" : {
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --delta \\",
- " --type=time \"--target=2017-09-03 21:36:03.665349+00\" restore"
+ " --type=time \"--target=2017-09-28 22:57:47.520063+00\" \\",
+ " --set=20170928-225652F_20170928-225741D restore"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -5506,40 +6542,17 @@
"cmd" : [
"sudo rm /var/log/postgresql/postgresql-9.4-demo.log"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
},
- {
- "key" : {
- "cmd" : [
- "sudo -u postgres cat /var/lib/postgresql/9.4/demo/recovery.conf"
- ],
- "highlight" : {
- "filter" : true,
- "filter-context" : 2,
- "list" : [
- "recovery_target_time"
- ]
- },
- "host" : "db-master",
- "output" : true
- },
- "type" : "exe",
- "value" : {
- "output" : [
- "restore_command = '/usr/bin/pgbackrest --stanza=demo archive-get %f \"%p\"'",
- "recovery_target_time = '2017-09-03 21:36:03.665349+00'"
- ]
- }
- },
{
"key" : {
"cmd" : [
"sudo pg_ctlcluster 9.4 demo start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -5547,9 +6560,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -5566,7 +6579,7 @@
"Important Data"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -5591,77 +6604,241 @@
"recovery stopping before|last completed transaction|starting point-in-time recovery"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "LOG: database system was interrupted; last known up at 2017-09-03 21:35:58 UTC",
- "LOG: starting point-in-time recovery to 2017-09-03 21:36:03.665349+00",
+ "LOG: database system was interrupted; last known up at 2017-09-28 22:57:42 UTC",
+ "LOG: starting point-in-time recovery to 2017-09-28 22:57:47.520063+00",
"LOG: restored log file \"00000004.history\" from archive",
- "LOG: restored log file \"000000040000000000000017\" from archive",
+ "LOG: restored log file \"000000040000000000000016\" from archive",
" [filtered 2 lines of output]",
"LOG: incomplete startup packet",
- "LOG: restored log file \"000000040000000000000018\" from archive",
- "LOG: recovery stopping before commit of transaction 686, time 2017-09-03 21:36:03.82082+00",
- "LOG: redo done at 0/180157F0",
- "LOG: last completed transaction was at log time 2017-09-03 21:36:03.503484+00",
- "LOG: selected new timeline ID: 5",
- "LOG: restored log file \"00000004.history\" from archive",
- " [filtered 4 lines of output]"
+ "LOG: restored log file \"000000040000000000000017\" from archive",
+ "LOG: recovery stopping before commit of transaction 686, time 2017-09-28 22:57:47.631866+00",
+ "LOG: redo done at 0/170157F0",
+ "LOG: last completed transaction was at log time 2017-09-28 22:57:47.41566+00",
+ "LOG: restored log file \"00000005.history\" from archive",
+ "LOG: restored log file \"00000006.history\" from archive",
+ " [filtered 7 lines of output]"
+ ]
+ }
+ },
+ {
+ "key" : {
+ "file" : "/etc/pgbackrest.conf",
+ "host" : "db-primary",
+ "option" : {
+ "global" : {
+ "process-max" : {
+ "value" : "4"
+ },
+ "repo-path" : {
+ "value" : "/"
+ },
+ "repo-s3-bucket" : {
+ "value" : "demo-bucket"
+ },
+ "repo-s3-endpoint" : {
+ "value" : "s3.amazonaws.com"
+ },
+ "repo-s3-key" : {
+ "value" : "accessKey1"
+ },
+ "repo-s3-key-secret" : {
+ "value" : "verySecretKey1"
+ },
+ "repo-s3-region" : {
+ "value" : "us-east-1"
+ },
+ "repo-s3-verify-ssl" : {
+ "value" : "n"
+ },
+ "repo-type" : {
+ "value" : "s3"
+ }
+ }
+ }
+ },
+ "type" : "cfg-pgbackrest",
+ "value" : {
+ "config" : [
+ "[demo]",
+ "db-path=/var/lib/postgresql/9.4/demo",
+ "",
+ "[global]",
+ "process-max=4",
+ "repo-path=/",
+ "repo-s3-bucket=demo-bucket",
+ "repo-s3-endpoint=s3.amazonaws.com",
+ "repo-s3-key=accessKey1",
+ "repo-s3-key-secret=verySecretKey1",
+ "repo-s3-region=us-east-1",
+ "repo-type=s3",
+ "retention-diff=2",
+ "retention-full=2",
+ "start-fast=y",
+ "stop-auto=y"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"begin; \\",
- " drop table important_table; \\",
- " commit; \\",
- " select * from important_table;\""
+ "sudo echo \"172.17.0.2 demo-bucket.s3.amazonaws.com s3.amazonaws.com\" | \\",
+ " sudo tee -a /etc/hosts"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "aws s3 --no-verify-ssl mb s3://demo-bucket 2>&1"
+ ],
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres pgbackrest --stanza=demo --log-level-console=info stanza-create"
],
- "err-expect" : "1",
"highlight" : {
"filter" : true,
"filter-context" : 2,
"list" : [
- "does not exist"
+ "completed successfully"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "ERROR: relation \"important_table\" does not exist",
- "LINE 1: ...le important_table; commit; select * from important_...",
- " ^"
+ "P00 INFO: stanza-create command begin 1.24: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --no-log-timestamp --repo-path=/ --repo-s3-bucket=demo-bucket --repo-s3-endpoint=s3.amazonaws.com --repo-s3-region=us-east-1 --no-repo-s3-verify-ssl --repo-type=s3 --stanza=demo",
+ "P00 INFO: stanza-create command end: completed successfully"
]
}
},
{
"key" : {
"cmd" : [
- "sudo -u postgres ls -1 /var/lib/pgbackrest/backup/demo | tail -5 | head -1"
+ "sudo -u postgres pgbackrest --stanza=demo \\",
+ " --log-level-console=info backup"
],
- "host" : "db-master",
+ "highlight" : {
+ "filter" : true,
+ "filter-context" : 2,
+ "list" : [
+ "no prior backup exists|full backup size"
+ ]
+ },
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "20170903-213510F_20170903-213557D"
+ "P00 INFO: backup command begin 1.24: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --process-max=4 --repo-path=/ --repo-s3-bucket=demo-bucket --repo-s3-endpoint=s3.amazonaws.com --repo-s3-region=us-east-1 --no-repo-s3-verify-ssl --repo-type=s3 --retention-diff=2 --retention-full=2 --stanza=demo --start-fast --stop-auto",
+ "P00 WARN: no prior backup exists, incr backup has been changed to full",
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 22:58:21\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup start archive = 000000070000000000000018, lsn = 0/18000028",
+ " [filtered 995 lines of output]",
+ "P04 INFO: backup file /var/lib/postgresql/9.4/demo/base/1/11905 (0B, 100%)",
+ "P03 INFO: backup file /var/lib/postgresql/9.4/demo/base/1/11885 (0B, 100%)",
+ "P00 INFO: full backup size = 25.5MB",
+ "P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
+ "P00 INFO: backup stop archive = 000000070000000000000018, lsn = 0/18000128",
+ " [filtered 4 lines of output]"
]
}
},
+ {
+ "key" : {
+ "image" : "pgbackrest/test:u16-base",
+ "name" : "backup",
+ "os" : "u16"
+ },
+ "type" : "host",
+ "value" : {
+ "ip" : "172.17.0.4"
+ }
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo adduser --disabled-password --gecos \"\" backrest"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo apt-get install libdbd-pg-perl libio-socket-ssl-perl libxml-libxml-perl"
+ ],
+ "cmd-extra" : "-y 2>&1",
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo mkdir /root/pgbackrest-release-1.24"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/bin /root/pgbackrest-release-1.24"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/build /root/pgbackrest-release-1.24"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/lib /root/pgbackrest-release-1.24"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --type=incr backup"
+ "sudo cp -r /backrest/libc /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5669,9 +6846,9 @@
{
"key" : {
"cmd" : [
- "sudo pg_ctlcluster 9.4 demo stop"
+ "sudo cp -r /backrest/src /root/pgbackrest-release-1.24"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5679,10 +6856,10 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --delta \\",
- " --type=time \"--target=2017-09-03 21:36:03.665349+00\" restore"
+ "sudo cp -r /root/pgbackrest-release-1.24/lib/pgBackRest \\",
+ " /usr/share/perl5"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5690,9 +6867,9 @@
{
"key" : {
"cmd" : [
- "sudo rm /var/log/postgresql/postgresql-9.4-demo.log"
+ "sudo find /usr/share/perl5/pgBackRest -type f -exec chmod 644 {} +"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5700,9 +6877,9 @@
{
"key" : {
"cmd" : [
- "sudo pg_ctlcluster 9.4 demo start"
+ "sudo find /usr/share/perl5/pgBackRest -type d -exec chmod 755 {} +"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5710,9 +6887,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo cp /root/pgbackrest-release-1.24/bin/pgbackrest /usr/bin/pgbackrest"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5720,130 +6897,39 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"select * from important_table\""
+ "sudo chmod 755 /usr/bin/pgbackrest"
],
- "err-expect" : "1",
- "highlight" : {
- "filter" : true,
- "filter-context" : 2,
- "list" : [
- "does not exist"
- ]
- },
- "host" : "db-master",
- "output" : true
+ "host" : "backup",
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- "ERROR: relation \"important_table\" does not exist",
- "LINE 1: select * from important_table",
- " ^"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u postgres cat /var/log/postgresql/postgresql-9.4-demo.log"
+ "sudo mkdir -m 770 /var/log/pgbackrest"
],
- "highlight" : {
- "filter" : true,
- "filter-context" : 2,
- "list" : [
- "starting point-in-time recovery|consistent recovery state reached"
- ]
- },
- "host" : "db-master",
- "output" : true
+ "host" : "backup",
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- "LOG: database system was interrupted; last known up at 2017-09-03 21:36:12 UTC",
- "LOG: starting point-in-time recovery to 2017-09-03 21:36:03.665349+00",
- "LOG: restored log file \"00000005.history\" from archive",
- "LOG: restored log file \"000000050000000000000019\" from archive",
- "LOG: redo starts at 0/19000028",
- "LOG: consistent recovery state reached at 0/190000F0",
- "LOG: redo done at 0/190000F0",
- "LOG: incomplete startup packet",
- " [filtered 10 lines of output]"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest info"
+ "sudo chown backrest:backrest /var/log/pgbackrest"
],
- "highlight" : {
- "filter" : false,
- "filter-context" : 2,
- "list" : [
- "20170903-213510F_20170903-213557D"
- ]
- },
- "host" : "db-master",
- "output" : true
+ "host" : "backup",
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- "stanza: demo",
- " status: ok",
- "",
- " db (current)",
- " wal archive min/max (9.4-1): 00000002000000000000000A / 000000050000000000000019",
- "",
- " full backup: 20170903-213504F",
- " timestamp start/stop: 2017-09-03 21:35:04 / 2017-09-03 21:35:09",
- " wal start/stop: 00000002000000000000000A / 00000002000000000000000A",
- " database size: 19.3MB, backup size: 19.3MB",
- " repository size: 2.2MB, repository backup size: 2.2MB",
- "",
- " full backup: 20170903-213510F",
- " timestamp start/stop: 2017-09-03 21:35:10 / 2017-09-03 21:35:15",
- " wal start/stop: 00000002000000000000000B / 00000002000000000000000B",
- " database size: 19.3MB, backup size: 19.3MB",
- " repository size: 2.2MB, repository backup size: 2.2MB",
- "",
- " diff backup: 20170903-213510F_20170903-213530D",
- " timestamp start/stop: 2017-09-03 21:35:30 / 2017-09-03 21:35:33",
- " wal start/stop: 000000020000000000000012 / 000000020000000000000012",
- " database size: 19.3MB, backup size: 8.2KB",
- " repository size: 2.2MB, repository backup size: 347B",
- " backup reference list: 20170903-213510F",
- "",
- " incr backup: 20170903-213510F_20170903-213542I",
- " timestamp start/stop: 2017-09-03 21:35:42 / 2017-09-03 21:35:47",
- " wal start/stop: 000000030000000000000014 / 000000030000000000000014",
- " database size: 31.8MB, backup size: 12.7MB",
- " repository size: 3.7MB, repository backup size: 1.5MB",
- " backup reference list: 20170903-213510F",
- "",
- " diff backup: 20170903-213510F_20170903-213557D",
- " timestamp start/stop: 2017-09-03 21:35:57 / 2017-09-03 21:36:02",
- " wal start/stop: 000000040000000000000017 / 000000040000000000000017",
- " database size: 25.7MB, backup size: 6.5MB",
- " repository size: 3MB, repository backup size: 793.5KB",
- " backup reference list: 20170903-213510F",
- "",
- " incr backup: 20170903-213510F_20170903-213611I",
- " timestamp start/stop: 2017-09-03 21:36:11 / 2017-09-03 21:36:14",
- " wal start/stop: 000000050000000000000019 / 000000050000000000000019",
- " database size: 25.6MB, backup size: 1.9MB",
- " repository size: 3MB, repository backup size: 215.3KB",
- " backup reference list: 20170903-213510F, 20170903-213510F_20170903-213557D"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo pg_ctlcluster 9.4 demo stop"
+ "sudo touch /etc/pgbackrest.conf"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5851,11 +6937,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --delta \\",
- " --type=time \"--target=2017-09-03 21:36:03.665349+00\" \\",
- " --set=20170903-213510F_20170903-213557D restore"
+ "sudo chmod 640 /etc/pgbackrest.conf"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5863,9 +6947,9 @@
{
"key" : {
"cmd" : [
- "sudo rm /var/log/postgresql/postgresql-9.4-demo.log"
+ "sudo chown backrest:backrest /etc/pgbackrest.conf"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5873,9 +6957,9 @@
{
"key" : {
"cmd" : [
- "sudo pg_ctlcluster 9.4 demo start"
+ "sudo mkdir /var/lib/pgbackrest"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5883,9 +6967,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo chmod 750 /var/lib/pgbackrest"
],
- "host" : "db-master",
+ "host" : "backup",
"output" : false
},
"type" : "exe"
@@ -5893,127 +6977,39 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres psql -c \"select * from important_table\""
+ "sudo chown backrest:backrest /var/lib/pgbackrest"
],
- "highlight" : {
- "filter" : true,
- "filter-context" : 2,
- "list" : [
- "Important Data"
- ]
- },
- "host" : "db-master",
- "output" : true
+ "host" : "backup",
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- " message ",
- "----------------",
- " Important Data",
- "(1 row)"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u postgres cat /var/log/postgresql/postgresql-9.4-demo.log"
+ "sudo -u backrest mkdir -m 750 /home/backrest/.ssh"
],
- "highlight" : {
- "filter" : true,
- "filter-context" : 2,
- "list" : [
- "recovery stopping before|last completed transaction|starting point-in-time recovery"
- ]
- },
- "host" : "db-master",
- "output" : true
+ "host" : "backup",
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- "LOG: database system was interrupted; last known up at 2017-09-03 21:35:58 UTC",
- "LOG: starting point-in-time recovery to 2017-09-03 21:36:03.665349+00",
- "LOG: restored log file \"00000004.history\" from archive",
- "LOG: restored log file \"000000040000000000000017\" from archive",
- " [filtered 2 lines of output]",
- "LOG: incomplete startup packet",
- "LOG: restored log file \"000000040000000000000018\" from archive",
- "LOG: recovery stopping before commit of transaction 686, time 2017-09-03 21:36:03.82082+00",
- "LOG: redo done at 0/180157F0",
- "LOG: last completed transaction was at log time 2017-09-03 21:36:03.503484+00",
- "LOG: restored log file \"00000005.history\" from archive",
- "LOG: restored log file \"00000006.history\" from archive",
- " [filtered 7 lines of output]"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
- "file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
- "option" : {
- "global" : {
- "process-max" : {
- "value" : "4"
- },
- "repo-path" : {
- "value" : "/"
- },
- "repo-s3-bucket" : {
- "value" : "demo-bucket"
- },
- "repo-s3-endpoint" : {
- "value" : "s3.amazonaws.com"
- },
- "repo-s3-key" : {
- "value" : "accessKey1"
- },
- "repo-s3-key-secret" : {
- "value" : "verySecretKey1"
- },
- "repo-s3-region" : {
- "value" : "us-east-1"
- },
- "repo-s3-verify-ssl" : {
- "value" : "n"
- },
- "repo-type" : {
- "value" : "s3"
- }
- }
- }
+ "cmd" : [
+ "sudo -u backrest ssh-keygen -f /home/backrest/.ssh/id_rsa -t rsa -b 4096 -N \"\""
+ ],
+ "host" : "backup",
+ "output" : false
},
- "type" : "cfg-pgbackrest",
- "value" : {
- "config" : [
- "[demo]",
- "db-path=/var/lib/postgresql/9.4/demo",
- "",
- "[global]",
- "process-max=4",
- "repo-path=/",
- "repo-s3-bucket=demo-bucket",
- "repo-s3-endpoint=s3.amazonaws.com",
- "repo-s3-key=accessKey1",
- "repo-s3-key-secret=verySecretKey1",
- "repo-s3-region=us-east-1",
- "repo-type=s3",
- "retention-diff=2",
- "retention-full=2",
- "start-fast=y",
- "stop-auto=y"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo echo \"172.17.0.2 demo-bucket.s3.amazonaws.com s3.amazonaws.com\" | \\",
- " sudo tee -a /etc/hosts"
+ "sudo -u postgres mkdir -m 750 -p /home/postgres/.ssh"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6021,9 +7017,9 @@
{
"key" : {
"cmd" : [
- "aws s3 --no-verify-ssl mb s3://demo-bucket 2>&1"
+ "sudo -u postgres ssh-keygen -f /home/postgres/.ssh/id_rsa -t rsa -b 4096 -N \"\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6031,69 +7027,46 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo --log-level-console=info stanza-create"
+ "sudo ssh root@db-primary cat /home/postgres/.ssh/id_rsa.pub | \\",
+ " sudo -u backrest tee -a /home/backrest/.ssh/authorized_keys"
],
- "highlight" : {
- "filter" : true,
- "filter-context" : 2,
- "list" : [
- "completed successfully"
- ]
- },
- "host" : "db-master",
- "output" : true
+ "host" : "backup",
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- "P00 INFO: stanza-create command begin 1.23: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --no-log-timestamp --repo-path=/ --repo-s3-bucket=demo-bucket --repo-s3-endpoint=s3.amazonaws.com --repo-s3-region=us-east-1 --no-repo-s3-verify-ssl --repo-type=s3 --stanza=demo",
- "P00 INFO: stanza-create command end: completed successfully"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
"cmd" : [
- "sudo -u postgres pgbackrest --stanza=demo \\",
- " --log-level-console=info backup"
+ "sudo ssh root@backup cat /home/backrest/.ssh/id_rsa.pub | \\",
+ " sudo -u postgres tee -a /home/postgres/.ssh/authorized_keys"
],
- "highlight" : {
- "filter" : true,
- "filter-context" : 2,
- "list" : [
- "no prior backup exists|full backup size"
- ]
- },
- "host" : "db-master",
- "output" : true
+ "host" : "db-primary",
+ "output" : false
},
- "type" : "exe",
- "value" : {
- "output" : [
- "P00 INFO: backup command begin 1.23: --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --process-max=4 --repo-path=/ --repo-s3-bucket=demo-bucket --repo-s3-endpoint=s3.amazonaws.com --repo-s3-region=us-east-1 --no-repo-s3-verify-ssl --repo-type=s3 --retention-diff=2 --retention-full=2 --stanza=demo --start-fast --stop-auto",
- "P00 WARN: no prior backup exists, incr backup has been changed to full",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:36:33\": backup begins after the requested immediate checkpoint completes",
- "P00 INFO: backup start archive = 000000070000000000000019, lsn = 0/19000028",
- " [filtered 998 lines of output]",
- "P02 INFO: backup file /var/lib/postgresql/9.4/demo/base/1/11885 (0B, 100%)",
- "P01 INFO: backup file /var/lib/postgresql/9.4/demo/base/1/11895 (0B, 100%)",
- "P00 INFO: full backup size = 25.6MB",
- "P00 INFO: execute exclusive pg_stop_backup() and wait for all WAL segments to archive",
- "P00 INFO: backup stop archive = 000000070000000000000019, lsn = 0/19000128",
- " [filtered 4 lines of output]"
- ]
- }
+ "type" : "exe"
},
{
"key" : {
- "image" : "pgbackrest/test:u16-doc-backup",
- "name" : "backup",
- "os" : "u16"
+ "cmd" : [
+ "sudo -u backrest ssh postgres@db-primary"
+ ],
+ "cmd-extra" : "-o StrictHostKeyChecking=no ls",
+ "host" : "backup",
+ "output" : false
},
- "type" : "host",
- "value" : {
- "ip" : "172.17.0.4"
- }
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres ssh backrest@backup"
+ ],
+ "cmd-extra" : "-o StrictHostKeyChecking=no ls",
+ "host" : "db-primary",
+ "output" : false
+ },
+ "type" : "exe"
},
{
"key" : {
@@ -6122,7 +7095,7 @@
"option" : {
"demo" : {
"db1-host" : {
- "value" : "db-master"
+ "value" : "db-primary"
},
"db1-path" : {
"value" : "/var/lib/postgresql/9.4/demo"
@@ -6151,7 +7124,7 @@
"value" : {
"config" : [
"[demo]",
- "db1-host=db-master",
+ "db1-host=db-primary",
"db1-path=/var/lib/postgresql/9.4/demo",
"db1-user=postgres",
"",
@@ -6165,7 +7138,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"demo" : {
"db-path" : {
@@ -6210,7 +7183,7 @@
"cmd" : [
"sudo find /var/lib/pgbackrest -delete"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6230,7 +7203,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo check"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe"
@@ -6265,7 +7238,7 @@
"cmd" : [
"sudo pg_ctlcluster 9.4 demo stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6275,7 +7248,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo --delta restore"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6285,7 +7258,7 @@
"cmd" : [
"sudo pg_ctlcluster 9.4 demo start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6293,9 +7266,9 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6315,7 +7288,7 @@
"cmd" : [
"sudo mkdir -m 750 /var/spool/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6325,7 +7298,7 @@
"cmd" : [
"sudo chown postgres:postgres /var/spool/pgbackrest"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6333,7 +7306,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"global" : {
"archive-async" : {
@@ -6373,7 +7346,7 @@
"cmd" : [
"sudo -u postgres rm -f /var/log/pgbackrest/demo-archive-async.log"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6388,7 +7361,7 @@
" select pg_create_restore_point('test async push'); select pg_switch_xlog(); \\",
" select pg_create_restore_point('test async push'); select pg_switch_xlog();\""
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6405,14 +7378,14 @@
"WAL segment"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: check command begin 1.23: --backup-host=backup --backup-user=backrest --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-file=detail --log-level-stderr=off --no-log-timestamp --stanza=demo",
- "P00 INFO: WAL segment 000000080000000000000025 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000800000000/000000080000000000000025-74a59fd208deeed3edbfeeb264fc881062809565.gz'",
+ "P00 INFO: check command begin 1.24: --backup-host=backup --backup-user=backrest --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-file=detail --log-level-stderr=off --no-log-timestamp --stanza=demo",
+ "P00 INFO: WAL segment 000000080000000000000024 successfully stored in the archive at '/var/lib/pgbackrest/archive/demo/9.4-1/0000000800000000/000000080000000000000024-19a9afb8a52d1c72367544bec1ebfeef23679128.gz'",
"P00 INFO: check command end: completed successfully"
]
}
@@ -6429,26 +7402,26 @@
" WAL file\\(s\\) to archive|pushed WAL file 0000000"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
"-------------------PROCESS START-------------------",
- "P00 INFO: archive-push command begin 1.23: --archive-async --backup-host=backup --backup-user=backrest --db1-path=/var/lib/postgresql/9.4/demo --log-level-file=detail --log-level-stderr=off --no-log-timestamp --process-max=2 --spool-path=/var/spool/pgbackrest --stanza=demo",
- "P00 INFO: push 3 WAL file(s) to archive: 000000080000000000000020...000000080000000000000022",
- "P01 DETAIL: pushed WAL file 000000080000000000000020 to archive",
+ "P00 INFO: archive-push command begin 1.24: --archive-async --backup-host=backup --backup-user=backrest --db1-path=/var/lib/postgresql/9.4/demo --log-level-file=detail --log-level-stderr=off --no-log-timestamp --process-max=2 --spool-path=/var/spool/pgbackrest --stanza=demo",
+ "P00 INFO: push 3 WAL file(s) to archive: 00000008000000000000001F...000000080000000000000021",
+ "P02 DETAIL: pushed WAL file 000000080000000000000020 to archive",
+ "P01 DETAIL: pushed WAL file 00000008000000000000001F to archive",
"P02 DETAIL: pushed WAL file 000000080000000000000021 to archive",
- "P01 DETAIL: pushed WAL file 000000080000000000000022 to archive",
"P00 INFO: archive-push command end: completed successfully",
"",
"-------------------PROCESS START-------------------",
- "P00 INFO: archive-push command begin 1.23: --archive-async --backup-host=backup --backup-user=backrest --db1-path=/var/lib/postgresql/9.4/demo --log-level-file=detail --log-level-stderr=off --no-log-timestamp --process-max=2 --spool-path=/var/spool/pgbackrest --stanza=demo",
- "P00 INFO: push 3 WAL file(s) to archive: 000000080000000000000023...000000080000000000000025",
- "P02 DETAIL: pushed WAL file 000000080000000000000024 to archive",
- "P01 DETAIL: pushed WAL file 000000080000000000000023 to archive",
- "P02 DETAIL: pushed WAL file 000000080000000000000025 to archive",
+ "P00 INFO: archive-push command begin 1.24: --archive-async --backup-host=backup --backup-user=backrest --db1-path=/var/lib/postgresql/9.4/demo --log-level-file=detail --log-level-stderr=off --no-log-timestamp --process-max=2 --spool-path=/var/spool/pgbackrest --stanza=demo",
+ "P00 INFO: push 3 WAL file(s) to archive: 000000080000000000000022...000000080000000000000024",
+ "P01 DETAIL: pushed WAL file 000000080000000000000022 to archive",
+ "P02 DETAIL: pushed WAL file 000000080000000000000023 to archive",
+ "P01 DETAIL: pushed WAL file 000000080000000000000024 to archive",
"P00 INFO: archive-push command end: completed successfully"
]
}
@@ -6507,7 +7480,7 @@
"value" : {
"config" : [
"[demo]",
- "db1-host=db-master",
+ "db1-host=db-primary",
"db1-path=/var/lib/postgresql/9.4/demo",
"db1-user=postgres",
"",
@@ -6551,18 +7524,18 @@
" status: ok",
"",
" db (current)",
- " wal archive min/max (9.4-1): 000000080000000000000026 / 000000080000000000000027",
+ " wal archive min/max (9.4-1): 000000080000000000000025 / 000000080000000000000026",
"",
- " full backup: 20170903-213736F",
- " timestamp start/stop: 2017-09-03 21:37:36 / 2017-09-03 21:37:43",
- " wal start/stop: 000000080000000000000026 / 000000080000000000000026",
- " database size: 25.6MB, backup size: 25.6MB",
+ " full backup: 20170928-225931F",
+ " timestamp start/stop: 2017-09-28 22:59:31 / 2017-09-28 22:59:40",
+ " wal start/stop: 000000080000000000000025 / 000000080000000000000025",
+ " database size: 25.5MB, backup size: 25.5MB",
" repository size: 3MB, repository backup size: 3MB",
"",
- " full backup: 20170903-213745F",
- " timestamp start/stop: 2017-09-03 21:37:45 / 2017-09-03 21:37:52",
- " wal start/stop: 000000080000000000000027 / 000000080000000000000027",
- " database size: 25.6MB, backup size: 25.6MB",
+ " full backup: 20170928-225941F",
+ " timestamp start/stop: 2017-09-28 22:59:41 / 2017-09-28 22:59:48",
+ " wal start/stop: 000000080000000000000026 / 000000080000000000000026",
+ " database size: 25.5MB, backup size: 25.5MB",
" repository size: 3MB, repository backup size: 3MB"
]
}
@@ -6572,7 +7545,7 @@
"cmd" : [
"sudo -u postgres pgbackrest stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6596,7 +7569,7 @@
"type" : "exe",
"value" : {
"output" : [
- "P00 ERROR: [062]: process 'db-master remote' terminated unexpectedly [062]: stop file exists for all stanzas",
+ "P00 ERROR: [062]: process 'db-primary remote' terminated unexpectedly [062]: stop file exists for all stanzas",
" "
]
}
@@ -6606,7 +7579,7 @@
"cmd" : [
"sudo -u postgres pgbackrest stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -6621,7 +7594,7 @@
"cmd" : [
"sudo -u postgres pgbackrest start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6631,7 +7604,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -6655,7 +7628,7 @@
"type" : "exe",
"value" : {
"output" : [
- "P00 ERROR: [062]: process 'db-master remote' terminated unexpectedly [062]: stop file exists for stanza demo",
+ "P00 ERROR: [062]: process 'db-primary remote' terminated unexpectedly [062]: stop file exists for stanza demo",
" "
]
}
@@ -6665,14 +7638,14 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
},
{
"key" : {
- "image" : "pgbackrest/test:u16-doc-db",
+ "image" : "pgbackrest/test:u16-base",
"name" : "db-standby",
"os" : "u16"
},
@@ -6681,6 +7654,252 @@
"ip" : "172.17.0.5"
}
},
+ {
+ "key" : {
+ "cmd" : [
+ "sudo apt-get install libdbd-pg-perl libio-socket-ssl-perl libxml-libxml-perl"
+ ],
+ "cmd-extra" : "-y 2>&1",
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo mkdir /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/bin /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/build /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/lib /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/libc /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /backrest/src /root/pgbackrest-release-1.24"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp -r /root/pgbackrest-release-1.24/lib/pgBackRest \\",
+ " /usr/share/perl5"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo find /usr/share/perl5/pgBackRest -type f -exec chmod 644 {} +"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo find /usr/share/perl5/pgBackRest -type d -exec chmod 755 {} +"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo cp /root/pgbackrest-release-1.24/bin/pgbackrest /usr/bin/pgbackrest"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chmod 755 /usr/bin/pgbackrest"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo mkdir -m 770 /var/log/pgbackrest"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chown postgres:postgres /var/log/pgbackrest"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo touch /etc/pgbackrest.conf"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chmod 640 /etc/pgbackrest.conf"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo chown postgres:postgres /etc/pgbackrest.conf"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo pg_createcluster 9.4 demo"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres mkdir -m 750 -p /home/postgres/.ssh"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres ssh-keygen -f /home/postgres/.ssh/id_rsa -t rsa -b 4096 -N \"\""
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo ssh root@db-standby cat /home/postgres/.ssh/id_rsa.pub | \\",
+ " sudo -u backrest tee -a /home/backrest/.ssh/authorized_keys"
+ ],
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo ssh root@backup cat /home/backrest/.ssh/id_rsa.pub | \\",
+ " sudo -u postgres tee -a /home/postgres/.ssh/authorized_keys"
+ ],
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u backrest ssh postgres@db-standby"
+ ],
+ "cmd-extra" : "-o StrictHostKeyChecking=no ls",
+ "host" : "backup",
+ "output" : false
+ },
+ "type" : "exe"
+ },
+ {
+ "key" : {
+ "cmd" : [
+ "sudo -u postgres ssh backrest@backup"
+ ],
+ "cmd-extra" : "-o StrictHostKeyChecking=no ls",
+ "host" : "db-standby",
+ "output" : false
+ },
+ "type" : "exe"
+ },
{
"key" : {
"file" : "/etc/postgresql/9.4/demo/postgresql.conf",
@@ -6808,7 +8027,7 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
"host" : "db-standby",
"output" : false
@@ -6835,13 +8054,13 @@
"output" : [
"LOG: could not bind IPv6 socket: Cannot assign requested address",
"HINT: Is another postmaster already running on port 5432? If not, wait a few seconds and retry.",
- "LOG: database system was interrupted; last known up at 2017-09-03 21:37:46 UTC",
+ "LOG: database system was interrupted; last known up at 2017-09-28 22:59:42 UTC",
"LOG: entering standby mode",
"LOG: restored log file \"00000008.history\" from archive",
"LOG: incomplete startup packet",
- "LOG: restored log file \"000000080000000000000027\" from archive",
- "LOG: redo starts at 0/27000028",
- "LOG: consistent recovery state reached at 0/270000F0",
+ "LOG: restored log file \"000000080000000000000026\" from archive",
+ "LOG: redo starts at 0/26000028",
+ "LOG: consistent recovery state reached at 0/260000F0",
"LOG: database system is ready to accept read only connections"
]
}
@@ -6863,7 +8082,7 @@
"Important Data"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -6906,15 +8125,15 @@
"cmd" : [
"sudo -u postgres psql -c \"select *, current_timestamp from pg_switch_xlog()\";"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
"value" : {
"output" : [
- " pg_switch_xlog | now ",
- "----------------+------------------------------",
- " 0/280199E0 | 2017-09-03 21:38:13.15324+00",
+ " pg_switch_xlog | now ",
+ "----------------+-------------------------------",
+ " 0/270199E0 | 2017-09-28 23:00:11.890735+00",
"(1 row)"
]
}
@@ -6940,7 +8159,7 @@
"output" : [
" message | now ",
"----------------+-------------------------------",
- " Important Data | 2017-09-03 21:38:15.648454+00",
+ " Important Data | 2017-09-28 23:00:14.299461+00",
"(1 row)"
]
}
@@ -6963,7 +8182,7 @@
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: check command begin 1.23: --backup-host=backup --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --stanza=demo",
+ "P00 INFO: check command begin 1.24: --backup-host=backup --db1-path=/var/lib/postgresql/9.4/demo --log-level-console=info --log-level-stderr=off --no-log-timestamp --stanza=demo",
"P00 INFO: switch xlog cannot be performed on the standby, all other checks passed successfully",
"P00 INFO: check command end: completed successfully"
]
@@ -6975,7 +8194,7 @@
"sudo -u postgres psql -c \" \\",
" create user replicator password 'jw8s0F4' replication\";"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -6992,7 +8211,7 @@
" \"host replication replicator 172.17.0.5/32 md5\" \\",
" >> /etc/postgresql/9.4/demo/pg_hba.conf'"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -7002,7 +8221,7 @@
"cmd" : [
"sudo pg_ctlcluster 9.4 demo reload"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -7114,7 +8333,7 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
"host" : "db-standby",
"output" : false
@@ -7141,8 +8360,8 @@
"output" : [
" [filtered 9 lines of output]",
"LOG: database system is ready to accept read only connections",
- "LOG: restored log file \"000000080000000000000028\" from archive",
- "LOG: started streaming WAL from primary at 0/29000000 on timeline 8"
+ "LOG: restored log file \"000000080000000000000027\" from archive",
+ "LOG: started streaming WAL from primary at 0/28000000 on timeline 8"
]
}
},
@@ -7163,7 +8382,7 @@
"Important Data"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -7171,7 +8390,7 @@
"output" : [
" message | now ",
"----------------+-------------------------------",
- " Important Data | 2017-09-03 21:38:24.805031+00",
+ " Important Data | 2017-09-28 23:00:24.565875+00",
"(1 row)"
]
}
@@ -7197,7 +8416,7 @@
"output" : [
" message | now ",
"----------------+-------------------------------",
- " Important Data | 2017-09-03 21:38:24.970255+00",
+ " Important Data | 2017-09-28 23:00:24.729957+00",
"(1 row)"
]
}
@@ -7229,7 +8448,7 @@
"value" : {
"config" : [
"[demo]",
- "db1-host=db-master",
+ "db1-host=db-primary",
"db1-path=/var/lib/postgresql/9.4/demo",
"db1-user=postgres",
"db2-host=db-standby",
@@ -7254,7 +8473,7 @@
"filter" : true,
"filter-context" : 2,
"list" : [
- "backup file db-master|replay on the standby"
+ "backup file db-primary|replay on the standby"
]
},
"host" : "backup",
@@ -7264,16 +8483,23 @@
"value" : {
"output" : [
" [filtered 2 lines of output]",
- "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-03 21:38:25\": backup begins after the requested immediate checkpoint completes",
- "P00 INFO: backup start archive = 00000008000000000000002A, lsn = 0/2A0000C8",
- "P00 INFO: wait for replay on the standby to reach 0/2A0000C8",
- "P00 INFO: replay on the standby reached 0/2A000168",
- "P01 INFO: backup file db-master:/var/lib/postgresql/9.4/demo/global/pg_control (8KB, 0%) checksum 7107d8a1d83406f0970d2c48f884c82496116baf",
- "P03 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/base/12139/11889 (344KB, 18%) checksum 62ff1462a0320fa26bcb6e8dcaff1aab87d737ce",
- "P01 INFO: backup file db-master:/var/lib/postgresql/9.4/demo/backup_label (238B, 18%) checksum 44e02c6b4e47bb7612a0ea44a88c6956ed9ce496",
- "P02 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/base/12139/12007 (392KB, 38%) checksum ab24248d1d73b7a40f1bffb35237bed8b74bc615",
- "P03 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/base/12139/12010 (232KB, 50%) checksum c020c4f632a4ddaaf1d9d8d235881242b73fd3b7",
- " [filtered 34 lines of output]"
+ "P00 INFO: execute exclusive pg_start_backup() with label \"pgBackRest backup started at 2017-09-28 23:00:25\": backup begins after the requested immediate checkpoint completes",
+ "P00 INFO: backup start archive = 000000080000000000000029, lsn = 0/29000028",
+ "P00 INFO: wait for replay on the standby to reach 0/29000028",
+ "P00 INFO: replay on the standby reached 0/290000C8",
+ "P04 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/base/12139/12009 (240KB, 12%) checksum 4db01860354afc569a7351d85865687ef1211685",
+ "P02 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/base/12139/12007 (392KB, 32%) checksum 3746d4ee7afd008dfa98fb71e004b99274528a55",
+ " [filtered 11 lines of output]",
+ "P02 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/base/12139/11900_fsm (24KB, 91%) checksum 283ee200135d14180c2f6d72967b3b3e36e8d494",
+ "P03 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/base/12139/11879 (32KB, 92%) checksum 99c644a60e59f79ee9a1ba4c90ae19e97fae2dfb",
+ "P01 INFO: backup file db-primary:/var/lib/postgresql/9.4/demo/global/pg_control (8KB, 93%) checksum 4839b31ba046f4a2f7cddd24959389a73d68ac04",
+ "P04 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/global/11884 (16KB, 94%) checksum 35235f8b5c0c02c5fede6e62360b24ec6d6a1478",
+ "P02 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/global/11883 (16KB, 95%) checksum ad318c3591bbd49e7b7bb888b23584ef6afa7dd0",
+ "P03 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/base/12139/11928 (16KB, 95%) checksum 393237a241bd3df306966151f759a937612dc0ba",
+ "P01 INFO: backup file db-primary:/var/lib/postgresql/9.4/demo/backup_label (238B, 95%) checksum 8c89fd251e38e41256a4be2b4a079b4191b54080",
+ "P02 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/pg_clog/0000 (8KB, 96%) checksum b36e351f7d4325a9b2f538bbfa5d97100c50f288",
+ "P03 INFO: backup file db-standby:/var/lib/postgresql/9.4/demo/global/11881_vm (8KB, 96%) checksum df7f4ef33268234e4c671f7810ba2fb59339e4a4",
+ " [filtered 17 lines of output]"
]
}
},
@@ -7283,7 +8509,7 @@
"sudo apt-get install postgresql-9.5"
],
"cmd-extra" : "-y",
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -7293,7 +8519,7 @@
"cmd" : [
"sudo pg_dropcluster 9.5 main"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -7304,7 +8530,7 @@
"sudo -u postgres /usr/lib/postgresql/9.5/bin/initdb \\",
" -D /var/lib/postgresql/9.5/demo -k -A peer"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -7314,7 +8540,7 @@
"cmd" : [
"sudo pg_createcluster 9.5 demo"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -7362,7 +8588,7 @@
"cmd" : [
"sudo pg_ctlcluster 9.4 demo stop"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -7386,7 +8612,7 @@
"Upgrade Complete"
]
},
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -7405,7 +8631,7 @@
{
"key" : {
"file" : "/etc/postgresql/9.5/demo/postgresql.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"archive_command" : {
"value" : "'pgbackrest --stanza=demo archive-push %p'"
@@ -7446,7 +8672,7 @@
{
"key" : {
"file" : "/etc/pgbackrest.conf",
- "host" : "db-master",
+ "host" : "db-primary",
"option" : {
"demo" : {
"db-path" : {
@@ -7522,7 +8748,7 @@
"value" : {
"config" : [
"[demo]",
- "db1-host=db-master",
+ "db1-host=db-primary",
"db1-path=/var/lib/postgresql/9.5/demo",
"db1-user=postgres",
"db2-host=db-standby",
@@ -7544,7 +8770,7 @@
"sudo cp /etc/postgresql/9.4/demo/pg_hba.conf \\",
" /etc/postgresql/9.5/demo/pg_hba.conf"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -7568,7 +8794,7 @@
"type" : "exe",
"value" : {
"output" : [
- "P00 INFO: stanza-upgrade command begin 1.23: --no-backup-standby --db1-host=db-master --db1-path=/var/lib/postgresql/9.5/demo --db1-user=postgres --db2-host=db-standby --db2-path=/var/lib/postgresql/9.5/demo --db2-user=postgres --log-level-console=info --no-log-timestamp --no-online --repo-path=/var/lib/pgbackrest --stanza=demo",
+ "P00 INFO: stanza-upgrade command begin 1.24: --no-backup-standby --db1-host=db-primary --db1-path=/var/lib/postgresql/9.5/demo --db1-user=postgres --db2-host=db-standby --db2-path=/var/lib/postgresql/9.5/demo --db2-user=postgres --log-level-console=info --no-log-timestamp --no-online --repo-path=/var/lib/pgbackrest --stanza=demo",
"P00 INFO: stanza-upgrade command end: completed successfully"
]
}
@@ -7578,7 +8804,7 @@
"cmd" : [
"sudo pg_ctlcluster 9.5 demo start"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe"
@@ -7588,7 +8814,7 @@
"cmd" : [
"sudo -u postgres pg_lsclusters"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe",
@@ -7605,7 +8831,7 @@
"cmd" : [
"sudo -u postgres pgbackrest --stanza=demo check"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : true
},
"type" : "exe"
@@ -7632,7 +8858,7 @@
"cmd" : [
"sudo pg_dropcluster 9.4 demo"
],
- "host" : "db-master",
+ "host" : "db-primary",
"output" : false
},
"type" : "exe"
@@ -7725,7 +8951,7 @@
{
"key" : {
"cmd" : [
- "sudo -u postgres sleep 1"
+ "sudo -u postgres sleep 2"
],
"host" : "db-standby",
"output" : false
@@ -7748,7 +8974,7 @@
"value" : {
"config" : [
"[demo]",
- "db1-host=db-master",
+ "db1-host=db-primary",
"db1-path=/var/lib/postgresql/9.5/demo",
"db1-user=postgres",
"db2-host=db-standby",
diff --git a/doc/xml/release.xml b/doc/xml/release.xml
index cb65a7001..170d33b77 100644
--- a/doc/xml/release.xml
+++ b/doc/xml/release.xml
@@ -10,14 +10,22 @@
</intro>
<release-list>
- <release date="XXXX-XX-XX" version="1.24dev" title="UNDER DEVELOPMENT">
+ <release date="2017-09-28" version="1.24" title="New Backup Exclusions">
<release-core-list>
<release-bug-list>
<release-item>
+ <release-item-contributor-list>
+ <release-item-ideator id="uspen"/>
+ </release-item-contributor-list>
+
<p>Fixed an issue where warnings were being emitted in place of lower priority log messages during backup from standby initialization.</p>
</release-item>
<release-item>
+ <release-item-contributor-list>
+ <release-item-ideator id="uspen"/>
+ </release-item-contributor-list>
+
<p>Fixed an issue where some <id>db-*</id> options (e.g. <br-option>db-port</br-option>) were not being passed to remotes.</p>
</release-item>
</release-bug-list>
@@ -3280,7 +3288,7 @@
<!-- The order of other contributors is alpha by name -->
<contributor id="avellar.leonardo">
- <contributor-name-display>Leonardo Avellar</contributor-name-display>
+ <contributor-name-display>Leonardo GG Avellar</contributor-name-display>
<contributor-id type="github">L30Bola</contributor-id>
</contributor>
@@ -3419,6 +3427,11 @@
<contributor-id type="github">Underhunden</contributor-id>
</contributor>
+ <contributor id="uspen">
+ <contributor-name-display>Uspen</contributor-name-display>
+ <contributor-id type="github">uspen</contributor-id>
+ </contributor>
+
<contributor id="vernick.todd">
<contributor-name-display>Todd Vernick</contributor-name-display>
<contributor-id type="github">gintoddic</contributor-id>
diff --git a/lib/pgBackRest/Config/ConfigHelpData.pm b/lib/pgBackRest/Config/ConfigHelpData.pm
index e7931538e..69a9ed0a8 100644
--- a/lib/pgBackRest/Config/ConfigHelpData.pm
+++ b/lib/pgBackRest/Config/ConfigHelpData.pm
@@ -156,8 +156,8 @@ my $oConfigHelpData =
summary =>
"Backup from the standby cluster.",
description =>
- "Enable backup from standby to reduce load on the master cluster. This option requires that both the master and " .
- "standby hosts be configured."
+ "Enable backup from standby to reduce load on the primary cluster. This option requires that both the primary " .
+ "and standby hosts be configured."
},
# BACKUP-USER Option Help
@@ -574,7 +574,7 @@ my $oConfigHelpData =
summary =>
"Protocol timeout.",
description =>
- "Sets the timeout, in seconds, that the master or remote process will wait for a new message to be received on " .
+ "Sets the timeout, in seconds, that the local or remote process will wait for a new message to be received on " .
"the protocol layer. This prevents processes from waiting indefinitely for a message. The protocol-timeout " .
"option must be greater than the db-timeout option."
},
diff --git a/lib/pgBackRest/Version.pm b/lib/pgBackRest/Version.pm
index 393147a2f..6412ad4e3 100644
--- a/lib/pgBackRest/Version.pm
+++ b/lib/pgBackRest/Version.pm
@@ -35,7 +35,7 @@ use constant BACKREST_BIN => abs_path(
# 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.24dev';
+use constant BACKREST_VERSION => '1.24';
push @EXPORT, qw(BACKREST_VERSION);
# Format Format Number
[parent: 40a85e34f1b1]