Failed to recover all data
475 views
Skip to first unread message
Ferdous Shibly
Mar 6, 2015, 4:33:17 PM3/6/15
to pgba...@googlegroups.com
Hi,
In my test environment, I installed postgres 9.1 and pgbarman on seperate Ubuntu machines. My configurations are mentioned below.
In /etc/postgresql/9.1/main/postgresql.conf on postgres server
wal_level = 'archive'
archive_mode = on
archive_command = 'rsync -a %p barman@barman:/var/lib/barman/postgres/incoming/%f'
In /etc/barman.conf
[postgres]
description = "Postgres Server on 192.168.56.115"
ssh_command = ssh post...@192.168.56.115
conninfo = host=192.168.56.115 user=postgres
When I execute the command "barman check postgres" I get
ssh: OK
PostgreSQL: OK
archive_mode: OK
archive_command: OK
directories: OK
retention policy settings: OK
backup maximum age: OK (no last_backup_maximum_age provided)
compression settings: OK
minimum redundancy requirements: OK (have 46 backups, expected at least 0)
And even I can take the backup.
barman list-backup postgres
postgres 20150306T124001 - Fri Mar 6 12:40:13 2015 - Size: 47.5 MiB - WAL Size: 16.0 MiB
postgres 20150306T123001 - Fri Mar 6 12:30:14 2015 - Size: 47.5 MiB - WAL Size: 32.0 MiB
postgres 20150306T122001 - Fri Mar 6 12:20:13 2015 - Size: 47.4 MiB - WAL Size: 32.0 MiB
postgres 20150306T121001 - Fri Mar 6 12:10:16 2015 - Size: 47.4 MiB - WAL Size: 32.0 MiB
postgres 20150306T120001 - Fri Mar 6 12:00:12 2015 - Size: 47.3 MiB - WAL Size: 32.0 MiB
postgres 20150306T115001 - Fri Mar 6 11:50:25 2015 - Size: 47.3 MiB - WAL Size: 32.0 MiB
postgres 20150306T114001 - Fri Mar 6 11:40:15 2015 - Size: 47.3 MiB - WAL Size: 32.0 MiB
postgres 20150306T113001 - Fri Mar 6 11:30:21 2015 - Size: 47.3 MiB - WAL Size: 32.0 MiB
When I restore the database from backup I am getting full data.
Now to test more realistic senario I stopped the postgres process but let the barman ran. Then I got some failure. But when I started the postgres process barman started taking backup.
postgres 20150306T141001 - Fri Mar 6 14:10:16 2015 - Size: 50.2 MiB - WAL Size: 256.0 MiB
postgres 20150306T140001 - Fri Mar 6 14:00:16 2015 - Size: 47.4 MiB - WAL Size: 0 B
postgres 20150306T135001 - FAILED
postgres 20150306T134002 - FAILED
postgres 20150306T133001 - FAILED
postgres 20150306T132002 - FAILED
postgres 20150306T131001 - FAILED
postgres 20150306T130001 - FAILED
postgres 20150306T125001 - FAILED
postgres 20150306T124001 - Fri Mar 6 12:40:13 2015 - Size: 47.5 MiB - WAL Size: 16.0 MiB
postgres 20150306T123001 - Fri Mar 6 12:30:14 2015 - Size: 47.5 MiB - WAL Size: 32.0 MiB
postgres 20150306T122001 - Fri Mar 6 12:20:13 2015 - Size: 47.4 MiB - WAL Size: 32.0 MiB
postgres 20150306T121001 - Fri Mar 6 12:10:16 2015 - Size: 47.4 MiB - WAL Size: 32.0 MiB
postgres 20150306T120001 - Fri Mar 6 12:00:12 2015 - Size: 47.3 MiB - WAL Size: 32.0 MiB
postgres 20150306T115001 - Fri Mar 6 11:50:25 2015 - Size: 47.3 MiB - WAL Size: 32.0 MiB
postgres 20150306T114001 - Fri Mar 6 11:40:15 2015 - Size: 47.3 MiB - WAL Size: 32.0 MiB
postgres 20150306T113001 - Fri Mar 6 11:30:21 2015 - Size: 47.3 MiB - WAL Size: 32.0 MiB
At this point when I tried to restore the whole database, I was able to get the data before FAILED backup.
How can I restore the whole database up to last backup?
Giulio Calacoci
Mar 9, 2015, 6:52:11 AM3/9/15
to pgba...@googlegroups.com, Ferdous Shibly
Hi Ferdous,
I think that I'm missing something.
When you try to restore the latest backup barman gives you an error?
Could you please report the output of the 'barman diagnose' command?
Regards.
Giulio
I think that I'm missing something.
When you try to restore the latest backup barman gives you an error?
Could you please report the output of the 'barman diagnose' command?
Regards.
Giulio
--
--
You received this message because you are subscribed to the "Barman for PostgreSQL" group.
To post to this group, send email to pgba...@googlegroups.com
To unsubscribe from this group, send email to
pgbarman+u...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/pgbarman?hl=en?hl=en-GB
---
You received this message because you are subscribed to the Google Groups "Barman, Backup and Recovery Manager for PostgreSQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pgbarman+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
-- Giulio Calacoci - 2ndQuadrant Italia PostgreSQL Training, Services and Support giulio....@2ndQuadrant.it | www.2ndQuadrant.it
Ferdous Shibly
Mar 11, 2015, 10:40:20 AM3/11/15
to pgba...@googlegroups.com, bdsh...@gmail.com
Hi Giulio,
The output of "barman diagnose" is
root@barman:~# barman diagnose
{
"global": {
"config": {
"barman_home": "/var/lib/barman",
"barman_user": "barman",
"log_file": "/var/log/barman/barman.log"
},
"system_info": {
"barman_ver": "1.4.0",
"kernel_ver": "Linux barman 3.16.0-23-generic #31-Ubuntu SMP Tue Oct 21 17:56:17 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux",
"python_ver": "Python 2.7.8",
"release": "Distributor ID:\tUbuntu\nDescription:\tUbuntu 14.10\nRelease:\t14.10\nCodename:\tutopic",
"rsync_ver": "rsync version 3.1.1 protocol version 31",
"ssh_ver": "OpenSSH_6.6.1p1 Ubuntu-8, OpenSSL 1.0.1f 6 Jan 2014"
}
},
"servers": {
"postgres": {
"backups": {
"20150305T135501": {
"backup_id": "20150305T135501",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 13:55:00 2015",
"begin_wal": "000000010000000000000005",
"begin_xlog": "0/5000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45298338,
"end_offset": "69112",
"end_time": "Thu Mar 5 13:55:18 2015",
"end_wal": "000000010000000000000005",
"end_xlog": "0/5010DF8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45298338,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T140002": {
"backup_id": "20150305T140002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 14:00:01 2015",
"begin_wal": "000000010000000000000007",
"begin_xlog": "0/7000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45339298,
"end_offset": "248",
"end_time": "Thu Mar 5 14:00:13 2015",
"end_wal": "000000010000000000000007",
"end_xlog": "0/70000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45339298,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T140501": {
"backup_id": "20150305T140501",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:05:01 2015",
"begin_wal": "000000010000000000000009",
"begin_xlog": "0/9000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45355682,
"end_offset": "15856",
"end_time": "Thu Mar 5 14:05:24 2015",
"end_wal": "000000010000000000000009",
"end_xlog": "0/9003DF0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45355682,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T141001": {
"backup_id": "20150305T141001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 14:10:01 2015",
"begin_wal": "00000001000000000000000B",
"begin_xlog": "0/B000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45355682,
"end_offset": "248",
"end_time": "Thu Mar 5 14:10:12 2015",
"end_wal": "00000001000000000000000B",
"end_xlog": "0/B0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45355682,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T141502": {
"backup_id": "20150305T141502",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:15:01 2015",
"begin_wal": "00000001000000000000000D",
"begin_xlog": "0/D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45355682,
"end_offset": "11024",
"end_time": "Thu Mar 5 14:15:17 2015",
"end_wal": "00000001000000000000000D",
"end_xlog": "0/D002B10",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45355682,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T142001": {
"backup_id": "20150305T142001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 14:20:01 2015",
"begin_wal": "00000001000000000000000F",
"begin_xlog": "0/F000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45355682,
"end_offset": "248",
"end_time": "Thu Mar 5 14:20:12 2015",
"end_wal": "00000001000000000000000F",
"end_xlog": "0/F0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45355682,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T142502": {
"backup_id": "20150305T142502",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:25:01 2015",
"begin_wal": "000000010000000000000011",
"begin_xlog": "0/11000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45355684,
"end_offset": "71664",
"end_time": "Thu Mar 5 14:25:17 2015",
"end_wal": "000000010000000000000011",
"end_xlog": "0/110117F0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45355684,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T143001": {
"backup_id": "20150305T143001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 14:30:01 2015",
"begin_wal": "000000010000000000000013",
"begin_xlog": "0/13000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45388452,
"end_offset": "248",
"end_time": "Thu Mar 5 14:30:12 2015",
"end_wal": "000000010000000000000013",
"end_xlog": "0/130000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45388452,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T143501": {
"backup_id": "20150305T143501",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:35:01 2015",
"begin_wal": "000000010000000000000015",
"begin_xlog": "0/15000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45396644,
"end_offset": "107200",
"end_time": "Thu Mar 5 14:35:28 2015",
"end_wal": "000000010000000000000015",
"end_xlog": "0/1501A2C0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45396644,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T144001": {
"backup_id": "20150305T144001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 14:40:01 2015",
"begin_wal": "000000010000000000000017",
"begin_xlog": "0/17000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45429412,
"end_offset": "5744",
"end_time": "Thu Mar 5 14:40:16 2015",
"end_wal": "000000010000000000000017",
"end_xlog": "0/17001670",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45429412,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T144501": {
"backup_id": "20150305T144501",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:45:00 2015",
"begin_wal": "000000010000000000000019",
"begin_xlog": "0/19000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45462180,
"end_offset": "20880",
"end_time": "Thu Mar 5 14:45:18 2015",
"end_wal": "000000010000000000000019",
"end_xlog": "0/19005190",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45462180,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T145001": {
"backup_id": "20150305T145001",
"backup_label": "None",
"begin_offset": "73144",
"begin_time": "Thu Mar 5 14:50:01 2015",
"begin_wal": "00000001000000000000001B",
"begin_xlog": "0/1B011DB8",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45462180,
"end_offset": "85016",
"end_time": "Thu Mar 5 14:50:23 2015",
"end_wal": "00000001000000000000001B",
"end_xlog": "0/1B014C18",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45462180,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T145501": {
"backup_id": "20150305T145501",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:55:01 2015",
"begin_wal": "00000001000000000000001D",
"begin_xlog": "0/1D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45462180,
"end_offset": "90232",
"end_time": "Thu Mar 5 14:55:17 2015",
"end_wal": "00000001000000000000001D",
"end_xlog": "0/1D016078",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45462180,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T150001": {
"backup_id": "20150305T150001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 15:00:00 2015",
"begin_wal": "00000001000000000000001F",
"begin_xlog": "0/1F000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45486756,
"end_offset": "123456",
"end_time": "Thu Mar 5 15:00:29 2015",
"end_wal": "00000001000000000000001F",
"end_xlog": "0/1F01E240",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45486756,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T151001": {
"backup_id": "20150305T151001",
"backup_label": "None",
"begin_offset": "44904",
"begin_time": "Thu Mar 5 15:10:01 2015",
"begin_wal": "000000010000000000000021",
"begin_xlog": "0/2100AF68",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45486756,
"end_offset": "99320",
"end_time": "Thu Mar 5 15:10:20 2015",
"end_wal": "000000010000000000000021",
"end_xlog": "0/210183F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45486756,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T152002": {
"backup_id": "20150305T152002",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 15:20:01 2015",
"begin_wal": "000000010000000000000023",
"begin_xlog": "0/23000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45847204,
"end_offset": "215952",
"end_time": "Thu Mar 5 15:20:33 2015",
"end_wal": "000000010000000000000023",
"end_xlog": "0/23034B90",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45847204,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T153001": {
"backup_id": "20150305T153001",
"backup_label": "None",
"begin_offset": "55720",
"begin_time": "Thu Mar 5 15:30:01 2015",
"begin_wal": "000000010000000000000025",
"begin_xlog": "0/2500D9A8",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 46224036,
"end_offset": "176784",
"end_time": "Thu Mar 5 15:30:23 2015",
"end_wal": "000000010000000000000025",
"end_xlog": "0/2502B290",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 46224036,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T154002": {
"backup_id": "20150305T154002",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 15:40:01 2015",
"begin_wal": "000000010000000000000027",
"begin_xlog": "0/27000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 46486180,
"end_offset": "160176",
"end_time": "Thu Mar 5 15:40:36 2015",
"end_wal": "000000010000000000000027",
"end_xlog": "0/270271B0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 46486180,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T155001": {
"backup_id": "20150305T155001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 15:50:00 2015",
"begin_wal": "000000010000000000000029",
"begin_xlog": "0/29000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 46944932,
"end_offset": "257512",
"end_time": "Thu Mar 5 15:50:45 2015",
"end_wal": "000000010000000000000029",
"end_xlog": "0/2903EDE8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 46944932,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T160002": {
"backup_id": "20150305T160002",
"backup_label": "None",
"begin_offset": "85976",
"begin_time": "Thu Mar 5 16:00:01 2015",
"begin_wal": "00000001000000000000002B",
"begin_xlog": "0/2B014FD8",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 47346340,
"end_offset": "197616",
"end_time": "Thu Mar 5 16:00:23 2015",
"end_wal": "00000001000000000000002B",
"end_xlog": "0/2B0303F0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 47346340,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T161001": {
"backup_id": "20150305T161001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 16:10:00 2015",
"begin_wal": "00000001000000000000002D",
"begin_xlog": "0/2D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 47739556,
"end_offset": "152992",
"end_time": "Thu Mar 5 16:10:39 2015",
"end_wal": "00000001000000000000002D",
"end_xlog": "0/2D0255A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 47739556,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T162001": {
"backup_id": "20150305T162001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 16:20:01 2015",
"begin_wal": "00000001000000000000002F",
"begin_xlog": "0/2F000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 48018084,
"end_offset": "10824",
"end_time": "Thu Mar 5 16:20:19 2015",
"end_wal": "00000001000000000000002F",
"end_xlog": "0/2F002A48",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 48018084,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T163001": {
"backup_id": "20150305T163001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 16:30:01 2015",
"begin_wal": "000000010000000000000031",
"begin_xlog": "0/31000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 48386724,
"end_offset": "449984",
"end_time": "Thu Mar 5 16:30:46 2015",
"end_wal": "000000010000000000000031",
"end_xlog": "0/3106DDC0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 48386724,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T164002": {
"backup_id": "20150305T164002",
"backup_label": "None",
"begin_offset": "189624",
"begin_time": "Thu Mar 5 16:40:01 2015",
"begin_wal": "000000010000000000000033",
"begin_xlog": "0/3302E4B8",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 48648868,
"end_offset": "341264",
"end_time": "Thu Mar 5 16:40:36 2015",
"end_wal": "000000010000000000000033",
"end_xlog": "0/33053510",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 48648868,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T165001": {
"backup_id": "20150305T165001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 16:50:00 2015",
"begin_wal": "000000010000000000000035",
"begin_xlog": "0/35000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 48984740,
"end_offset": "223256",
"end_time": "Thu Mar 5 16:50:42 2015",
"end_wal": "000000010000000000000035",
"end_xlog": "0/35036818",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 48984740,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T170002": {
"backup_id": "20150305T170002",
"backup_label": "None",
"begin_offset": "115216",
"begin_time": "Thu Mar 5 17:00:01 2015",
"begin_wal": "000000010000000000000037",
"begin_xlog": "0/3701C210",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49189540,
"end_offset": "243176",
"end_time": "Thu Mar 5 17:00:27 2015",
"end_wal": "000000010000000000000037",
"end_xlog": "0/3703B5E8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49189540,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T171001": {
"backup_id": "20150305T171001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 17:10:01 2015",
"begin_wal": "000000010000000000000039",
"begin_xlog": "0/39000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49386148,
"end_offset": "296952",
"end_time": "Thu Mar 5 17:10:41 2015",
"end_wal": "000000010000000000000039",
"end_xlog": "0/390487F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49386148,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T172001": {
"backup_id": "20150305T172001",
"backup_label": "None",
"begin_offset": "121872",
"begin_time": "Thu Mar 5 17:20:01 2015",
"begin_wal": "00000001000000000000003B",
"begin_xlog": "0/3B01DC10",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49599140,
"end_offset": "256304",
"end_time": "Thu Mar 5 17:20:27 2015",
"end_wal": "00000001000000000000003B",
"end_xlog": "0/3B03E930",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49599140,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T173001": {
"backup_id": "20150305T173001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 17:30:00 2015",
"begin_wal": "00000001000000000000003D",
"begin_xlog": "0/3D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49713828,
"end_offset": "160",
"end_time": "Thu Mar 5 17:30:13 2015",
"end_wal": "00000001000000000000003D",
"end_xlog": "0/3D0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49713828,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T174001": {
"backup_id": "20150305T174001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 17:40:00 2015",
"begin_wal": "000000010000000000000040",
"begin_xlog": "0/40000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49610968,
"end_offset": "16016",
"end_time": "Thu Mar 5 17:40:27 2015",
"end_wal": "000000010000000000000040",
"end_xlog": "0/40003E90",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49610968,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T181001": {
"backup_id": "20150305T181001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 18:10:01 2015",
"begin_wal": "000000050000000000000043",
"begin_xlog": "0/43000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49611102,
"end_offset": "22416",
"end_time": "Thu Mar 5 18:10:18 2015",
"end_wal": "000000050000000000000043",
"end_xlog": "0/43005790",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49611102,
"status": "DONE",
"tablespaces": null,
"timeline": 5,
"version": 90115
},
"20150305T183001": {
"backup_id": "20150305T183001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 18:30:01 2015",
"begin_wal": "000000080000000000000043",
"begin_xlog": "0/43000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49611102,
"end_offset": "160",
"end_time": "Thu Mar 5 18:30:11 2015",
"end_wal": "000000080000000000000043",
"end_xlog": "0/430000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49611102,
"status": "DONE",
"tablespaces": null,
"timeline": 8,
"version": 90115
},
"20150306T095002": {
"backup_id": "20150306T095002",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 09:50:02 2015",
"begin_wal": "0000000B0000000000000044",
"begin_xlog": "0/44000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49611102,
"end_offset": "136808",
"end_time": "Fri Mar 6 09:50:25 2015",
"end_wal": "0000000B0000000000000044",
"end_xlog": "0/44021668",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49611102,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T100001": {
"backup_id": "20150306T100001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 10:00:01 2015",
"begin_wal": "0000000B0000000000000046",
"begin_xlog": "0/46000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49611102,
"end_offset": "160",
"end_time": "Fri Mar 6 10:00:18 2015",
"end_wal": "0000000B0000000000000046",
"end_xlog": "0/460000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49611102,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T113001": {
"backup_id": "20150306T113001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 11:30:01 2015",
"begin_wal": "0000000B000000000000004A",
"begin_xlog": "0/4A000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49627486,
"end_offset": "3352",
"end_time": "Fri Mar 6 11:30:21 2015",
"end_wal": "0000000B000000000000004A",
"end_xlog": "0/4A000D18",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49627486,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T114001": {
"backup_id": "20150306T114001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 11:40:01 2015",
"begin_wal": "0000000B000000000000004C",
"begin_xlog": "0/4C000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49627486,
"end_offset": "248",
"end_time": "Fri Mar 6 11:40:15 2015",
"end_wal": "0000000B000000000000004C",
"end_xlog": "0/4C0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49627486,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T115001": {
"backup_id": "20150306T115001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 11:50:01 2015",
"begin_wal": "0000000B000000000000004E",
"begin_xlog": "0/4E000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49635678,
"end_offset": "160",
"end_time": "Fri Mar 6 11:50:25 2015",
"end_wal": "0000000B000000000000004E",
"end_xlog": "0/4E0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49635678,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T120001": {
"backup_id": "20150306T120001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 12:00:01 2015",
"begin_wal": "0000000B0000000000000050",
"begin_xlog": "0/50000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49643870,
"end_offset": "248",
"end_time": "Fri Mar 6 12:00:12 2015",
"end_wal": "0000000B0000000000000050",
"end_xlog": "0/500000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49643870,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T121001": {
"backup_id": "20150306T121001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 12:10:01 2015",
"begin_wal": "0000000B0000000000000052",
"begin_xlog": "0/52000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49652062,
"end_offset": "160",
"end_time": "Fri Mar 6 12:10:16 2015",
"end_wal": "0000000B0000000000000052",
"end_xlog": "0/520000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49652062,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T122001": {
"backup_id": "20150306T122001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 12:20:01 2015",
"begin_wal": "0000000B0000000000000054",
"begin_xlog": "0/54000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49684830,
"end_offset": "248",
"end_time": "Fri Mar 6 12:20:13 2015",
"end_wal": "0000000B0000000000000054",
"end_xlog": "0/540000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49684830,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T123001": {
"backup_id": "20150306T123001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 12:30:01 2015",
"begin_wal": "0000000B0000000000000056",
"begin_xlog": "0/56000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49824402,
"end_offset": "160",
"end_time": "Fri Mar 6 12:30:14 2015",
"end_wal": "0000000B0000000000000056",
"end_xlog": "0/560000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49824402,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T124001": {
"backup_id": "20150306T124001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 12:40:01 2015",
"begin_wal": "0000000B0000000000000058",
"begin_xlog": "0/58000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49840786,
"end_offset": "248",
"end_time": "Fri Mar 6 12:40:13 2015",
"end_wal": "0000000B0000000000000058",
"end_xlog": "0/580000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49840786,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T140001": {
"backup_id": "20150306T140001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 14:00:01 2015",
"begin_wal": "0000000C0000000000000043",
"begin_xlog": "0/43000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49660258,
"end_offset": "160",
"end_time": "Fri Mar 6 14:00:16 2015",
"end_wal": "0000000C0000000000000043",
"end_xlog": "0/430000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49660258,
"status": "DONE",
"tablespaces": null,
"timeline": 12,
"version": 90115
},
"20150306T141001": {
"backup_id": "20150306T141001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 14:10:01 2015",
"begin_wal": "0000000B000000000000004D",
"begin_xlog": "0/4D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52642141,
"end_offset": "12760",
"end_time": "Fri Mar 6 14:10:16 2015",
"end_wal": "0000000B000000000000004D",
"end_xlog": "0/4D0031D8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52642141,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T143001": {
"backup_id": "20150306T143001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 14:30:01 2015",
"begin_wal": "0000000E0000000000000043",
"begin_xlog": "0/43000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49660258,
"end_offset": "160",
"end_time": "Fri Mar 6 14:30:17 2015",
"end_wal": "0000000E0000000000000043",
"end_xlog": "0/430000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49660258,
"status": "DONE",
"tablespaces": null,
"timeline": 14,
"version": 90115
},
"20150306T152001": {
"backup_id": "20150306T152001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 15:20:01 2015",
"begin_wal": "0000000F0000000000000043",
"begin_xlog": "0/43000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49405685,
"end_offset": "7448",
"end_time": "Fri Mar 6 15:20:10 2015",
"end_wal": "0000000F0000000000000043",
"end_xlog": "0/43001D18",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49405685,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T153001": {
"backup_id": "20150306T153001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 15:30:02 2015",
"begin_wal": "0000000F0000000000000045",
"begin_xlog": "0/45000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49512489,
"end_offset": "15920",
"end_time": "Fri Mar 6 15:30:12 2015",
"end_wal": "0000000F0000000000000045",
"end_xlog": "0/45003E30",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49512489,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T154001": {
"backup_id": "20150306T154001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 15:40:02 2015",
"begin_wal": "0000000F0000000000000047",
"begin_xlog": "0/47000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "5968",
"end_time": "Fri Mar 6 15:40:20 2015",
"end_wal": "0000000F0000000000000047",
"end_xlog": "0/47001750",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T155001": {
"backup_id": "20150306T155001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 15:50:01 2015",
"begin_wal": "0000000F0000000000000049",
"begin_xlog": "0/49000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "11248",
"end_time": "Fri Mar 6 15:50:17 2015",
"end_wal": "0000000F0000000000000049",
"end_xlog": "0/49002BF0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T160001": {
"backup_id": "20150306T160001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 16:00:01 2015",
"begin_wal": "0000000F000000000000004B",
"begin_xlog": "0/4B000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "16360",
"end_time": "Fri Mar 6 16:00:13 2015",
"end_wal": "0000000F000000000000004B",
"end_xlog": "0/4B003FE8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T161002": {
"backup_id": "20150306T161002",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 16:10:02 2015",
"begin_wal": "0000000F000000000000004D",
"begin_xlog": "0/4D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "7952",
"end_time": "Fri Mar 6 16:10:11 2015",
"end_wal": "0000000F000000000000004D",
"end_xlog": "0/4D001F10",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T162001": {
"backup_id": "20150306T162001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 16:20:02 2015",
"begin_wal": "0000000F000000000000004F",
"begin_xlog": "0/4F000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "12256",
"end_time": "Fri Mar 6 16:20:09 2015",
"end_wal": "0000000F000000000000004F",
"end_xlog": "0/4F002FE0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T163002": {
"backup_id": "20150306T163002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 16:30:02 2015",
"begin_wal": "0000000F0000000000000051",
"begin_xlog": "0/51000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "5064",
"end_time": "Fri Mar 6 16:30:13 2015",
"end_wal": "0000000F0000000000000051",
"end_xlog": "0/510013C8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T164002": {
"backup_id": "20150306T164002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 16:40:02 2015",
"begin_wal": "0000000F0000000000000053",
"begin_xlog": "0/53000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "10280",
"end_time": "Fri Mar 6 16:40:15 2015",
"end_wal": "0000000F0000000000000053",
"end_xlog": "0/53002828",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150307T111001": {
"backup_id": "20150307T111001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 11:10:01 2015",
"begin_wal": "0000000F0000000000000055",
"begin_xlog": "0/55000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49569833,
"end_offset": "160",
"end_time": "Sat Mar 7 11:10:11 2015",
"end_wal": "0000000F0000000000000055",
"end_xlog": "0/550000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49569833,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150307T112002": {
"backup_id": "20150307T112002",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 11:20:02 2015",
"begin_wal": "0000000F0000000000000057",
"begin_xlog": "0/57000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49569833,
"end_offset": "160",
"end_time": "Sat Mar 7 11:20:12 2015",
"end_wal": "0000000F0000000000000057",
"end_xlog": "0/570000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49569833,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150307T113001": {
"backup_id": "20150307T113001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 11:30:02 2015",
"begin_wal": "0000000F000000000000005A",
"begin_xlog": "0/5A000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49569832,
"end_offset": "7920",
"end_time": "Sat Mar 7 11:30:14 2015",
"end_wal": "0000000F000000000000005A",
"end_xlog": "0/5A001EF0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49569832,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150307T114001": {
"backup_id": "20150307T114001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 11:40:01 2015",
"begin_wal": "0000000B0000000000000053",
"begin_xlog": "0/53000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52568105,
"end_offset": "84512",
"end_time": "Sat Mar 7 11:40:18 2015",
"end_wal": "0000000B0000000000000053",
"end_xlog": "0/53014A20",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52568105,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T115001": {
"backup_id": "20150307T115001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 11:50:01 2015",
"begin_wal": "0000000B0000000000000055",
"begin_xlog": "0/55000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52568105,
"end_offset": "248",
"end_time": "Sat Mar 7 11:50:13 2015",
"end_wal": "0000000B0000000000000055",
"end_xlog": "0/550000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52568105,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T120001": {
"backup_id": "20150307T120001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 12:00:01 2015",
"begin_wal": "0000000B0000000000000057",
"begin_xlog": "0/57000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52568105,
"end_offset": "160",
"end_time": "Sat Mar 7 12:00:11 2015",
"end_wal": "0000000B0000000000000057",
"end_xlog": "0/570000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52568105,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T121001": {
"backup_id": "20150307T121001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 12:10:02 2015",
"begin_wal": "0000000B0000000000000059",
"begin_xlog": "0/59000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52674909,
"end_offset": "248",
"end_time": "Sat Mar 7 12:10:13 2015",
"end_wal": "0000000B0000000000000059",
"end_xlog": "0/590000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52674909,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T122001": {
"backup_id": "20150307T122001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 12:20:01 2015",
"begin_wal": "0000000B000000000000005B",
"begin_xlog": "0/5B000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52674909,
"end_offset": "160",
"end_time": "Sat Mar 7 12:20:11 2015",
"end_wal": "0000000B000000000000005B",
"end_xlog": "0/5B0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52674909,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T123001": {
"backup_id": "20150307T123001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 12:30:01 2015",
"begin_wal": "0000000B000000000000005D",
"begin_xlog": "0/5D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52674909,
"end_offset": "160",
"end_time": "Sat Mar 7 12:30:09 2015",
"end_wal": "0000000B000000000000005D",
"end_xlog": "0/5D0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52674909,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T124001": {
"backup_id": "20150307T124001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 12:40:01 2015",
"begin_wal": "0000000B000000000000005F",
"begin_xlog": "0/5F000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52674909,
"end_offset": "248",
"end_time": "Sat Mar 7 12:40:13 2015",
"end_wal": "0000000B000000000000005F",
"end_xlog": "0/5F0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52674909,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T125001": {
"backup_id": "20150307T125001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 12:50:01 2015",
"begin_wal": "0000000B0000000000000061",
"begin_xlog": "0/61000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "160",
"end_time": "Sat Mar 7 12:50:17 2015",
"end_wal": "0000000B0000000000000061",
"end_xlog": "0/610000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T130001": {
"backup_id": "20150307T130001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 13:00:01 2015",
"begin_wal": "0000000B0000000000000063",
"begin_xlog": "0/63000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 13:00:11 2015",
"end_wal": "0000000B0000000000000063",
"end_xlog": "0/630000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T131001": {
"backup_id": "20150307T131001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 13:10:01 2015",
"begin_wal": "0000000B0000000000000065",
"begin_xlog": "0/65000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 13:10:09 2015",
"end_wal": "0000000B0000000000000065",
"end_xlog": "0/650000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T132001": {
"backup_id": "20150307T132001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 13:20:01 2015",
"begin_wal": "0000000B0000000000000067",
"begin_xlog": "0/67000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 13:20:11 2015",
"end_wal": "0000000B0000000000000067",
"end_xlog": "0/670000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T133001": {
"backup_id": "20150307T133001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 13:30:01 2015",
"begin_wal": "0000000B0000000000000069",
"begin_xlog": "0/69000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 13:30:11 2015",
"end_wal": "0000000B0000000000000069",
"end_xlog": "0/690000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T134001": {
"backup_id": "20150307T134001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 13:40:01 2015",
"begin_wal": "0000000B000000000000006B",
"begin_xlog": "0/6B000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 13:40:13 2015",
"end_wal": "0000000B000000000000006B",
"end_xlog": "0/6B0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T135001": {
"backup_id": "20150307T135001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 13:50:02 2015",
"begin_wal": "0000000B000000000000006D",
"begin_xlog": "0/6D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "160",
"end_time": "Sat Mar 7 13:50:17 2015",
"end_wal": "0000000B000000000000006D",
"end_xlog": "0/6D0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T140002": {
"backup_id": "20150307T140002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 14:00:02 2015",
"begin_wal": "0000000B000000000000006F",
"begin_xlog": "0/6F000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 14:00:12 2015",
"end_wal": "0000000B000000000000006F",
"end_xlog": "0/6F0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T141002": {
"backup_id": "20150307T141002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 14:10:02 2015",
"begin_wal": "0000000B0000000000000071",
"begin_xlog": "0/71000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 14:10:12 2015",
"end_wal": "0000000B0000000000000071",
"end_xlog": "0/710000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T142002": {
"backup_id": "20150307T142002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 14:20:02 2015",
"begin_wal": "0000000B0000000000000073",
"begin_xlog": "0/73000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "248",
"end_time": "Sat Mar 7 14:20:12 2015",
"end_wal": "0000000B0000000000000073",
"end_xlog": "0/730000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T143001": {
"backup_id": "20150307T143001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 14:30:02 2015",
"begin_wal": "0000000B0000000000000075",
"begin_xlog": "0/75000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "248",
"end_time": "Sat Mar 7 14:30:10 2015",
"end_wal": "0000000B0000000000000075",
"end_xlog": "0/750000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T144002": {
"backup_id": "20150307T144002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 14:40:02 2015",
"begin_wal": "0000000B0000000000000077",
"begin_xlog": "0/77000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "248",
"end_time": "Sat Mar 7 14:40:14 2015",
"end_wal": "0000000B0000000000000077",
"end_xlog": "0/770000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T145001": {
"backup_id": "20150307T145001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 14:50:02 2015",
"begin_wal": "0000000B0000000000000079",
"begin_xlog": "0/79000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "160",
"end_time": "Sat Mar 7 14:50:14 2015",
"end_wal": "0000000B0000000000000079",
"end_xlog": "0/790000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T150001": {
"backup_id": "20150307T150001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 15:00:01 2015",
"begin_wal": "0000000B000000000000007B",
"begin_xlog": "0/7B000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "160",
"end_time": "Sat Mar 7 15:00:12 2015",
"end_wal": "0000000B000000000000007B",
"end_xlog": "0/7B0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T151001": {
"backup_id": "20150307T151001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 15:10:02 2015",
"begin_wal": "0000000B000000000000007D",
"begin_xlog": "0/7D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "160",
"end_time": "Sat Mar 7 15:10:12 2015",
"end_wal": "0000000B000000000000007D",
"end_xlog": "0/7D0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T152001": {
"backup_id": "20150307T152001",
"backup_label": "None",
"begin_offset": null,
"begin_time": null,
"begin_wal": null,
"begin_xlog": null,
"config_file": null,
"deduplicated_size": null,
"end_offset": null,
"end_time": null,
"end_wal": null,
"end_xlog": null,
"error": "failure issuing start backup command (Cannot connect to postgres: could not connect to server: No route to host)",
"hba_file": null,
"ident_file": null,
"mode": "default",
"pgdata": null,
"server_name": "postgres",
"size": null,
"status": "FAILED",
"tablespaces": null,
"timeline": null,
"version": null
}
},
"config": {
"active": true,
"backup_directory": "/var/lib/barman/postgres",
"backup_options": "exclusive_backup",
"bandwidth_limit": null,
"barman_home": "/var/lib/barman",
"basebackup_retry_sleep": 30,
"basebackup_retry_times": 0,
"basebackups_directory": "/var/lib/barman/postgres/base",
"compression": null,
"conninfo": "host=192.168.56.115 user=postgres",
"custom_compression_filter": null,
"custom_decompression_filter": null,
"description": "Postgres Server on 192.168.56.115",
"immediate_checkpoint": false,
"incoming_wals_directory": "/var/lib/barman/postgres/incoming",
"last_backup_maximum_age": null,
"lock_file": "/var/lib/barman/postgres/postgres.lock",
"minimum_redundancy": 0,
"name": "postgres",
"network_compression": false,
"post_archive_script": null,
"post_backup_script": null,
"pre_archive_script": null,
"pre_backup_script": null,
"retention_policy": null,
"retention_policy_mode": "auto",
"reuse_backup": null,
"ssh_command": "ssh post...@192.168.56.115",
"tablespace_bandwidth_limit": null,
"wal_retention_policy": "main",
"wals_directory": "/var/lib/barman/postgres/wals"
},
"status": {
"archive_command": "rsync -a %p barman@barman:/var/lib/barman/postgres/incoming/%f",
"archive_mode": "on",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"current_xlog": "0000000B000000000000007F",
"data_directory": "/var/lib/postgresql/9.1/main",
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"last_archived_wal": "0000000B000000000000007E",
"pgespresso_installed": false,
"server_txt_version": "9.1.15"
},
"system_info": {
"kernel_ver": "Linux postgres 3.16.0-23-generic #31-Ubuntu SMP Tue Oct 21 17:56:17 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux",
"python_ver": "Python 2.7.8",
"release": "Distributor ID:\tUbuntu\nDescription:\tUbuntu 14.10\nRelease:\t14.10\nCodename:\tutopic",
"rsync_ver": "rsync version 3.1.1 protocol version 31",
"ssh_ver": "OpenSSH_6.6.1p1 Ubuntu-8, OpenSSL 1.0.1f 6 Jan 2014"
}
}
}
}
On barman server when I am going to execute "barman recover --remote-ssh-command "ssh postgres@postgres" --target-time "2015-03-06 16:29:59.000" postgres 20150306T113001 /var/lib/postgresql/9.1/main" command, I am getting
Starting remote restore for server postgres using backup 20150306T113001
Destination directory: /var/lib/postgresql/9.1/main
Doing PITR. Recovery target time: '2015-03-06 16:29:59'
Using safe horizon time for smart rsync copy: 2015-03-06 11:30:01.878205-05:00
Copying the base backup.
Copying required wal segments.
Generating recovery.conf
Disabling dangerous settings in destination directory.
The archive_command was set to 'false' to prevent data losses.
Your PostgreSQL server has been successfully prepared for recovery!
Please review network and archive related settings in the PostgreSQL
configuration file before starting the just recovered instance.
WARNING: Before starting up the recovered PostgreSQL server,
please review also the settings of the following configuration
options as they might interfere with your current recovery attempt:
data_directory = '/var/lib/postgresql/9.1/main' # use data in another directory
external_pid_file = '/var/run/postgresql/9.1-main.pid' # write an extra PID file
hba_file = '/etc/postgresql/9.1/main/pg_hba.conf' # host-based authentication file
ident_file = '/etc/postgresql/9.1/main/pg_ident.conf' # ident configuration file
unix_socket_directory = '/var/run/postgresql' # (change requires restart)
Recovery completed successful.
But on postgres server when I am going to start postgres process I am getting
root@postgres:~# /etc/init.d/postgresql start
* Starting PostgreSQL 9.1 database server * The PostgreSQL server failed to start. Please check the log output:
2015-03-11 10:36:25 EDT [3075-1] LOG: database system was interrupted; last known up at 2015-03-06 11:30:12 EST
2015-03-11 10:36:25 EDT [3075-2] LOG: creating missing WAL directory "pg_xlog/archive_status"
2015-03-11 10:36:25 EDT [3075-3] LOG: restored log file "0000000B.history" from archive
2015-03-11 10:36:25 EDT [3075-4] LOG: starting point-in-time recovery to 2015-03-06 16:29:59-05
2015-03-11 10:36:25 EDT [3075-5] LOG: restored log file "0000000B000000000000004A" from archive
2015-03-11 10:36:25 EDT [3075-6] LOG: redo starts at 0/4A000078
2015-03-11 10:36:25 EDT [3075-7] LOG: restored log file "0000000B000000000000004B" from archive
2015-03-11 10:36:25 EDT [3075-8] FATAL: online backup was canceled, recovery cannot continue
2015-03-11 10:36:25 EDT [3075-9] CONTEXT: xlog redo checkpoint: redo 0/4B000020; tli 11; xid 0/19700; oid 28019; multi 1; offset 0; oldest xid 706 in DB 1; oldest running xid 0; shutdown
2015-03-11 10:36:25 EDT [3074-1] LOG: startup process (PID 3075) exited with exit code 1
2015-03-11 10:36:25 EDT [3074-2] LOG: terminating any other active server processes
[fail]
root@postgres:~# tail -f /var/log/postgresql/postgresql-9.1-main.log
2015-03-11 10:36:25 EDT [3075-2] LOG: creating missing WAL directory "pg_xlog/archive_status"
2015-03-11 10:36:25 EDT [3075-3] LOG: restored log file "0000000B.history" from archive
2015-03-11 10:36:25 EDT [3075-4] LOG: starting point-in-time recovery to 2015-03-06 16:29:59-05
2015-03-11 10:36:25 EDT [3075-5] LOG: restored log file "0000000B000000000000004A" from archive
2015-03-11 10:36:25 EDT [3075-6] LOG: redo starts at 0/4A000078
2015-03-11 10:36:25 EDT [3075-7] LOG: restored log file "0000000B000000000000004B" from archive
2015-03-11 10:36:25 EDT [3075-8] FATAL: online backup was canceled, recovery cannot continue
2015-03-11 10:36:25 EDT [3075-9] CONTEXT: xlog redo checkpoint: redo 0/4B000020; tli 11; xid 0/19700; oid 28019; multi 1; offset 0; oldest xid 706 in DB 1; oldest running xid 0; shutdown
2015-03-11 10:36:25 EDT [3074-1] LOG: startup process (PID 3075) exited with exit code 1
2015-03-11 10:36:25 EDT [3074-2] LOG: terminating any other active server processes
Regrading with
Ferdous Shibly
The output of "barman diagnose" is
root@barman:~# barman diagnose
{
"global": {
"config": {
"barman_home": "/var/lib/barman",
"barman_user": "barman",
"log_file": "/var/log/barman/barman.log"
},
"system_info": {
"barman_ver": "1.4.0",
"kernel_ver": "Linux barman 3.16.0-23-generic #31-Ubuntu SMP Tue Oct 21 17:56:17 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux",
"python_ver": "Python 2.7.8",
"release": "Distributor ID:\tUbuntu\nDescription:\tUbuntu 14.10\nRelease:\t14.10\nCodename:\tutopic",
"rsync_ver": "rsync version 3.1.1 protocol version 31",
"ssh_ver": "OpenSSH_6.6.1p1 Ubuntu-8, OpenSSL 1.0.1f 6 Jan 2014"
}
},
"servers": {
"postgres": {
"backups": {
"20150305T135501": {
"backup_id": "20150305T135501",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 13:55:00 2015",
"begin_wal": "000000010000000000000005",
"begin_xlog": "0/5000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45298338,
"end_offset": "69112",
"end_time": "Thu Mar 5 13:55:18 2015",
"end_wal": "000000010000000000000005",
"end_xlog": "0/5010DF8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45298338,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T140002": {
"backup_id": "20150305T140002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 14:00:01 2015",
"begin_wal": "000000010000000000000007",
"begin_xlog": "0/7000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45339298,
"end_offset": "248",
"end_time": "Thu Mar 5 14:00:13 2015",
"end_wal": "000000010000000000000007",
"end_xlog": "0/70000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45339298,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T140501": {
"backup_id": "20150305T140501",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:05:01 2015",
"begin_wal": "000000010000000000000009",
"begin_xlog": "0/9000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45355682,
"end_offset": "15856",
"end_time": "Thu Mar 5 14:05:24 2015",
"end_wal": "000000010000000000000009",
"end_xlog": "0/9003DF0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45355682,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T141001": {
"backup_id": "20150305T141001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 14:10:01 2015",
"begin_wal": "00000001000000000000000B",
"begin_xlog": "0/B000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45355682,
"end_offset": "248",
"end_time": "Thu Mar 5 14:10:12 2015",
"end_wal": "00000001000000000000000B",
"end_xlog": "0/B0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45355682,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T141502": {
"backup_id": "20150305T141502",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:15:01 2015",
"begin_wal": "00000001000000000000000D",
"begin_xlog": "0/D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45355682,
"end_offset": "11024",
"end_time": "Thu Mar 5 14:15:17 2015",
"end_wal": "00000001000000000000000D",
"end_xlog": "0/D002B10",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45355682,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T142001": {
"backup_id": "20150305T142001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 14:20:01 2015",
"begin_wal": "00000001000000000000000F",
"begin_xlog": "0/F000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45355682,
"end_offset": "248",
"end_time": "Thu Mar 5 14:20:12 2015",
"end_wal": "00000001000000000000000F",
"end_xlog": "0/F0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45355682,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T142502": {
"backup_id": "20150305T142502",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:25:01 2015",
"begin_wal": "000000010000000000000011",
"begin_xlog": "0/11000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45355684,
"end_offset": "71664",
"end_time": "Thu Mar 5 14:25:17 2015",
"end_wal": "000000010000000000000011",
"end_xlog": "0/110117F0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45355684,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T143001": {
"backup_id": "20150305T143001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 14:30:01 2015",
"begin_wal": "000000010000000000000013",
"begin_xlog": "0/13000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45388452,
"end_offset": "248",
"end_time": "Thu Mar 5 14:30:12 2015",
"end_wal": "000000010000000000000013",
"end_xlog": "0/130000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45388452,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T143501": {
"backup_id": "20150305T143501",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:35:01 2015",
"begin_wal": "000000010000000000000015",
"begin_xlog": "0/15000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45396644,
"end_offset": "107200",
"end_time": "Thu Mar 5 14:35:28 2015",
"end_wal": "000000010000000000000015",
"end_xlog": "0/1501A2C0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45396644,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T144001": {
"backup_id": "20150305T144001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 14:40:01 2015",
"begin_wal": "000000010000000000000017",
"begin_xlog": "0/17000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45429412,
"end_offset": "5744",
"end_time": "Thu Mar 5 14:40:16 2015",
"end_wal": "000000010000000000000017",
"end_xlog": "0/17001670",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45429412,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T144501": {
"backup_id": "20150305T144501",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:45:00 2015",
"begin_wal": "000000010000000000000019",
"begin_xlog": "0/19000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45462180,
"end_offset": "20880",
"end_time": "Thu Mar 5 14:45:18 2015",
"end_wal": "000000010000000000000019",
"end_xlog": "0/19005190",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45462180,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T145001": {
"backup_id": "20150305T145001",
"backup_label": "None",
"begin_offset": "73144",
"begin_time": "Thu Mar 5 14:50:01 2015",
"begin_wal": "00000001000000000000001B",
"begin_xlog": "0/1B011DB8",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45462180,
"end_offset": "85016",
"end_time": "Thu Mar 5 14:50:23 2015",
"end_wal": "00000001000000000000001B",
"end_xlog": "0/1B014C18",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45462180,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T145501": {
"backup_id": "20150305T145501",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 14:55:01 2015",
"begin_wal": "00000001000000000000001D",
"begin_xlog": "0/1D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45462180,
"end_offset": "90232",
"end_time": "Thu Mar 5 14:55:17 2015",
"end_wal": "00000001000000000000001D",
"end_xlog": "0/1D016078",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45462180,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T150001": {
"backup_id": "20150305T150001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 15:00:00 2015",
"begin_wal": "00000001000000000000001F",
"begin_xlog": "0/1F000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45486756,
"end_offset": "123456",
"end_time": "Thu Mar 5 15:00:29 2015",
"end_wal": "00000001000000000000001F",
"end_xlog": "0/1F01E240",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45486756,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T151001": {
"backup_id": "20150305T151001",
"backup_label": "None",
"begin_offset": "44904",
"begin_time": "Thu Mar 5 15:10:01 2015",
"begin_wal": "000000010000000000000021",
"begin_xlog": "0/2100AF68",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45486756,
"end_offset": "99320",
"end_time": "Thu Mar 5 15:10:20 2015",
"end_wal": "000000010000000000000021",
"end_xlog": "0/210183F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45486756,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T152002": {
"backup_id": "20150305T152002",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 15:20:01 2015",
"begin_wal": "000000010000000000000023",
"begin_xlog": "0/23000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 45847204,
"end_offset": "215952",
"end_time": "Thu Mar 5 15:20:33 2015",
"end_wal": "000000010000000000000023",
"end_xlog": "0/23034B90",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 45847204,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T153001": {
"backup_id": "20150305T153001",
"backup_label": "None",
"begin_offset": "55720",
"begin_time": "Thu Mar 5 15:30:01 2015",
"begin_wal": "000000010000000000000025",
"begin_xlog": "0/2500D9A8",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 46224036,
"end_offset": "176784",
"end_time": "Thu Mar 5 15:30:23 2015",
"end_wal": "000000010000000000000025",
"end_xlog": "0/2502B290",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 46224036,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T154002": {
"backup_id": "20150305T154002",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 15:40:01 2015",
"begin_wal": "000000010000000000000027",
"begin_xlog": "0/27000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 46486180,
"end_offset": "160176",
"end_time": "Thu Mar 5 15:40:36 2015",
"end_wal": "000000010000000000000027",
"end_xlog": "0/270271B0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 46486180,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T155001": {
"backup_id": "20150305T155001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 15:50:00 2015",
"begin_wal": "000000010000000000000029",
"begin_xlog": "0/29000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 46944932,
"end_offset": "257512",
"end_time": "Thu Mar 5 15:50:45 2015",
"end_wal": "000000010000000000000029",
"end_xlog": "0/2903EDE8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 46944932,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T160002": {
"backup_id": "20150305T160002",
"backup_label": "None",
"begin_offset": "85976",
"begin_time": "Thu Mar 5 16:00:01 2015",
"begin_wal": "00000001000000000000002B",
"begin_xlog": "0/2B014FD8",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 47346340,
"end_offset": "197616",
"end_time": "Thu Mar 5 16:00:23 2015",
"end_wal": "00000001000000000000002B",
"end_xlog": "0/2B0303F0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 47346340,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T161001": {
"backup_id": "20150305T161001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 16:10:00 2015",
"begin_wal": "00000001000000000000002D",
"begin_xlog": "0/2D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 47739556,
"end_offset": "152992",
"end_time": "Thu Mar 5 16:10:39 2015",
"end_wal": "00000001000000000000002D",
"end_xlog": "0/2D0255A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 47739556,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T162001": {
"backup_id": "20150305T162001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Thu Mar 5 16:20:01 2015",
"begin_wal": "00000001000000000000002F",
"begin_xlog": "0/2F000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 48018084,
"end_offset": "10824",
"end_time": "Thu Mar 5 16:20:19 2015",
"end_wal": "00000001000000000000002F",
"end_xlog": "0/2F002A48",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 48018084,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T163001": {
"backup_id": "20150305T163001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 16:30:01 2015",
"begin_wal": "000000010000000000000031",
"begin_xlog": "0/31000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 48386724,
"end_offset": "449984",
"end_time": "Thu Mar 5 16:30:46 2015",
"end_wal": "000000010000000000000031",
"end_xlog": "0/3106DDC0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 48386724,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T164002": {
"backup_id": "20150305T164002",
"backup_label": "None",
"begin_offset": "189624",
"begin_time": "Thu Mar 5 16:40:01 2015",
"begin_wal": "000000010000000000000033",
"begin_xlog": "0/3302E4B8",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 48648868,
"end_offset": "341264",
"end_time": "Thu Mar 5 16:40:36 2015",
"end_wal": "000000010000000000000033",
"end_xlog": "0/33053510",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 48648868,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T165001": {
"backup_id": "20150305T165001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 16:50:00 2015",
"begin_wal": "000000010000000000000035",
"begin_xlog": "0/35000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 48984740,
"end_offset": "223256",
"end_time": "Thu Mar 5 16:50:42 2015",
"end_wal": "000000010000000000000035",
"end_xlog": "0/35036818",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 48984740,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T170002": {
"backup_id": "20150305T170002",
"backup_label": "None",
"begin_offset": "115216",
"begin_time": "Thu Mar 5 17:00:01 2015",
"begin_wal": "000000010000000000000037",
"begin_xlog": "0/3701C210",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49189540,
"end_offset": "243176",
"end_time": "Thu Mar 5 17:00:27 2015",
"end_wal": "000000010000000000000037",
"end_xlog": "0/3703B5E8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49189540,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T171001": {
"backup_id": "20150305T171001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 17:10:01 2015",
"begin_wal": "000000010000000000000039",
"begin_xlog": "0/39000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49386148,
"end_offset": "296952",
"end_time": "Thu Mar 5 17:10:41 2015",
"end_wal": "000000010000000000000039",
"end_xlog": "0/390487F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49386148,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T172001": {
"backup_id": "20150305T172001",
"backup_label": "None",
"begin_offset": "121872",
"begin_time": "Thu Mar 5 17:20:01 2015",
"begin_wal": "00000001000000000000003B",
"begin_xlog": "0/3B01DC10",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49599140,
"end_offset": "256304",
"end_time": "Thu Mar 5 17:20:27 2015",
"end_wal": "00000001000000000000003B",
"end_xlog": "0/3B03E930",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49599140,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T173001": {
"backup_id": "20150305T173001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 17:30:00 2015",
"begin_wal": "00000001000000000000003D",
"begin_xlog": "0/3D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49713828,
"end_offset": "160",
"end_time": "Thu Mar 5 17:30:13 2015",
"end_wal": "00000001000000000000003D",
"end_xlog": "0/3D0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49713828,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T174001": {
"backup_id": "20150305T174001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 17:40:00 2015",
"begin_wal": "000000010000000000000040",
"begin_xlog": "0/40000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49610968,
"end_offset": "16016",
"end_time": "Thu Mar 5 17:40:27 2015",
"end_wal": "000000010000000000000040",
"end_xlog": "0/40003E90",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49610968,
"status": "DONE",
"tablespaces": null,
"timeline": 1,
"version": 90115
},
"20150305T181001": {
"backup_id": "20150305T181001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 18:10:01 2015",
"begin_wal": "000000050000000000000043",
"begin_xlog": "0/43000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49611102,
"end_offset": "22416",
"end_time": "Thu Mar 5 18:10:18 2015",
"end_wal": "000000050000000000000043",
"end_xlog": "0/43005790",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49611102,
"status": "DONE",
"tablespaces": null,
"timeline": 5,
"version": 90115
},
"20150305T183001": {
"backup_id": "20150305T183001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Thu Mar 5 18:30:01 2015",
"begin_wal": "000000080000000000000043",
"begin_xlog": "0/43000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49611102,
"end_offset": "160",
"end_time": "Thu Mar 5 18:30:11 2015",
"end_wal": "000000080000000000000043",
"end_xlog": "0/430000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49611102,
"status": "DONE",
"tablespaces": null,
"timeline": 8,
"version": 90115
},
"20150306T095002": {
"backup_id": "20150306T095002",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 09:50:02 2015",
"begin_wal": "0000000B0000000000000044",
"begin_xlog": "0/44000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49611102,
"end_offset": "136808",
"end_time": "Fri Mar 6 09:50:25 2015",
"end_wal": "0000000B0000000000000044",
"end_xlog": "0/44021668",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49611102,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T100001": {
"backup_id": "20150306T100001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 10:00:01 2015",
"begin_wal": "0000000B0000000000000046",
"begin_xlog": "0/46000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49611102,
"end_offset": "160",
"end_time": "Fri Mar 6 10:00:18 2015",
"end_wal": "0000000B0000000000000046",
"end_xlog": "0/460000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49611102,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T113001": {
"backup_id": "20150306T113001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 11:30:01 2015",
"begin_wal": "0000000B000000000000004A",
"begin_xlog": "0/4A000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49627486,
"end_offset": "3352",
"end_time": "Fri Mar 6 11:30:21 2015",
"end_wal": "0000000B000000000000004A",
"end_xlog": "0/4A000D18",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49627486,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T114001": {
"backup_id": "20150306T114001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 11:40:01 2015",
"begin_wal": "0000000B000000000000004C",
"begin_xlog": "0/4C000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49627486,
"end_offset": "248",
"end_time": "Fri Mar 6 11:40:15 2015",
"end_wal": "0000000B000000000000004C",
"end_xlog": "0/4C0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49627486,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T115001": {
"backup_id": "20150306T115001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 11:50:01 2015",
"begin_wal": "0000000B000000000000004E",
"begin_xlog": "0/4E000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49635678,
"end_offset": "160",
"end_time": "Fri Mar 6 11:50:25 2015",
"end_wal": "0000000B000000000000004E",
"end_xlog": "0/4E0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49635678,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T120001": {
"backup_id": "20150306T120001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 12:00:01 2015",
"begin_wal": "0000000B0000000000000050",
"begin_xlog": "0/50000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49643870,
"end_offset": "248",
"end_time": "Fri Mar 6 12:00:12 2015",
"end_wal": "0000000B0000000000000050",
"end_xlog": "0/500000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49643870,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T121001": {
"backup_id": "20150306T121001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 12:10:01 2015",
"begin_wal": "0000000B0000000000000052",
"begin_xlog": "0/52000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49652062,
"end_offset": "160",
"end_time": "Fri Mar 6 12:10:16 2015",
"end_wal": "0000000B0000000000000052",
"end_xlog": "0/520000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49652062,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T122001": {
"backup_id": "20150306T122001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 12:20:01 2015",
"begin_wal": "0000000B0000000000000054",
"begin_xlog": "0/54000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49684830,
"end_offset": "248",
"end_time": "Fri Mar 6 12:20:13 2015",
"end_wal": "0000000B0000000000000054",
"end_xlog": "0/540000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49684830,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T123001": {
"backup_id": "20150306T123001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 12:30:01 2015",
"begin_wal": "0000000B0000000000000056",
"begin_xlog": "0/56000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49824402,
"end_offset": "160",
"end_time": "Fri Mar 6 12:30:14 2015",
"end_wal": "0000000B0000000000000056",
"end_xlog": "0/560000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49824402,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T124001": {
"backup_id": "20150306T124001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 12:40:01 2015",
"begin_wal": "0000000B0000000000000058",
"begin_xlog": "0/58000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49840786,
"end_offset": "248",
"end_time": "Fri Mar 6 12:40:13 2015",
"end_wal": "0000000B0000000000000058",
"end_xlog": "0/580000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49840786,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T140001": {
"backup_id": "20150306T140001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 14:00:01 2015",
"begin_wal": "0000000C0000000000000043",
"begin_xlog": "0/43000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49660258,
"end_offset": "160",
"end_time": "Fri Mar 6 14:00:16 2015",
"end_wal": "0000000C0000000000000043",
"end_xlog": "0/430000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49660258,
"status": "DONE",
"tablespaces": null,
"timeline": 12,
"version": 90115
},
"20150306T141001": {
"backup_id": "20150306T141001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 14:10:01 2015",
"begin_wal": "0000000B000000000000004D",
"begin_xlog": "0/4D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52642141,
"end_offset": "12760",
"end_time": "Fri Mar 6 14:10:16 2015",
"end_wal": "0000000B000000000000004D",
"end_xlog": "0/4D0031D8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52642141,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150306T143001": {
"backup_id": "20150306T143001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 14:30:01 2015",
"begin_wal": "0000000E0000000000000043",
"begin_xlog": "0/43000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49660258,
"end_offset": "160",
"end_time": "Fri Mar 6 14:30:17 2015",
"end_wal": "0000000E0000000000000043",
"end_xlog": "0/430000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49660258,
"status": "DONE",
"tablespaces": null,
"timeline": 14,
"version": 90115
},
"20150306T152001": {
"backup_id": "20150306T152001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 15:20:01 2015",
"begin_wal": "0000000F0000000000000043",
"begin_xlog": "0/43000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49405685,
"end_offset": "7448",
"end_time": "Fri Mar 6 15:20:10 2015",
"end_wal": "0000000F0000000000000043",
"end_xlog": "0/43001D18",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49405685,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T153001": {
"backup_id": "20150306T153001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 15:30:02 2015",
"begin_wal": "0000000F0000000000000045",
"begin_xlog": "0/45000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49512489,
"end_offset": "15920",
"end_time": "Fri Mar 6 15:30:12 2015",
"end_wal": "0000000F0000000000000045",
"end_xlog": "0/45003E30",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49512489,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T154001": {
"backup_id": "20150306T154001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 15:40:02 2015",
"begin_wal": "0000000F0000000000000047",
"begin_xlog": "0/47000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "5968",
"end_time": "Fri Mar 6 15:40:20 2015",
"end_wal": "0000000F0000000000000047",
"end_xlog": "0/47001750",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T155001": {
"backup_id": "20150306T155001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 15:50:01 2015",
"begin_wal": "0000000F0000000000000049",
"begin_xlog": "0/49000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "11248",
"end_time": "Fri Mar 6 15:50:17 2015",
"end_wal": "0000000F0000000000000049",
"end_xlog": "0/49002BF0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T160001": {
"backup_id": "20150306T160001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 16:00:01 2015",
"begin_wal": "0000000F000000000000004B",
"begin_xlog": "0/4B000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "16360",
"end_time": "Fri Mar 6 16:00:13 2015",
"end_wal": "0000000F000000000000004B",
"end_xlog": "0/4B003FE8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T161002": {
"backup_id": "20150306T161002",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 16:10:02 2015",
"begin_wal": "0000000F000000000000004D",
"begin_xlog": "0/4D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "7952",
"end_time": "Fri Mar 6 16:10:11 2015",
"end_wal": "0000000F000000000000004D",
"end_xlog": "0/4D001F10",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T162001": {
"backup_id": "20150306T162001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Fri Mar 6 16:20:02 2015",
"begin_wal": "0000000F000000000000004F",
"begin_xlog": "0/4F000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "12256",
"end_time": "Fri Mar 6 16:20:09 2015",
"end_wal": "0000000F000000000000004F",
"end_xlog": "0/4F002FE0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T163002": {
"backup_id": "20150306T163002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 16:30:02 2015",
"begin_wal": "0000000F0000000000000051",
"begin_xlog": "0/51000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "5064",
"end_time": "Fri Mar 6 16:30:13 2015",
"end_wal": "0000000F0000000000000051",
"end_xlog": "0/510013C8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150306T164002": {
"backup_id": "20150306T164002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Fri Mar 6 16:40:02 2015",
"begin_wal": "0000000F0000000000000053",
"begin_xlog": "0/53000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49528873,
"end_offset": "10280",
"end_time": "Fri Mar 6 16:40:15 2015",
"end_wal": "0000000F0000000000000053",
"end_xlog": "0/53002828",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49528873,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150307T111001": {
"backup_id": "20150307T111001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 11:10:01 2015",
"begin_wal": "0000000F0000000000000055",
"begin_xlog": "0/55000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49569833,
"end_offset": "160",
"end_time": "Sat Mar 7 11:10:11 2015",
"end_wal": "0000000F0000000000000055",
"end_xlog": "0/550000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49569833,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150307T112002": {
"backup_id": "20150307T112002",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 11:20:02 2015",
"begin_wal": "0000000F0000000000000057",
"begin_xlog": "0/57000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49569833,
"end_offset": "160",
"end_time": "Sat Mar 7 11:20:12 2015",
"end_wal": "0000000F0000000000000057",
"end_xlog": "0/570000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49569833,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150307T113001": {
"backup_id": "20150307T113001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 11:30:02 2015",
"begin_wal": "0000000F000000000000005A",
"begin_xlog": "0/5A000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 49569832,
"end_offset": "7920",
"end_time": "Sat Mar 7 11:30:14 2015",
"end_wal": "0000000F000000000000005A",
"end_xlog": "0/5A001EF0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 49569832,
"status": "DONE",
"tablespaces": null,
"timeline": 15,
"version": 90115
},
"20150307T114001": {
"backup_id": "20150307T114001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 11:40:01 2015",
"begin_wal": "0000000B0000000000000053",
"begin_xlog": "0/53000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52568105,
"end_offset": "84512",
"end_time": "Sat Mar 7 11:40:18 2015",
"end_wal": "0000000B0000000000000053",
"end_xlog": "0/53014A20",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52568105,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T115001": {
"backup_id": "20150307T115001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 11:50:01 2015",
"begin_wal": "0000000B0000000000000055",
"begin_xlog": "0/55000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52568105,
"end_offset": "248",
"end_time": "Sat Mar 7 11:50:13 2015",
"end_wal": "0000000B0000000000000055",
"end_xlog": "0/550000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52568105,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T120001": {
"backup_id": "20150307T120001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 12:00:01 2015",
"begin_wal": "0000000B0000000000000057",
"begin_xlog": "0/57000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52568105,
"end_offset": "160",
"end_time": "Sat Mar 7 12:00:11 2015",
"end_wal": "0000000B0000000000000057",
"end_xlog": "0/570000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52568105,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T121001": {
"backup_id": "20150307T121001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 12:10:02 2015",
"begin_wal": "0000000B0000000000000059",
"begin_xlog": "0/59000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52674909,
"end_offset": "248",
"end_time": "Sat Mar 7 12:10:13 2015",
"end_wal": "0000000B0000000000000059",
"end_xlog": "0/590000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52674909,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T122001": {
"backup_id": "20150307T122001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 12:20:01 2015",
"begin_wal": "0000000B000000000000005B",
"begin_xlog": "0/5B000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52674909,
"end_offset": "160",
"end_time": "Sat Mar 7 12:20:11 2015",
"end_wal": "0000000B000000000000005B",
"end_xlog": "0/5B0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52674909,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T123001": {
"backup_id": "20150307T123001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 12:30:01 2015",
"begin_wal": "0000000B000000000000005D",
"begin_xlog": "0/5D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52674909,
"end_offset": "160",
"end_time": "Sat Mar 7 12:30:09 2015",
"end_wal": "0000000B000000000000005D",
"end_xlog": "0/5D0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52674909,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T124001": {
"backup_id": "20150307T124001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 12:40:01 2015",
"begin_wal": "0000000B000000000000005F",
"begin_xlog": "0/5F000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52674909,
"end_offset": "248",
"end_time": "Sat Mar 7 12:40:13 2015",
"end_wal": "0000000B000000000000005F",
"end_xlog": "0/5F0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52674909,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T125001": {
"backup_id": "20150307T125001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 12:50:01 2015",
"begin_wal": "0000000B0000000000000061",
"begin_xlog": "0/61000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "160",
"end_time": "Sat Mar 7 12:50:17 2015",
"end_wal": "0000000B0000000000000061",
"end_xlog": "0/610000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T130001": {
"backup_id": "20150307T130001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 13:00:01 2015",
"begin_wal": "0000000B0000000000000063",
"begin_xlog": "0/63000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 13:00:11 2015",
"end_wal": "0000000B0000000000000063",
"end_xlog": "0/630000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T131001": {
"backup_id": "20150307T131001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 13:10:01 2015",
"begin_wal": "0000000B0000000000000065",
"begin_xlog": "0/65000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 13:10:09 2015",
"end_wal": "0000000B0000000000000065",
"end_xlog": "0/650000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T132001": {
"backup_id": "20150307T132001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 13:20:01 2015",
"begin_wal": "0000000B0000000000000067",
"begin_xlog": "0/67000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 13:20:11 2015",
"end_wal": "0000000B0000000000000067",
"end_xlog": "0/670000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T133001": {
"backup_id": "20150307T133001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 13:30:01 2015",
"begin_wal": "0000000B0000000000000069",
"begin_xlog": "0/69000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 13:30:11 2015",
"end_wal": "0000000B0000000000000069",
"end_xlog": "0/690000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T134001": {
"backup_id": "20150307T134001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 13:40:01 2015",
"begin_wal": "0000000B000000000000006B",
"begin_xlog": "0/6B000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 13:40:13 2015",
"end_wal": "0000000B000000000000006B",
"end_xlog": "0/6B0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T135001": {
"backup_id": "20150307T135001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 13:50:02 2015",
"begin_wal": "0000000B000000000000006D",
"begin_xlog": "0/6D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "160",
"end_time": "Sat Mar 7 13:50:17 2015",
"end_wal": "0000000B000000000000006D",
"end_xlog": "0/6D0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T140002": {
"backup_id": "20150307T140002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 14:00:02 2015",
"begin_wal": "0000000B000000000000006F",
"begin_xlog": "0/6F000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 14:00:12 2015",
"end_wal": "0000000B000000000000006F",
"end_xlog": "0/6F0000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T141002": {
"backup_id": "20150307T141002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 14:10:02 2015",
"begin_wal": "0000000B0000000000000071",
"begin_xlog": "0/71000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52691293,
"end_offset": "248",
"end_time": "Sat Mar 7 14:10:12 2015",
"end_wal": "0000000B0000000000000071",
"end_xlog": "0/710000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52691293,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T142002": {
"backup_id": "20150307T142002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 14:20:02 2015",
"begin_wal": "0000000B0000000000000073",
"begin_xlog": "0/73000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "248",
"end_time": "Sat Mar 7 14:20:12 2015",
"end_wal": "0000000B0000000000000073",
"end_xlog": "0/730000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T143001": {
"backup_id": "20150307T143001",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 14:30:02 2015",
"begin_wal": "0000000B0000000000000075",
"begin_xlog": "0/75000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "248",
"end_time": "Sat Mar 7 14:30:10 2015",
"end_wal": "0000000B0000000000000075",
"end_xlog": "0/750000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T144002": {
"backup_id": "20150307T144002",
"backup_label": "None",
"begin_offset": "120",
"begin_time": "Sat Mar 7 14:40:02 2015",
"begin_wal": "0000000B0000000000000077",
"begin_xlog": "0/77000078",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "248",
"end_time": "Sat Mar 7 14:40:14 2015",
"end_wal": "0000000B0000000000000077",
"end_xlog": "0/770000F8",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T145001": {
"backup_id": "20150307T145001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 14:50:02 2015",
"begin_wal": "0000000B0000000000000079",
"begin_xlog": "0/79000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "160",
"end_time": "Sat Mar 7 14:50:14 2015",
"end_wal": "0000000B0000000000000079",
"end_xlog": "0/790000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T150001": {
"backup_id": "20150307T150001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 15:00:01 2015",
"begin_wal": "0000000B000000000000007B",
"begin_xlog": "0/7B000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "160",
"end_time": "Sat Mar 7 15:00:12 2015",
"end_wal": "0000000B000000000000007B",
"end_xlog": "0/7B0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T151001": {
"backup_id": "20150307T151001",
"backup_label": "None",
"begin_offset": "32",
"begin_time": "Sat Mar 7 15:10:02 2015",
"begin_wal": "0000000B000000000000007D",
"begin_xlog": "0/7D000020",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"deduplicated_size": 52699485,
"end_offset": "160",
"end_time": "Sat Mar 7 15:10:12 2015",
"end_wal": "0000000B000000000000007D",
"end_xlog": "0/7D0000A0",
"error": null,
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"mode": "default",
"pgdata": "/var/lib/postgresql/9.1/main",
"server_name": "postgres",
"size": 52699485,
"status": "DONE",
"tablespaces": null,
"timeline": 11,
"version": 90115
},
"20150307T152001": {
"backup_id": "20150307T152001",
"backup_label": "None",
"begin_offset": null,
"begin_time": null,
"begin_wal": null,
"begin_xlog": null,
"config_file": null,
"deduplicated_size": null,
"end_offset": null,
"end_time": null,
"end_wal": null,
"end_xlog": null,
"error": "failure issuing start backup command (Cannot connect to postgres: could not connect to server: No route to host)",
"hba_file": null,
"ident_file": null,
"mode": "default",
"pgdata": null,
"server_name": "postgres",
"size": null,
"status": "FAILED",
"tablespaces": null,
"timeline": null,
"version": null
}
},
"config": {
"active": true,
"backup_directory": "/var/lib/barman/postgres",
"backup_options": "exclusive_backup",
"bandwidth_limit": null,
"barman_home": "/var/lib/barman",
"basebackup_retry_sleep": 30,
"basebackup_retry_times": 0,
"basebackups_directory": "/var/lib/barman/postgres/base",
"compression": null,
"conninfo": "host=192.168.56.115 user=postgres",
"custom_compression_filter": null,
"custom_decompression_filter": null,
"description": "Postgres Server on 192.168.56.115",
"immediate_checkpoint": false,
"incoming_wals_directory": "/var/lib/barman/postgres/incoming",
"last_backup_maximum_age": null,
"lock_file": "/var/lib/barman/postgres/postgres.lock",
"minimum_redundancy": 0,
"name": "postgres",
"network_compression": false,
"post_archive_script": null,
"post_backup_script": null,
"pre_archive_script": null,
"pre_backup_script": null,
"retention_policy": null,
"retention_policy_mode": "auto",
"reuse_backup": null,
"ssh_command": "ssh post...@192.168.56.115",
"tablespace_bandwidth_limit": null,
"wal_retention_policy": "main",
"wals_directory": "/var/lib/barman/postgres/wals"
},
"status": {
"archive_command": "rsync -a %p barman@barman:/var/lib/barman/postgres/incoming/%f",
"archive_mode": "on",
"config_file": "/etc/postgresql/9.1/main/postgresql.conf",
"current_xlog": "0000000B000000000000007F",
"data_directory": "/var/lib/postgresql/9.1/main",
"hba_file": "/etc/postgresql/9.1/main/pg_hba.conf",
"ident_file": "/etc/postgresql/9.1/main/pg_ident.conf",
"last_archived_wal": "0000000B000000000000007E",
"pgespresso_installed": false,
"server_txt_version": "9.1.15"
},
"system_info": {
"kernel_ver": "Linux postgres 3.16.0-23-generic #31-Ubuntu SMP Tue Oct 21 17:56:17 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux",
"python_ver": "Python 2.7.8",
"release": "Distributor ID:\tUbuntu\nDescription:\tUbuntu 14.10\nRelease:\t14.10\nCodename:\tutopic",
"rsync_ver": "rsync version 3.1.1 protocol version 31",
"ssh_ver": "OpenSSH_6.6.1p1 Ubuntu-8, OpenSSL 1.0.1f 6 Jan 2014"
}
}
}
}
On barman server when I am going to execute "barman recover --remote-ssh-command "ssh postgres@postgres" --target-time "2015-03-06 16:29:59.000" postgres 20150306T113001 /var/lib/postgresql/9.1/main" command, I am getting
Starting remote restore for server postgres using backup 20150306T113001
Destination directory: /var/lib/postgresql/9.1/main
Doing PITR. Recovery target time: '2015-03-06 16:29:59'
Using safe horizon time for smart rsync copy: 2015-03-06 11:30:01.878205-05:00
Copying the base backup.
Copying required wal segments.
Generating recovery.conf
Disabling dangerous settings in destination directory.
The archive_command was set to 'false' to prevent data losses.
Your PostgreSQL server has been successfully prepared for recovery!
Please review network and archive related settings in the PostgreSQL
configuration file before starting the just recovered instance.
WARNING: Before starting up the recovered PostgreSQL server,
please review also the settings of the following configuration
options as they might interfere with your current recovery attempt:
data_directory = '/var/lib/postgresql/9.1/main' # use data in another directory
external_pid_file = '/var/run/postgresql/9.1-main.pid' # write an extra PID file
hba_file = '/etc/postgresql/9.1/main/pg_hba.conf' # host-based authentication file
ident_file = '/etc/postgresql/9.1/main/pg_ident.conf' # ident configuration file
unix_socket_directory = '/var/run/postgresql' # (change requires restart)
Recovery completed successful.
But on postgres server when I am going to start postgres process I am getting
root@postgres:~# /etc/init.d/postgresql start
* Starting PostgreSQL 9.1 database server * The PostgreSQL server failed to start. Please check the log output:
2015-03-11 10:36:25 EDT [3075-1] LOG: database system was interrupted; last known up at 2015-03-06 11:30:12 EST
2015-03-11 10:36:25 EDT [3075-2] LOG: creating missing WAL directory "pg_xlog/archive_status"
2015-03-11 10:36:25 EDT [3075-3] LOG: restored log file "0000000B.history" from archive
2015-03-11 10:36:25 EDT [3075-4] LOG: starting point-in-time recovery to 2015-03-06 16:29:59-05
2015-03-11 10:36:25 EDT [3075-5] LOG: restored log file "0000000B000000000000004A" from archive
2015-03-11 10:36:25 EDT [3075-6] LOG: redo starts at 0/4A000078
2015-03-11 10:36:25 EDT [3075-7] LOG: restored log file "0000000B000000000000004B" from archive
2015-03-11 10:36:25 EDT [3075-8] FATAL: online backup was canceled, recovery cannot continue
2015-03-11 10:36:25 EDT [3075-9] CONTEXT: xlog redo checkpoint: redo 0/4B000020; tli 11; xid 0/19700; oid 28019; multi 1; offset 0; oldest xid 706 in DB 1; oldest running xid 0; shutdown
2015-03-11 10:36:25 EDT [3074-1] LOG: startup process (PID 3075) exited with exit code 1
2015-03-11 10:36:25 EDT [3074-2] LOG: terminating any other active server processes
[fail]
root@postgres:~# tail -f /var/log/postgresql/postgresql-9.1-main.log
2015-03-11 10:36:25 EDT [3075-2] LOG: creating missing WAL directory "pg_xlog/archive_status"
2015-03-11 10:36:25 EDT [3075-3] LOG: restored log file "0000000B.history" from archive
2015-03-11 10:36:25 EDT [3075-4] LOG: starting point-in-time recovery to 2015-03-06 16:29:59-05
2015-03-11 10:36:25 EDT [3075-5] LOG: restored log file "0000000B000000000000004A" from archive
2015-03-11 10:36:25 EDT [3075-6] LOG: redo starts at 0/4A000078
2015-03-11 10:36:25 EDT [3075-7] LOG: restored log file "0000000B000000000000004B" from archive
2015-03-11 10:36:25 EDT [3075-8] FATAL: online backup was canceled, recovery cannot continue
2015-03-11 10:36:25 EDT [3075-9] CONTEXT: xlog redo checkpoint: redo 0/4B000020; tli 11; xid 0/19700; oid 28019; multi 1; offset 0; oldest xid 706 in DB 1; oldest running xid 0; shutdown
2015-03-11 10:36:25 EDT [3074-1] LOG: startup process (PID 3075) exited with exit code 1
2015-03-11 10:36:25 EDT [3074-2] LOG: terminating any other active server processes
Regrading with
Ferdous Shibly
Marco Nenciarini
Mar 12, 2015, 6:20:59 AM3/12/15
to pgba...@googlegroups.com
Hi Ferdous,
Il 11/03/15 15:40, Ferdous Shibly ha scritto:
The weird thing is that event should generate an error and mark the corresponding backup as failed. I've just tried it and the output follows:
release/1.4.0$ barman backup all
Starting backup for server test-9.1 in /tmp/barman-tests/test-9.1/base/20150312T102358
Backup start at xlog location: 0/3000020 (000000010000000000000003, 00000020)
Copying files.
Copy done.
Backup size: 32.9 MiB
Asking PostgreSQL server to finalize the backup.
ERROR: Backup failed issuing stop of the backup.
DETAILS: Cannot terminate exclusive backup. You might have to manually execute pg_stop_backup() on your Postgres server
Looking at your diagnose output it looks like that the backup terminates with the 0000000B000000000000004A file, but the shutdown checkpoint is in the next segment 0000000B000000000000004B, so Postgres should go through it without issues.
Could you please try to produce a minimal procedure to replicate the issue on a brand new cluster?
Regards,
Marco
--
Marco Nenciarini - 2ndQuadrant Italy
Il 11/03/15 15:40, Ferdous Shibly ha scritto:
>
> But on postgres server when I am going to start postgres process I am getting
>
> root@postgres:~# /etc/init.d/postgresql start
> * Starting PostgreSQL 9.1 database server * The PostgreSQL server failed to start. Please check the log output:
> 2015-03-11 10:36:25 EDT [3075-1] LOG: database system was interrupted; last known up at 2015-03-06 11:30:12 EST
> 2015-03-11 10:36:25 EDT [3075-2] LOG: creating missing WAL directory "pg_xlog/archive_status"
> 2015-03-11 10:36:25 EDT [3075-3] LOG: restored log file "0000000B.history" from archive
> 2015-03-11 10:36:25 EDT [3075-4] LOG: starting point-in-time recovery to 2015-03-06 16:29:59-05
> 2015-03-11 10:36:25 EDT [3075-5] LOG: restored log file "0000000B000000000000004A" from archive
> 2015-03-11 10:36:25 EDT [3075-6] LOG: redo starts at 0/4A000078
> 2015-03-11 10:36:25 EDT [3075-7] LOG: restored log file "0000000B000000000000004B" from archive
> 2015-03-11 10:36:25 EDT [3075-8] FATAL: online backup was canceled, recovery cannot continue
> 2015-03-11 10:36:25 EDT [3075-9] CONTEXT: xlog redo checkpoint: redo 0/4B000020; tli 11; xid 0/19700; oid 28019; multi 1; offset 0; oldest xid 706 in DB 1; oldest running xid 0; shutdown
> 2015-03-11 10:36:25 EDT [3074-1] LOG: startup process (PID 3075) exited with exit code 1
> 2015-03-11 10:36:25 EDT [3074-2] LOG: terminating any other active server processes
> [fail]
The log line "FATAL: online backup was canceled, recovery cannot continue" normally means that the backup is not valid because Postgres has been restarted during the backup.
> But on postgres server when I am going to start postgres process I am getting
>
> root@postgres:~# /etc/init.d/postgresql start
> * Starting PostgreSQL 9.1 database server * The PostgreSQL server failed to start. Please check the log output:
> 2015-03-11 10:36:25 EDT [3075-1] LOG: database system was interrupted; last known up at 2015-03-06 11:30:12 EST
> 2015-03-11 10:36:25 EDT [3075-2] LOG: creating missing WAL directory "pg_xlog/archive_status"
> 2015-03-11 10:36:25 EDT [3075-3] LOG: restored log file "0000000B.history" from archive
> 2015-03-11 10:36:25 EDT [3075-4] LOG: starting point-in-time recovery to 2015-03-06 16:29:59-05
> 2015-03-11 10:36:25 EDT [3075-5] LOG: restored log file "0000000B000000000000004A" from archive
> 2015-03-11 10:36:25 EDT [3075-6] LOG: redo starts at 0/4A000078
> 2015-03-11 10:36:25 EDT [3075-7] LOG: restored log file "0000000B000000000000004B" from archive
> 2015-03-11 10:36:25 EDT [3075-8] FATAL: online backup was canceled, recovery cannot continue
> 2015-03-11 10:36:25 EDT [3075-9] CONTEXT: xlog redo checkpoint: redo 0/4B000020; tli 11; xid 0/19700; oid 28019; multi 1; offset 0; oldest xid 706 in DB 1; oldest running xid 0; shutdown
> 2015-03-11 10:36:25 EDT [3074-1] LOG: startup process (PID 3075) exited with exit code 1
> 2015-03-11 10:36:25 EDT [3074-2] LOG: terminating any other active server processes
> [fail]
The weird thing is that event should generate an error and mark the corresponding backup as failed. I've just tried it and the output follows:
release/1.4.0$ barman backup all
Starting backup for server test-9.1 in /tmp/barman-tests/test-9.1/base/20150312T102358
Backup start at xlog location: 0/3000020 (000000010000000000000003, 00000020)
Copying files.
Copy done.
Backup size: 32.9 MiB
Asking PostgreSQL server to finalize the backup.
ERROR: Backup failed issuing stop of the backup.
DETAILS: Cannot terminate exclusive backup. You might have to manually execute pg_stop_backup() on your Postgres server
Looking at your diagnose output it looks like that the backup terminates with the 0000000B000000000000004A file, but the shutdown checkpoint is in the next segment 0000000B000000000000004B, so Postgres should go through it without issues.
Could you please try to produce a minimal procedure to replicate the issue on a brand new cluster?
Regards,
Marco
--
Marco Nenciarini - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
marco.ne...@2ndQuadrant.it | www.2ndQuadrant.it
Reply all
Reply to author
Forward
0 new messages