Life with Open Source

pgBackRest 1.19 commit log

v1.18: Stanza Upgrade, Refactoring, and Locking Improvements

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    

Click here for diff

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.)  

M README.md
M doc/release.pl
M doc/resource/exe.cache
M doc/xml/index.xml
M doc/xml/release.xml
M lib/pgBackRest/Version.pm
M libc/lib/pgBackRest/LibC.pm

pgBackRest 1.18 commit log

v1.17: Page Checksum Bug Fix

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    

Click here for diff

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

M README.md
M doc/resource/exe.cache
M doc/xml/release.xml
M lib/pgBackRest/Version.pm
M libc/lib/pgBackRest/LibC.pm

pgBackRest 1.17 commit log

v1.16: Page Checksum Improvements, CI, and Package Testing

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    

Click here for diff

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.  

M README.md
M doc/resource/exe.cache
M doc/xml/release.xml
M lib/pgBackRest/Version.pm
M libc/lib/pgBackRest/LibC.pm

pgBackRest 1.16 commit log

v1.15: Refactoring and Bug Fixes

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    

Click here for diff

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.  

M README.md
M doc/resource/exe.cache
M doc/xml/release.xml
M lib/pgBackRest/Version.pm
M libc/lib/pgBackRest/LibC.pm

pgBackRest 1.15 commit log

v1.14: Bug Fixes

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    

Click here for diff

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.)  

M README.md
M doc/resource/exe.cache
M doc/xml/release.xml
M lib/pgBackRest/Version.pm
M libc/lib/pgBackRest/LibC.pm

PostgreSQL 9.2.20 commit log

Correct thinko in last-minute release note item.

commit   : 903bfef382f286a75e82b8b9edd93b2bdc6cfd96    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Tue, 7 Feb 2017 10:24:25 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Tue, 7 Feb 2017 10:24:25 -0500    

Click here for diff

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.  

M doc/src/sgml/release-9.2.sgml

PostgreSQL 9.3.16 commit log

Stamp 9.3.16.

commit   : 6f5e8094c2c0b829e3d00fc1e1656248457e16e6    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 16:50:42 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 16:50:42 -0500    

Click here for diff

M configure
M configure.in
M doc/bug.template
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc

Release notes for 9.6.2, 9.5.6, 9.4.11, 9.3.16, 9.2.20.

commit   : a587f69f658210b76a29b404ab2c0ad8205a0671    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 15:30:17 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 15:30:17 -0500    

Click here for diff

PostgreSQL 9.4.11 commit log

Stamp 9.4.11.

commit   : 01306452b1481a73a24fe7396f84797d37269865    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 16:49:02 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 16:49:02 -0500    

Click here for diff

M configure
M configure.in
M doc/bug.template
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc

Release notes for 9.6.2, 9.5.6, 9.4.11, 9.3.16, 9.2.20.

commit   : 59661896228ecd701c8f78ac6663766d740cd39e    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 15:30:17 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 15:30:17 -0500    

Click here for diff

PostgreSQL 9.5.6 commit log

Stamp 9.5.6.

commit   : bcbbc4cfc9ca163c4a562f24ff9e2fb070647786    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 16:47:25 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 16:47:25 -0500    

Click here for diff

M configure
M configure.in
M doc/bug.template
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc

Release notes for 9.6.2, 9.5.6, 9.4.11, 9.3.16, 9.2.20.

commit   : 5127c873aa52e574e8b2dd3ebf488e072a81a3ae    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 15:30:16 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 15:30:16 -0500    

Click here for diff

PostgreSQL 9.6.2 commit log

Stamp 9.6.2.

commit   : 6a18e4bc2d13d077c52cf90a4c6ec68343808ba7    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 16:45:25 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 16:45:25 -0500    

Click here for diff

M configure
M configure.in
M doc/bug.template
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc

Release notes for 9.6.2, 9.5.6, 9.4.11, 9.3.16, 9.2.20.

commit   : a822971173e66cde920a0a20352b823cd873db0f    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 15:30:16 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 6 Feb 2017 15:30:16 -0500    

Click here for diff