Life with Open Source

commit   : 93067c53ae49eaa1fe7bedaf2ba4e3e8f2a6cbfa    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 17:28:16 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 17:28:16 -0400    

commit   : a711d6a31c36d0a2ecf44755c1f3b78e682b4225    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 11:40:48 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 11:40:48 -0400    

commit   : ca3f8299ef4e02efb821f082519ea4ca680e4fc1    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 17:26:11 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 17:26:11 -0400    

commit   : d25183c4e3dadd573935a2ed1a2cbb103fa162db    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 11:40:48 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 11:40:48 -0400    

commit   : 8c894c5ff58ff41b59f1ba5c9d487aa9c3073a2f    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 17:24:28 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 17:24:28 -0400    

commit   : e13c30c18095beac42e688340c8003a6ca6c9d87    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 11:40:48 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 11:40:48 -0400    

commit   : 254bb39b720426f7a4616cb6b40f810c44b24b20    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 17:21:42 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 17:21:42 -0400    

commit   : c72a656725ef07fb8752333e0f3bdaf3c0aee999    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 11:40:47 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 28 Aug 2017 11:40:47 -0400    

commit   : 84caca0f341982d7d61d1c310faf5c6a3a601a48    
  
author   : David Steele <david@crunchydata.com>    
date     : Wed, 9 Aug 2017 11:50:02 -0400    
  
committer: David Steele <david@crunchydata.com>    
date     : Wed, 9 Aug 2017 11:50:02 -0400    

Bug Fixes:  
  
* Fixed authentication issue in S3 retry.  

commit   : cbc026418cdc03bbe645a3c44ccf9e40435c62ca    
  
author   : David Steele <david@pgmasters.net>    
date     : Tue, 8 Aug 2017 18:09:07 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Tue, 8 Aug 2017 18:09:07 -0400    

Bug Fixes:  
  
* The archive_status directory is now recreated on restore to support PostgreSQL 8.3 which does not recreate it automatically like more recent versions do. (Reported by Stephen Frost.)  
* Fixed an issue that could cause the empty archive directory for an old PostgreSQL version to be left behind after a stanza-upgrade. (Fixed by Cynthia Shang.)  
  
Features:  
  
* Modified the info command (both text and JSON output) to display the archive ID and minimum/maximum WAL currently present in the archive for the current and prior, if any, database cluster version. (Contributed by Cynthia Shang.)  
* Added --backup-ssh-port and --db-ssh-port options to support non-default SSH ports. (Contributed by Cynthia Shang.)  
  
Refactoring:  
  
* Retry when S3 returns an internal error (500).  
* Add bIgnoreMissing parameter to Local->manifest().  

commit   : 56fc4f7c9c8168b93b45ccf48781d77073d271dc    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Aug 2017 17:19:50 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Aug 2017 17:19:50 -0400    

commit   : 5fa4515a6a8536684285bc4837ec352fe2afe012    
  
author   : Peter Eisentraut <peter_e@gmx.net>    
date     : Mon, 7 Aug 2017 13:52:45 -0400    
  
committer: Peter Eisentraut <peter_e@gmx.net>    
date     : Mon, 7 Aug 2017 13:52:45 -0400    

commit   : a5915db2fab1fbe555b6410440df5177a247a2f2    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Aug 2017 17:17:46 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Aug 2017 17:17:46 -0400    

commit   : 61f52850f5809ff62b8d2605ded0503f6a822ec9    
  
author   : Peter Eisentraut <peter_e@gmx.net>    
date     : Mon, 7 Aug 2017 13:51:07 -0400    
  
committer: Peter Eisentraut <peter_e@gmx.net>    
date     : Mon, 7 Aug 2017 13:51:07 -0400    

commit   : 6d81d0a215a5b843bf003b0a1c4b43f6d2cccc78    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Aug 2017 17:15:44 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Aug 2017 17:15:44 -0400    

commit   : 7ba2831555e71a5c8ad63bdca9f8006684772a16    
  
author   : Peter Eisentraut <peter_e@gmx.net>    
date     : Mon, 7 Aug 2017 13:49:26 -0400    
  
committer: Peter Eisentraut <peter_e@gmx.net>    
date     : Mon, 7 Aug 2017 13:49:26 -0400    

commit   : 029386ccbddd0a33d481b94e511f5219b03e6636    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Aug 2017 17:13:41 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Aug 2017 17:13:41 -0400    

commit   : caada7c9bdbc41f4204516a099e25b85cd846004    
  
author   : Peter Eisentraut <peter_e@gmx.net>    
date     : Mon, 7 Aug 2017 13:43:43 -0400    
  
committer: Peter Eisentraut <peter_e@gmx.net>    
date     : Mon, 7 Aug 2017 13:43:43 -0400    

commit   : eca2f8a7dd9bda862a25fcc57ddf77f7c0dc3afe    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Aug 2017 17:10:58 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Aug 2017 17:10:58 -0400    

