{"action":"created","issue":{"url":"https://api.github.com/repos/2ndquadrant-it/barman/issues/47","repository_url":"https://api.github.com/repos/2ndquadrant-it/barman","labels_url":"https://api.github.com/repos/2ndquadrant-it/barman/issues/47/labels{/name}","comments_url":"https://api.github.com/repos/2ndquadrant-it/barman/issues/47/comments","events_url":"https://api.github.com/repos/2ndquadrant-it/barman/issues/47/events","html_url":"https://github.com/2ndquadrant-it/barman/issues/47","id":168347922,"number":47,"title":"How to verify backups?","user":{"login":"alexmipego","id":123188,"avatar_url":"https://avatars.githubusercontent.com/u/123188?v=3","gravatar_id":"","url":"https://api.github.com/users/alexmipego","html_url":"https://github.com/alexmipego","followers_url":"https://api.github.com/users/alexmipego/followers","following_url":"https://api.github.com/users/alexmipego/following{/other_user}","gists_url":"https://api.github.com/users/alexmipego/gists{/gist_id}","starred_url":"https://api.github.com/users/alexmipego/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alexmipego/subscriptions","organizations_url":"https://api.github.com/users/alexmipego/orgs","repos_url":"https://api.github.com/users/alexmipego/repos","events_url":"https://api.github.com/users/alexmipego/events{/privacy}","received_events_url":"https://api.github.com/users/alexmipego/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-29T15:15:32Z","updated_at":"2016-09-13T17:12:38Z","closed_at":null,"body":"I'm still learning barman and postgres backups and I'm lost on how to validate that everything is running fine. I've everything setup with docker containers and cron jobs that run barman cron and barman backup every 1 and 15 minutes respectively.\r\n\r\nSince the clusters are large (+- 50GB each) the backup part takes a long time and uses a lot of resources. So, after reading more docs I realized I don't need full backups every 15 minutes since the WAL files have everything for PITR, however I do not understand exactly how do you know if your \"backup chain\" is complete...\r\n\r\nIf I had barman backup running each 24h but I stopped barman for a few hours, and Postgres deleted some wal files, what happens when I restart barman? Will it warn me or let me know about the issue somehow?\r\n\r\nIf I understand it correctly, wal_keep_segments=150, would always keep 150 wal files just in case, but if postgres needed to create (eg) 200 WAL files it wouldn't keep the extra 50 right?\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/2ndquadrant-it/barman/issues/comments/246753914","html_url":"https://github.com/2ndquadrant-it/barman/issues/47#issuecomment-246753914","issue_url":"https://api.github.com/repos/2ndquadrant-it/barman/issues/47","id":246753914,"user":{"login":"snuxoll","id":36403,"avatar_url":"https://avatars.githubusercontent.com/u/36403?v=3","gravatar_id":"","url":"https://api.github.com/users/snuxoll","html_url":"https://github.com/snuxoll","followers_url":"https://api.github.com/users/snuxoll/followers","following_url":"https://api.github.com/users/snuxoll/following{/other_user}","gists_url":"https://api.github.com/users/snuxoll/gists{/gist_id}","starred_url":"https://api.github.com/users/snuxoll/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/snuxoll/subscriptions","organizations_url":"https://api.github.com/users/snuxoll/orgs","repos_url":"https://api.github.com/users/snuxoll/repos","events_url":"https://api.github.com/users/snuxoll/events{/privacy}","received_events_url":"https://api.github.com/users/snuxoll/received_events","type":"User","site_admin":false},"created_at":"2016-09-13T17:12:38Z","updated_at":"2016-09-13T17:12:38Z","body":"As far as I'm aware wal_keep_segments only affects replication, if your archive_command is failing because your server running barman is down PostgreSQL will continue to accumulate WAL segments until they are able to be successfully archived. Personal anectode: my barman server went down for a couple days without me noticing (bad, I know) because the disk used to store backups filled up, my databases then crashed because they ran out of space due to log segments not being archived."}}
{"actor":{"display_login":"snuxoll"}}