Life with Open Source

commit   : eca2f8a7dd9bda862a25fcc57ddf77f7c0dc3afe    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 7 Aug 2017 17:10:58 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 7 Aug 2017 17:10:58 -0400    

commit   : aa0f366d557c32aa29a1cae9d13d6d078b514abd    
  
author   : Peter Eisentraut <[email protected]>    
date     : Mon, 7 Aug 2017 13:42:43 -0400    
  
committer: Peter Eisentraut <[email protected]>    
date     : Mon, 7 Aug 2017 13:42:43 -0400    

commit   : d0fb52d446ed10cafe304aed16b193c1803cd906    
  
author   : David Steele <[email protected]>    
date     : Wed, 28 Jun 2017 11:22:01 -0400    
  
committer: David Steele <[email protected]>    
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 <[email protected]>    
date     : Tue, 27 Jun 2017 22:42:31 -0400    
  
committer: David Steele <[email protected]>    
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 <[email protected]>    
date     : Mon, 26 Jun 2017 12:20:13 -0400    
  
committer: David Steele <[email protected]>    
date     : Mon, 26 Jun 2017 12:20:13 -0400    

commit   : 76cf424da01a48daa358a4b2391eaaf6af5f1717    
  
author   : David Steele <[email protected]>    
date     : Mon, 26 Jun 2017 10:48:50 -0400    
  
committer: David Steele <[email protected]>    
date     : Mon, 26 Jun 2017 10:48:50 -0400    

commit   : c10c5bb0ef1de519371e1bdae0b9da7cf8670c95    
  
author   : David Steele <[email protected]>    
date     : Mon, 12 Jun 2017 11:36:00 -0400    
  
committer: David Steele <[email protected]>    
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 <[email protected]>    
date     : Mon, 8 May 2017 17:22:52 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 17:22:52 -0400    

commit   : 89cd44cc50d3d82dc6f001ac357bedd96b8387d8    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 12:57:28 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 12:57:28 -0400    

commit   : 57811b751a8f6cc3e7fce01e4944e556ae4578af    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 17:20:54 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 17:20:54 -0400    

commit   : 417c9ce2695ec0f716eeff30013979587313bdc1    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 15:02:58 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 15:02:58 -0400    

commit   : 34af9129e6b0f163e03fac55b7ffa71aa925d4c7    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 17:19:04 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 17:19:04 -0400    

commit   : f793effdc763381f61d592c9ec8ee8657167b7b9    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 15:02:58 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 15:02:58 -0400    

commit   : aa3bcba08d466bc6fd2558f8f0bf0e6d6c89b58b    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 17:17:18 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 17:17:18 -0400    

commit   : 4509b4eb188beeea5c74a52f238127d323093113    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 15:02:58 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 15:02:58 -0400    

commit   : ca9cfed883333d5801716eb01cf28b6b5be2b5cd    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 17:15:12 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 17:15:12 -0400    

commit   : 935e77d527a018b652f247c7374c558871210db6    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 15:02:57 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2017 15:02:57 -0400    

commit   : 76161bd8451e581a8f9aa11c1f37d14863585d29    
  
author   : David Steele <[email protected]>    
date     : Wed, 12 Apr 2017 19:17:39 -0400    
  
committer: David Steele <[email protected]>    
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 <[email protected]>    
date     : Mon, 13 Mar 2017 16:54:51 -0400    
  
committer: David Steele <[email protected]>    
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 <[email protected]>    
date     : Thu, 2 Mar 2017 20:15:14 -0500    
  
committer: David Steele <[email protected]>    
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 <[email protected]>    
date     : Mon, 13 Feb 2017 20:00:30 -0500    
  
committer: David Steele <[email protected]>    
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 <[email protected]>    
date     : Mon, 13 Feb 2017 10:07:04 -0500    
  
committer: David Steele <[email protected]>    
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.)  

commit   : 903bfef382f286a75e82b8b9edd93b2bdc6cfd96    
  
author   : Tom Lane <[email protected]>    
date     : Tue, 7 Feb 2017 10:24:25 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Tue, 7 Feb 2017 10:24:25 -0500    

The CREATE INDEX CONCURRENTLY bug can only be triggered by row updates,  
not inserts, since the problem would arise from an update incorrectly  
being made HOT.  Noted by Alvaro.  

commit   : 6f5e8094c2c0b829e3d00fc1e1656248457e16e6    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 16:50:42 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 16:50:42 -0500    

commit   : a587f69f658210b76a29b404ab2c0ad8205a0671    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 15:30:17 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 15:30:17 -0500    

commit   : 01306452b1481a73a24fe7396f84797d37269865    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 16:49:02 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 16:49:02 -0500    