commit   : aa0f366d557c32aa29a1cae9d13d6d078b514abd    
  
author   : Peter Eisentraut <peter_e@gmx.net>    
date     : Mon, 7 Aug 2017 13:42:43 -0400    
  
committer: Peter Eisentraut <peter_e@gmx.net>    
date     : Mon, 7 Aug 2017 13:42:43 -0400    

commit   : d0fb52d446ed10cafe304aed16b193c1803cd906    
  
author   : David Steele <david@crunchydata.com>    
date     : Wed, 28 Jun 2017 11:22:01 -0400    
  
committer: David Steele <david@crunchydata.com>    
date     : Wed, 28 Jun 2017 11:22:01 -0400    

The 9.5 version of the extension was accidentally left at 1.0 which does not reflect the various updates. The default is now set to 1.0.6 and an empty update script is included. Run:  
  
alter extension pgaudit update to '1.0.6'  
  
to update the extension version to 1.0.6, though there are no apparent problems with leaving it at 1.0.  

commit   : 33d769e14786098b6fa02e666c624531dc7d5bea    
  
author   : David Steele <david@pgmasters.net>    
date     : Tue, 27 Jun 2017 22:42:31 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Tue, 27 Jun 2017 22:42:31 -0400    

Bug Fixes:  
  
* Fixed an issue that prevented tablespaces from being backed up on PostgreSQL ≤ 8.4.  
* Fixed missing flag in C library build that resulted in a mismatched binary on 32-bit systems. (Reported by Adrian Vondendriesch.)  
  
Features:  
  
* Add s3-repo-ca-path and s3-repo-ca-file options to accommodate systems where CAs are not automatically found by IO::Socket::SSL, i.e. RHEL7, or to load custom CAs. (Suggested by Scott Frazer.)  
  
Refactoring:  
  
* Harden protocol handshake to handle race conditions.  
* Fixed misleading error message when a file was opened for write in a missing directory.  
* Change log level of hardlink logging to detail.  
* Cast size in S3 manifest to integer.  
* Rename Archive modules to remove redundancy.  
* Improve S3 error reporting.  
* Minor optimizations to package loads and ordering for archive-get and archive-push commands.  

commit   : 7befa053a559c988387ba04394faa2d8a7c3203b    
  
author   : David Steele <david@crunchydata.com>    
date     : Mon, 26 Jun 2017 12:20:13 -0400    
  
committer: David Steele <david@crunchydata.com>    
date     : Mon, 26 Jun 2017 12:20:13 -0400    

commit   : 76cf424da01a48daa358a4b2391eaaf6af5f1717    
  
author   : David Steele <david@crunchydata.com>    
date     : Mon, 26 Jun 2017 10:48:50 -0400    
  
committer: David Steele <david@crunchydata.com>    
date     : Mon, 26 Jun 2017 10:48:50 -0400    

commit   : c10c5bb0ef1de519371e1bdae0b9da7cf8670c95    
  
author   : David Steele <david@crunchydata.com>    
date     : Mon, 12 Jun 2017 11:36:00 -0400    
  
committer: David Steele <david@crunchydata.com>    
date     : Mon, 12 Jun 2017 11:36:00 -0400    

Bug Fixes:  
  
* Fixed the info command so the WAL archive min/max displayed is for the current database version. (Fixed by Cynthia Shang.)  
* Fixed the backup command so the backup-standby option is reset (and the backup proceeds on the master) if the standby is not configured and/or reachable. (Fixed by Cynthia Shang.)  
* Fixed config warnings raised from a remote process causing errors in the master process. (Fixed by Cynthia Shang.)  
  
Features:  
  
* Amazon S3 repository support. (Reviewed by Cynthia Shang.)  
  
Refactoring:  
  
* Refactor storage layer to allow for new repository filesystems using drivers. (Reviewed by Cynthia Shang.)  
* Refactor IO layer to allow for new compression formats, checksum types, and other capabilities using filters. (Reviewed by Cynthia Shang.)  
* Move modules in Protocol directory in subdirectories.  
* Move backup modules into Backup directory.  

commit   : 1ad47d574e31f3bbe47bc015b2e04b42f55a582c    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 17:22:52 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 17:22:52 -0400    

commit   : 89cd44cc50d3d82dc6f001ac357bedd96b8387d8    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 12:57:28 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 12:57:28 -0400    

commit   : 57811b751a8f6cc3e7fce01e4944e556ae4578af    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 17:20:54 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 17:20:54 -0400    

commit   : 417c9ce2695ec0f716eeff30013979587313bdc1    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 15:02:58 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 15:02:58 -0400    

commit   : 34af9129e6b0f163e03fac55b7ffa71aa925d4c7    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 17:19:04 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 17:19:04 -0400    

commit   : f793effdc763381f61d592c9ec8ee8657167b7b9    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 15:02:58 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 15:02:58 -0400    

commit   : aa3bcba08d466bc6fd2558f8f0bf0e6d6c89b58b    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 17:17:18 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 17:17:18 -0400    

