)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":10295,"name":"mariam john","email":"mariamj@us.ibm.com","username":"mariamj"},"change_message_id":"da876d7856fa614c148ae99eaa601f565ffecfcf","unresolved":false,"context_lines":[{"line_number":9,"context_line":"Spec describing the WAL-file based approach for"},{"line_number":10,"context_line":"incremental backup and restore in Postgres."},{"line_number":11,"context_line":""},{"line_number":12,"context_line":"Change-Id: Icaed32eb6f6b18005dd281666d15e14ff3c1f11f"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":1,"id":"da85f559_565a822b","line":12,"updated":"2015-11-10 20:23:13.000000000","message":"Need to add implements blueprint here","commit_id":"f1e30992e2400a0382138710c0139f875103c3e8"}],"specs/mitaka/pgsql-incremental-backup.rst":[{"author":{"_account_id":9746,"name":"Doug Shelley","email":"dougshelley66@gmail.com","username":"dougshelley"},"change_message_id":"edb4e5ac6d3d5e9dd295ab71f4845f92bc2aff6c","unresolved":false,"context_lines":[{"line_number":178,"context_line":"Public API"},{"line_number":179,"context_line":"----------"},{"line_number":180,"context_line":""},{"line_number":181,"context_line":"None."},{"line_number":182,"context_line":""},{"line_number":183,"context_line":""},{"line_number":184,"context_line":"Public API Security"}],"source_content_type":"text/x-rst","patch_set":1,"id":"da85f559_708c7735","line":181,"updated":"2015-11-10 16:47:40.000000000","message":"should we specify which API options will now be available?","commit_id":"f1e30992e2400a0382138710c0139f875103c3e8"},{"author":{"_account_id":9746,"name":"Doug Shelley","email":"dougshelley66@gmail.com","username":"dougshelley"},"change_message_id":"edb4e5ac6d3d5e9dd295ab71f4845f92bc2aff6c","unresolved":false,"context_lines":[{"line_number":199,"context_line":"After implementation, the following CLI command will work::"},{"line_number":200,"context_line":""},{"line_number":201,"context_line":"    trove backup-create mypginst mybak --parent \u003cbackup_id\u003e"},{"line_number":202,"context_line":""},{"line_number":203,"context_line":""},{"line_number":204,"context_line":"Internal API"},{"line_number":205,"context_line":"------------"}],"source_content_type":"text/x-rst","patch_set":1,"id":"da85f559_b0a97f7d","line":202,"updated":"2015-11-10 16:47:40.000000000","message":"i presume that trove create --backup where the backup is an incremental will now work too?","commit_id":"f1e30992e2400a0382138710c0139f875103c3e8"},{"author":{"_account_id":9664,"name":"amrith","email":"amrith.kumar@gmail.com","username":"amrith"},"change_message_id":"2f9152c97ac500b9fc21bce18ab1bc1ea0ce5cf9","unresolved":false,"context_lines":[{"line_number":12,"context_line":""},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":15,"context_line":"PostgreSQL Incremental Backup"},{"line_number":16,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":17,"context_line":""},{"line_number":18,"context_line":".. If section numbers are desired, unindent this"}],"source_content_type":"text/x-rst","patch_set":2,"id":"da85f559_812a46e6","line":15,"updated":"2015-11-13 12:31:27.000000000","message":"and restore ;)","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":10440,"name":"Alex Tomic","email":"atomic777@gmail.com","username":"atomic77"},"change_message_id":"85c54f101bb9e9b082c42c61246680d20ec47852","unresolved":false,"context_lines":[{"line_number":12,"context_line":""},{"line_number":13,"context_line":""},{"line_number":14,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":15,"context_line":"PostgreSQL Incremental Backup"},{"line_number":16,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":17,"context_line":""},{"line_number":18,"context_line":".. If section numbers are desired, unindent this"}],"source_content_type":"text/x-rst","patch_set":2,"id":"da85f559_7b16e6a8","line":15,"in_reply_to":"da85f559_812a46e6","updated":"2015-11-13 15:57:01.000000000","message":"Hm.. why would you ever want to restore :)","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":17360,"name":"Ishita Mandhan","email":"imandha@us.ibm.com","username":"imandhan"},"change_message_id":"69aec901d265213fee1ef4ffc3909913c7af8dd1","unresolved":false,"context_lines":[{"line_number":75,"context_line":"file."},{"line_number":76,"context_line":""},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"Incremental Recovery and WAL Archiving"},{"line_number":79,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"},{"line_number":80,"context_line":""},{"line_number":81,"context_line":"PostgreSQL does not perform incremental backups in the same way that databases"}],"source_content_type":"text/x-rst","patch_set":2,"id":"ba8a016a_a39cad0e","line":78,"updated":"2015-11-18 22:56:07.000000000","message":"So I was a little confused by the term incremental recovery here since the spec title is incremental backup. What I understand is in actuality the recovery is truly incremental but the backup is a base backup followed by WAL files?","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":10440,"name":"Alex Tomic","email":"atomic777@gmail.com","username":"atomic77"},"change_message_id":"bf565a94359c1d0230e486b606dc49f0e269c78c","unresolved":false,"context_lines":[{"line_number":75,"context_line":"file."},{"line_number":76,"context_line":""},{"line_number":77,"context_line":""},{"line_number":78,"context_line":"Incremental Recovery and WAL Archiving"},{"line_number":79,"context_line":"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~"},{"line_number":80,"context_line":""},{"line_number":81,"context_line":"PostgreSQL does not perform incremental backups in the same way that databases"}],"source_content_type":"text/x-rst","patch_set":2,"id":"9a8ffd7b_84026a0a","line":78,"in_reply_to":"ba8a016a_a39cad0e","updated":"2015-11-30 17:24:47.000000000","message":"I will try to make this a bit clearer, I\u0027m a bit too loose with terminology. I also kind of assume that if we talk about backups we assume we want to be able to restore them -- the comment amrith made above :) \n\nThe point I\u0027m trying to make here is that to do incremental backup and restore in pgsql is really to bootstrap the recovery system. You are taking a \u0027base\u0027 backup plus some number of log files to allow you to recover to a certain point.","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":17360,"name":"Ishita Mandhan","email":"imandha@us.ibm.com","username":"imandhan"},"change_message_id":"69aec901d265213fee1ef4ffc3909913c7af8dd1","unresolved":false,"context_lines":[{"line_number":167,"context_line":"Configuration"},{"line_number":168,"context_line":"-------------"},{"line_number":169,"context_line":""},{"line_number":170,"context_line":"The new incremental backup strategy will need to be added."},{"line_number":171,"context_line":""},{"line_number":172,"context_line":"Database"},{"line_number":173,"context_line":"--------"}],"source_content_type":"text/x-rst","patch_set":2,"id":"ba8a016a_232d1da8","line":170,"updated":"2015-11-18 22:56:07.000000000","message":"What about recovery strategy, will that need to be different from the current restore strategy?","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":10440,"name":"Alex Tomic","email":"atomic777@gmail.com","username":"atomic77"},"change_message_id":"bf565a94359c1d0230e486b606dc49f0e269c78c","unresolved":false,"context_lines":[{"line_number":167,"context_line":"Configuration"},{"line_number":168,"context_line":"-------------"},{"line_number":169,"context_line":""},{"line_number":170,"context_line":"The new incremental backup strategy will need to be added."},{"line_number":171,"context_line":""},{"line_number":172,"context_line":"Database"},{"line_number":173,"context_line":"--------"}],"source_content_type":"text/x-rst","patch_set":2,"id":"9a8ffd7b_e75578fa","line":170,"in_reply_to":"ba8a016a_232d1da8","updated":"2015-11-30 17:24:47.000000000","message":"Done","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":9664,"name":"amrith","email":"amrith.kumar@gmail.com","username":"amrith"},"change_message_id":"2f9152c97ac500b9fc21bce18ab1bc1ea0ce5cf9","unresolved":false,"context_lines":[{"line_number":228,"context_line":"fast compressor such as Snappy or LZOP, encrypt and then ship the file to"},{"line_number":229,"context_line":"Swift directly, with an equivalent reverse procedure for recovery."},{"line_number":230,"context_line":""},{"line_number":231,"context_line":"This has the benefit of being simpler to implement, as most log handling is"},{"line_number":232,"context_line":"pushed down to PostgreSQL, but has the significant side-effect of introducing"},{"line_number":233,"context_line":"a relatively continuous stream of WAL data from the PostgreSQL guest to Swift,"},{"line_number":234,"context_line":"something potentially unexpected and not consistent with the approach to"}],"source_content_type":"text/x-rst","patch_set":2,"id":"da85f559_21235a07","line":231,"updated":"2015-11-13 12:31:27.000000000","message":"This is an interesting approach and certainly worth considering seriously.","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":10440,"name":"Alex Tomic","email":"atomic777@gmail.com","username":"atomic77"},"change_message_id":"85c54f101bb9e9b082c42c61246680d20ec47852","unresolved":false,"context_lines":[{"line_number":228,"context_line":"fast compressor such as Snappy or LZOP, encrypt and then ship the file to"},{"line_number":229,"context_line":"Swift directly, with an equivalent reverse procedure for recovery."},{"line_number":230,"context_line":""},{"line_number":231,"context_line":"This has the benefit of being simpler to implement, as most log handling is"},{"line_number":232,"context_line":"pushed down to PostgreSQL, but has the significant side-effect of introducing"},{"line_number":233,"context_line":"a relatively continuous stream of WAL data from the PostgreSQL guest to Swift,"},{"line_number":234,"context_line":"something potentially unexpected and not consistent with the approach to"}],"source_content_type":"text/x-rst","patch_set":2,"id":"da85f559_bbc68d14","line":231,"in_reply_to":"da85f559_21235a07","updated":"2015-11-13 15:57:01.000000000","message":"This was the way I favoured initially, partly inspired by what the tool WAL-E does [1] , but after some discussions we thought that it could be quite confusing for users that doing a first backup causes a continuous trickle of data to Swift. \n\nIf we decide to go with the first approach, perhaps a follow-up blueprint could be to provide a subclassed strategy that enables tighter swift integration for those users that know they want it.\n\nhttps://github.com/wal-e/wal-e","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":17360,"name":"Ishita Mandhan","email":"imandha@us.ibm.com","username":"imandhan"},"change_message_id":"69aec901d265213fee1ef4ffc3909913c7af8dd1","unresolved":false,"context_lines":[{"line_number":262,"context_line":"Upgrade Implications"},{"line_number":263,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":264,"context_line":""},{"line_number":265,"context_line":"Backups taken with the old PgDump strategy will not be compatible with this new"},{"line_number":266,"context_line":"strategy."},{"line_number":267,"context_line":""},{"line_number":268,"context_line":""}],"source_content_type":"text/x-rst","patch_set":2,"id":"ba8a016a_51326af3","line":265,"updated":"2015-11-18 22:56:07.000000000","message":"Will that mean that those backups won\u0027t be possible or will it be up to the user to chose either/or?","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":10440,"name":"Alex Tomic","email":"atomic777@gmail.com","username":"atomic77"},"change_message_id":"bf565a94359c1d0230e486b606dc49f0e269c78c","unresolved":false,"context_lines":[{"line_number":262,"context_line":"Upgrade Implications"},{"line_number":263,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"},{"line_number":264,"context_line":""},{"line_number":265,"context_line":"Backups taken with the old PgDump strategy will not be compatible with this new"},{"line_number":266,"context_line":"strategy."},{"line_number":267,"context_line":""},{"line_number":268,"context_line":""}],"source_content_type":"text/x-rst","patch_set":2,"id":"9a8ffd7b_a7ae90e5","line":265,"in_reply_to":"ba8a016a_51326af3","updated":"2015-11-30 17:24:47.000000000","message":"They will be able to choose the strategy they wish to use with the configuration parameters that point to the strategy, but the backups are not compatible","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":17360,"name":"Ishita Mandhan","email":"imandha@us.ibm.com","username":"imandhan"},"change_message_id":"69aec901d265213fee1ef4ffc3909913c7af8dd1","unresolved":false,"context_lines":[{"line_number":276,"context_line":""},{"line_number":277,"context_line":"Int-tests for incremental backup currently do not exist in the new generic"},{"line_number":278,"context_line":"int-test framework and will be added."},{"line_number":279,"context_line":""},{"line_number":280,"context_line":""},{"line_number":281,"context_line":"Documentation Impact"},{"line_number":282,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"}],"source_content_type":"text/x-rst","patch_set":2,"id":"ba8a016a_315486fd","line":279,"updated":"2015-11-18 22:56:07.000000000","message":"unit tests?","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"},{"author":{"_account_id":10440,"name":"Alex Tomic","email":"atomic777@gmail.com","username":"atomic77"},"change_message_id":"bf565a94359c1d0230e486b606dc49f0e269c78c","unresolved":false,"context_lines":[{"line_number":276,"context_line":""},{"line_number":277,"context_line":"Int-tests for incremental backup currently do not exist in the new generic"},{"line_number":278,"context_line":"int-test framework and will be added."},{"line_number":279,"context_line":""},{"line_number":280,"context_line":""},{"line_number":281,"context_line":"Documentation Impact"},{"line_number":282,"context_line":"\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d\u003d"}],"source_content_type":"text/x-rst","patch_set":2,"id":"9a8ffd7b_07f75cf6","line":279,"in_reply_to":"ba8a016a_315486fd","updated":"2015-11-30 17:24:47.000000000","message":"I guess that wouldn\u0027t hurt :)","commit_id":"773636dce7b70bd4c3df0614adb8868cbb16b7a7"}]}