commit   : 59661896228ecd701c8f78ac6663766d740cd39e    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 15:30:17 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 15:30:17 -0500    

commit   : bcbbc4cfc9ca163c4a562f24ff9e2fb070647786    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 16:47:25 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 16:47:25 -0500    

commit   : 5127c873aa52e574e8b2dd3ebf488e072a81a3ae    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 15:30:16 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 15:30:16 -0500    

commit   : 6a18e4bc2d13d077c52cf90a4c6ec68343808ba7    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 16:45:25 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 16:45:25 -0500    

commit   : a822971173e66cde920a0a20352b823cd873db0f    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 15:30:16 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2017 15:30:16 -0500    

commit   : 41eba95155b1fab4c5f98dab3327c1563968fcab    
  
author   : David Steele <[email protected]>    
date     : Sun, 5 Feb 2017 20:23:03 -0500    
  
committer: David Steele <[email protected]>    
date     : Sun, 5 Feb 2017 20:23:03 -0500    

IMPORTANT NOTE: The new implementation of asynchronous archiving no longer copies WAL to a separate queue. If there is any WAL left over in the old queue after upgrading to 1.13, it will be abandoned and not pushed to the repository.  
  
To prevent this outcome, stop archiving by setting archive_command = false. Next, drain the async queue by running pgbackrest --stanza=[stanza-name] archive-push and wait for the process to complete. Check that the queue in [spool-path]/archive/[stanza-name]/out is empty. Finally, install 1.13 and restore the original archive_command.  
  
IMPORTANT NOTE: The stanza-create command is not longer optional and must be executed before backup or archiving can be performed on a new stanza. Pre-existing stanzas do not require stanza-create to be executed.  
  
Bug Fixes:  
  
* Fixed const assignment giving compiler warning in C library. (Fixed by Adrian Vondendriesch.)  
* Fixed a few directory syncs that were missed for the --repo-sync option.  
* Fixed an issue where a missing user/group on restore could cause an "uninitialized value" error in File->owner(). (Reported by Leonardo Avellar.)  
* Fixed an issue where protocol mismatch errors did not output the expected value.  
* Fixed a spurious archive-get log message that indicated an exit code of 1 was an abnormal termination.  
  
Features:  
  
* Improved, multi-process implementation of asynchronous archiving.  
* Improved stanza-create command so that it can repair broken repositories in most cases and is robust enough to be made mandatory. (Contributed by Cynthia Shang.)  
* Improved check command to run on a standby, though only basic checks are done because pg_switch_xlog() cannot be executed on a replica. (Contributed by Cynthia Shang.)  
* Added archive and backup WAL ranges to the info command.  
* Added warning to update pg_tablespace.spclocation when remapping tablespaces in PostgreSQL < 9.2. (Contributed by blogh.)  
* Remove remote lock requirements for the archive-get, restore, info, and check commands since they are read-only operations. (Suggested by Michael Vitale.)  
  
Refactoring:  
  
* Refactor File and BackupCommon modules to improve test coverage.  
* Return proper error code when unable to convert a relative path to an absolute path. (Suggested by Yogesh Sharma.)  
* Log file banner is not output until the first log entry is written. (Suggested by Jens Wilke.)  
* Moved File->manifest() into the FileCommon.pm module.  
* Moved the Archive modules to the Archive directory and split the archive-get and archive-push commands into separate modules.  
* Split the check command out of the Archive.pm module.  
* Allow logging to be suppressed via logDisable() and logEnable().  
* Allow for locks to be taken more than once in the same process without error.  
* Lock directories can be created when more than one directory level is required.  
* Clean up optionValid()/optionTest() logic in Lock.pm.  
* Added Exception::exceptionCode() and Exception::exceptionMessage() to simplify error handling logic.  
* Represent .gz extension with a constant.  
* Allow empty files to be created with FileCommon::fileStringWrite() and use temp files to avoid partial reads.  
* Refactor process IO and process master/minion code out from the common protocol code.  
* Reduced the likelihood of torn pages causing a false positive in page checksums by filtering on start backup LSN.  
* Remove Intel-specific optimization from C library build flags. (Contributed by Adrian Vondendriesch.)  
* Removed --lock option. This option was introduced before the lock directory could be located outside the repository and is now obsolete.  
* Added --log-timestamp option to allow timestamps to be suppressed in logging. This is primarily used to avoid filters in the automated documentation.  
* Fixed alignment issues with multiline logging.  

commit   : 8e3464da805fc0975b6cf25ecb9ba16146b45c9e    
  
author   : David Steele <[email protected]>    
date     : Mon, 12 Dec 2016 19:18:27 -0500    
  