commit   : 4509b4eb188beeea5c74a52f238127d323093113    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 15:02:58 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 15:02:58 -0400    

commit   : ca9cfed883333d5801716eb01cf28b6b5be2b5cd    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 17:15:12 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 17:15:12 -0400    

commit   : 935e77d527a018b652f247c7374c558871210db6    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 15:02:57 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 May 2017 15:02:57 -0400    

commit   : 76161bd8451e581a8f9aa11c1f37d14863585d29    
  
author   : David Steele <david@pgmasters.net>    
date     : Wed, 12 Apr 2017 19:17:39 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Wed, 12 Apr 2017 19:17:39 -0400    

Bug Fixes:  
  
* Fixed an issue where read-only operations that used local worker processes (i.e. restore) were creating write locks that could interfere with parallel archive-push. (Reported by Jens Wilke.)  
  
Features:  
  
* Added the stanza-upgrade command to provide a mechanism for upgrading a stanza after upgrading to a new major version of PostgreSQL. (Contributed by Cynthia Shang.)  
* Added validation of pgbackrest.conf to display warnings if options are not valid or are not in the correct section. (Contributed by Cynthia Shang.)  
  
Refactoring:  
  
* Simplify locking scheme. Now, only the master process will hold write locks (for archive-push and backup commands) and not all local and remote worker processes as before.  
* Refactor Ini.pm to facilitate testing.  
* Do not set timestamps of files in the backup directories to match timestamps in the cluster directory. This was originally done to enable backup resume, but that process is now implemented with checksums.  
* Improved error message when the restore command detects the presence of postmaster.pid. (Suggested by Yogesh Sharma.)  
* Renumber return codes between 25 and 125 to avoid PostgreSQL interpreting some as fatal signal exceptions. (Suggested by Yogesh Sharma.)  
* The backup and restore commands no longer copy via temp files. In both cases the files are checksummed on resume so there's no danger of partial copies.  
* Allow functions to accept optional parameters as a hash.  
* Refactor File->list() and fileList() to accept optional parameters.  
* Refactor backupLabel() and add unit tests.  
* Silence some perl critic warnings. (Contributed by Cynthia Shang.)  

commit   : cc9f8fc4b6cb9a2da5bd7419630c4f3eb1c71186    
  
author   : David Steele <david@pgmasters.net>    
date     : Mon, 13 Mar 2017 16:54:51 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Mon, 13 Mar 2017 16:54:51 -0400    

Bug Fixes:  
  
* Fixed an issue where newly initialized (but unused) pages would cause page checksum warnings. (Reported by Stephen Frost.)  

commit   : 3cec6702e85e901ff3894e047cf5a461562b7b67    
  
author   : David Steele <david@pgmasters.net>    
date     : Thu, 2 Mar 2017 20:15:14 -0500    
  
committer: David Steele <david@pgmasters.net>    
date     : Thu, 2 Mar 2017 20:15:14 -0500    

Bug Fixes:  
  
* Fixed an issue where tables over 1GB would report page checksum warnings after the first segment. (Reported by Stephen Frost.)  
* Fixed an issue where databases created with a non-default tablespace would raise bogus warnings about pg_filenode.map and pg_internal.init not being page aligned. (Reported by blogh.)  
  
Refactoring:  
  
* Improved the code and tests for fileManifest() to prevent a possible race condition when files are removed by the database while the manifest is being built.  

commit   : 2d7d9626bb60640a77ac71559f2a714a1aac8b94    
  
author   : David Steele <david@pgmasters.net>    
date     : Mon, 13 Feb 2017 20:00:30 -0500    
  
committer: David Steele <david@pgmasters.net>    
date     : Mon, 13 Feb 2017 20:00:30 -0500    

Bug Fixes:  
  
* Fixed a regression introduced in v1.13 that could cause backups to fail if files were removed (e.g. tables dropped) while the manifest was being built. (Reported by Navid Golpayegani.)  
  
Refactoring:  
  
* Refactor FileCommon::fileManifest() and FileCommon::fileStat to be more modular to allow complete branch/statement level coverage testing.  

commit   : 845c6112bf592fb54b61156b47bbf2ebc5985f29    
  
author   : David Steele <david@pgmasters.net>    
date     : Mon, 13 Feb 2017 10:07:04 -0500    
  
committer: David Steele <david@pgmasters.net>    
date     : Mon, 13 Feb 2017 10:07:04 -0500    

Bug Fixes:  
  
* Fixed an issue where an archive-push error would not be retried and would instead return errors to PostgreSQL indefinitely (unless the .error file was manually deleted). (Reported by Jens Wilke.)  
* Fixed a race condition in parallel archiving where creation of new paths generated an error when multiple processes attempted to do so at the same time. (Reported by Jens Wilke.)  
  
Refactoring:  
  
* Improved performance of wal archive min/max provided by the info command. (Suggested by Jens Wilke.)