committer: David Steele <[email protected]>    
date     : Mon, 12 Dec 2016 19:18:27 -0500    

IMPORTANT NOTE: In prior releases it was possible to specify options on the command-line that were invalid for the current command without getting an error. An error will now be generated for invalid options so it is important to carefully check command-line options in your environment to prevent disruption.  
  
Bug Fixes:  
  
* Fixed an issue where options that were invalid for the specified command could be provided on the command-line without generating an error. The options were ignored and did not cause any change in behavior, but it did lead to some confusion. Invalid options will now generate an error. (Reported by Nikhilchandra Kulkarni.)  
* Fixed an issue where internal symlinks were not being created for tablespaces in the repository. This issue was only apparent when trying to bring up clusters in-place manually using filesystem snapshots and did not affect normal backup and restore.  
* Fixed an issue that prevented errors from being output to the console before the logging system was initialized, i.e. while parsing options. Error codes were still being returned accurately so this would not have made a process look like it succeeded when it did not. (Reported by Adrian Vondendriesch.)  
* Fixed an issue where the db-port option specified on the backup server would not be properly passed to the remote unless it was from the first configured database. (Reported by Michael Vitale.)  
  
Features:  
  
* Added the --checksum-page option to allow pgBackRest to validate page checksums in data files when checksums are enabled on PostgreSQL >= 9.3. Note that this functionality requires a C library which may not initially be available in OS packages. The option will automatically be enabled when the library is present and checksums are enabled on the cluster. (Suggested by Stephen Frost.)  
* Added the --repo-link option to allow internal symlinks to be suppressed when the repository is located on a filesystem that does not support symlinks. This does not affect any pgBackRest functionality, but the convenience link latest will not be created and neither will internal tablespace symlinks, which will affect the ability to bring up clusters in-place manually using filesystem snapshots.  
* Added the --repo-sync option to allow directory syncs in the repository to be disabled for file systems that do not support them, e.g. NTFS.  
* Added a predictable log entry to signal that a command has completed successfully. For example a backup ends successfully with: INFO: backup command end: completed successfully. (Suggested by Jens Wilke.)  
  
Refactoring:  
  
* Abstracted code to determine which database cluster is the master and which are standbys. (Contributed by Cynthia Shang.)  
* Improved consistency and flexibility of the protocol layer by using JSON for all messages.  
* File copy protocol now accepts a function that can do additional processing on the copy buffers and return a result to the calling process.  
* Improved IO->bufferRead to always return requested number of bytes until EOF.  
* For simplicity, the pg_control file is now copied with the rest of the files instead of by itself of at the end of the process. The backup command does not require this behavior and the restore copies to a temporary file which is renamed at the end of the restore.  
* Simplified the result hash of File->manifest(), Db->tablespaceMapGet(), and Db->databaseMapGet().  
* Improved errors returned from child processes by removing redundant error level and code.  
* Code cleanup in preparation for improved stanza-create command. (Contributed by Cynthia Shang.)  
* Improved parameter/result logging in debug/trace functions.  

commit   : 54b1a784b55fdee915b550e5151f20dabea4e67c    
  
author   : David Steele <[email protected]>    
date     : Thu, 17 Nov 2016 09:57:59 -0500    
  
committer: David Steele <[email protected]>    
date     : Thu, 17 Nov 2016 09:57:59 -0500    

Bug Fixes:  
  
* Fixed an issue where asynchronous archiving was transferring one file per execution instead of transferring files in batches. This regression was introduced in v1.09 and affected efficiency only, all WAL segments were correctly archived in asynchronous mode. (Reported by Stephen Frost.)  

commit   : 081f5e3722ea19112c3d322573480e94ab6068a4    
  
author   : David Steele <[email protected]>    
date     : Wed, 16 Nov 2016 11:58:09 -0500    
  
committer: David Steele <[email protected]>    
date     : Wed, 16 Nov 2016 11:58:09 -0500    

* Updated URLs and branch names in the documentation.  
* Changed COMMERR log level to LOG_SERVER_ONLY.  
* Updated regression tests.  

commit   : 83a2f4e6040e63418b32b107494880a49b801a61    
  
author   : David Steele <[email protected]>    
date     : Wed, 16 Nov 2016 11:27:07 -0500    
  
committer: David Steele <[email protected]>    
date     : Wed, 16 Nov 2016 11:27:07 -0500    

commit   : 33c62cf149f728b7e2b4805e79fb5a026009bdc4    
  
author   : David Steele <[email protected]>    
date     : Tue, 15 Nov 2016 11:23:59 -0500    
  
committer: David Steele <[email protected]>    
date     : Tue, 15 Nov 2016 11:23:59 -0500