Life with Open Source

commit   : 3911fd55f53a930fcca6bc4889209021cc50ec2f    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 16 Jan 2023 20:35:53 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 16 Jan 2023 20:35:53 -0500    

To test pg_upgrade across major PG versions, we have to be able to  
modify or drop any old objects with no-longer-supported properties,  
and we have to be able to deal with cosmetic changes in pg_dump output.  
Up to now, the buildfarm and pg_upgrade's own test infrastructure had  
separate implementations of the former, and we had nothing but very  
ad-hoc rules for the latter (including an arbitrary threshold on how  
many lines of unchecked diff were okay!).  This patch creates a Perl  
module that can be shared by both those use-cases, and adds logic  
that deals with pg_dump output diffs in a much more tightly defined  
fashion.  
  
This largely supersedes previous efforts in commits 0df9641d3,  
9814ff550, and 62be9e4cd, which developed a SQL-script-based solution  
for the task of dropping old objects.  There was nothing fundamentally  
wrong with that work in itself, but it had no basis for solving the  
output-formatting problem.  The most plausible way to deal with  
formatting is to build a Perl module that can perform editing on the  
dump files; and once we commit to that, it makes more sense for the  
same module to also embed the knowledge of what has to be done for  
dropping old objects.  
  
Back-patch versions of the helper module as far as 9.2, to  
support buildfarm animals that still test that far back.  
It's also necessary to back-patch PostgreSQL/Version.pm,  
because the new code depends on that.  I fixed up pg_upgrade's  
002_pg_upgrade.pl in v15, but did not look into back-patching  
it further than that.  
  
Tom Lane and Andrew Dunstan  
  
Discussion: https://postgr.es/m/891521.1673657296@sss.pgh.pa.us  

commit   : cc2ffd8264bb4e10e6b289ce3978452018f725e8    
  
author   : David Steele <david@pgmasters.net>    
date     : Mon, 28 Nov 2022 17:47:48 +0800    
  
committer: David Steele <david@pgmasters.net>    
date     : Mon, 28 Nov 2022 17:47:48 +0800    

Bug Fixes:  
  
* Fix missing reference in diff/incr backup. (Reviewed by Stefan Fercot. Reported by Marcel Borger, ulfedf, jaymefSO.)  
  
Improvements:  
  
* Add hint when an option is specified without an index. (Reviewed by Stefan Fercot.)  

commit   : 70b75532bf20a025323b2a3138497ef01eb1774f    
  
author   : David Steele <david@pgmasters.net>    
date     : Tue, 22 Nov 2022 10:20:59 +0800    
  
committer: David Steele <david@pgmasters.net>    
date     : Tue, 22 Nov 2022 10:20:59 +0800    

Bug Fixes:  
  
* Fix memory leak in file bundle backup/restore. (Reviewed by John Morris, Oscar. Reported by Oscar.)  
* Fix protocol error on short read of remote file. (Reviewed by Stephen Frost.)  
  
Improvements:  
  
* Do not store references for zero-length files when bundling. (Reviewed by Stefan Fercot.)  
* Use more generic descriptions for pg_start_backup()/pg_stop_backup(). (Reviewed by Greg Sabino Mullane, David Christensen. Suggested by Greg Sabino Mullane.)  
  
Test Suite Improvements:  
  
* Update test.pl --psql-bin option to match command-line help. (Contributed by Koshi Shibagaki. Reviewed by David Steele.)  

commit   : 02991e79f8f58bc208f05dcc8af0c62dbe0a6ea4    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:51:10 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:51:10 -0500    

commit   : d26829e3f76ac58872bd57374cce6bd41d1e40cf    
  
author   : Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 7 Nov 2022 13:50:33 +0100    
  
committer: Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 7 Nov 2022 13:50:33 +0100    

commit   : eb3ff8600bd313071838ab376dd5c35524937242    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:49:11 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:49:11 -0500    

commit   : 953a0346f43cbd69bef85513765d7cc621ac81e7    
  
author   : Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 7 Nov 2022 13:52:22 +0100    
  
committer: Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 7 Nov 2022 13:52:22 +0100    

commit   : 26b9b5dddfa21ce73d9b99e79e2336c5584745bd    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:47:13 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:47:13 -0500    

commit   : 81b2ffdb32385366aa45b13e669b7d1291770af0    
  
author   : Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 7 Nov 2022 13:55:08 +0100    
  
committer: Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 7 Nov 2022 13:55:08 +0100    

commit   : b664e3552b800b480e2b4fadd847f8b312e00642    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:45:38 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:45:38 -0500    

commit   : 5680c5de322de1d7c0a7c657231bc252e5c471ef    
  
author   : Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 7 Nov 2022 13:57:17 +0100    
  
committer: Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 7 Nov 2022 13:57:17 +0100    

commit   : 6dde6ed3efb4baaa0955f78ba5c93e9490aaa490    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:38:53 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:38:53 -0500    

commit   : 9c5cbed95e3761d36c1b8cdf89cb1e1f1a8aca9a    
  
author   : Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 7 Nov 2022 13:59:56 +0100    
  
committer: Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 7 Nov 2022 13:59:56 +0100    

commit   : c5dc80c1bc216f0e21a2f79f5e0415c2d4cfb35d    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:36:53 -0500    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 7 Nov 2022 16:36:53 -0500    

commit   : 0bc9872b1106fa5cdd488bc0ddafb270b2e7540a    
  
author   : Alvaro Herrera <alvherre@alvh.no-ip.org>    
date     : Mon, 7 Nov 2022 19:21:03 +0100    
  
committer: Alvaro Herrera <alvherre@alvh.no-ip.org>    
date     : Mon, 7 Nov 2022 19:21:03 +0100    

commit   : 2a7ce2e2ce474504a707ec03e128fde66cfb8b48    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Oct 2022 16:57:37 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Oct 2022 16:57:37 -0400    

Drat, forgot this ...  

commit   : 957d1993c13d8477a3db5e319ece845fb3e0e5a7    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Oct 2022 16:28:16 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 10 Oct 2022 16:28:16 -0400    

commit   : 6b355806cc288e6f473254412337596287291798    
  
author   : David Steele <david@pgmasters.net>    
date     : Mon, 19 Sep 2022 10:08:10 -0700    
  
committer: David Steele <david@pgmasters.net>    
date     : Mon, 19 Sep 2022 10:08:10 -0700    

Bug Fixes:  
  
* Fix incorrect time expiration being used for non-default repositories. (Reviewed by Stefan Fercot. Reported by Adam Brusselback.)  
* Fix issue when listing directories recursively with a filter. (Reviewed by Stephen Frost. Reported by Efremov Egor.)  
  
Features:  
  
* Backup key/value annotations. (Contributed by Stefan Fercot. Reviewed by David Steele. Suggested by Adam Berlin.)  
  
Improvements:  
  
* Support --set in JSON output for info command. (Contributed by Stefan Fercot. Reviewed by David Steele. Suggested by Anton Kurochkin.)  
* Update archive.info timestamps after a successful backup. (Reviewed by Stefan Fercot. Suggested by Alex Richman.)  
* Move standby timeline check after checkpoint. (Reviewed by Stefan Fercot, Keith Fiske. Suggested by Keith Fiske.)  
* Improve warning message on backup resume. (Suggested by Cynthia Shang.)  
  
Documentation Improvements:  
  
* Add absolute path for kill in pgbackrest.service. (Suggested by Don Seiler.)  

commit   : c8b932112db2589bd9bb12d120f09fa29ab1f080    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 16:50:46 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 16:50:46 -0400    

commit   : 2d7d8f4397c5855e9159c05a2afb131c34282a8f    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 12:16:01 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 12:16:01 -0400    

commit   : 866f915688b02294275d8791828dca3442cbeb78    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 16:49:00 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 16:49:00 -0400    

commit   : 4c1dd680267f0bc56de8fb2a138aa556054f9886    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 12:16:01 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 12:16:01 -0400    

commit   : 7cd0d523d2581895e65cd0ebebc7e50caa8bbfda    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 16:47:33 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 16:47:33 -0400    

commit   : dfab37100de1127595b4f1f6949137bfea355c22    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 12:16:01 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 12:16:01 -0400    

commit   : 4bc493d14409857090928ea51c02a20aba8db364    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 16:45:58 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 16:45:58 -0400    

commit   : 22b205cbbd978e69f08bd2b980adae29a6ca1979    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 12:16:01 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 12:16:01 -0400    

commit   : 278273ccbad27a8834dfdf11895da9cd91de4114    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 16:44:29 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 16:44:29 -0400    

commit   : c0d5d52a780fb575d8f93d0b1a8ef8cb43851a84    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 12:16:01 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 8 Aug 2022 12:16:01 -0400    

commit   : 1ff531090b9d1eccd9107592398148a51486c9f8    
  
author   : David Steele <david@pgmasters.net>    
date     : Mon, 18 Jul 2022 09:32:30 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Mon, 18 Jul 2022 09:32:30 -0400    

NOTE TO PACKAGERS: An experimental meson build has been added but packagers should continue to use the autoconf/make build for the foreseeable future.  
  
Improvements:  
  
* OpenSSL 3 support. (Reviewed by Stephen Frost.)  
* Create snapshot when listing contents of a path. (Reviewed by John Morris, Stephen Frost.)  
* Force target-timeline=current when restore type=immediate. (Reviewed by Stephen Frost.)  
* Truncate files during delta restore when they are larger than expected. (Reviewed by Stephen Frost.)  
* Disable incremental manifest save when resume=n. (Contributed by Reid Thompson. Reviewed by David Steele.)  
* Set backup percent complete to zero before copy start. (Contributed by Reid Thompson. Reviewed by David Steele.)  
* Use S3 IsTruncated flag to determine list continuation. (Reviewed by John Morris, Soulou. Suggested by Christian Montagne.)  
  
Documentation Bug Fixes:  
  
* Skip internal options in the configuration reference. (Reported by Francisco Miguel Biete.)  
  
Documentation Improvements:  
  
* Add link to PostgreSQL configuration in repository host section. (Reviewed by Stefan Fercot. Suggested by Julien Cigar.)  
  
Test Suite Improvements:  
  
* Add experimental Meson build. (Reviewed by Eli Schwartz, Sam Bassaly.)  
* Allow any path to be passed to the --test-path option. (Contributed by Andrey Sokolov. Reviewed by David Steele.)  
* Fix compile error when DEBUG_EXEC_TIME is defined without DEBUG. (Contributed by Andrey Sokolov. Reviewed by David Steele.)  

commit   : fff8fbd865d1078635431014ac6928a19f4798ef    
  
author   : David Steele <david@pgmasters.net>    
date     : Tue, 14 Jun 2022 13:37:06 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Tue, 14 Jun 2022 13:37:06 -0400    

commit   : 19325da1df469d8e08eb39a320a108a58b337a0e    
  
author   : David Steele <david@pgmasters.net>    
date     : Mon, 13 Jun 2022 16:33:53 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Mon, 13 Jun 2022 16:33:53 -0400    

commit   : 164d174bbf9a3aba719c845497863cd3c49a3ad0    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 13 Jun 2022 16:04:05 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 13 Jun 2022 16:04:05 -0400    

commit   : cb31fc24b7283a663d1cfc760bb655a86a48b571    
  
author   : Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 13 Jun 2022 07:32:39 +0200    
  
committer: Peter Eisentraut <peter@eisentraut.org>    
date     : Mon, 13 Jun 2022 07:32:39 +0200    

commit   : 901e829f6dd05fdc15d899bc7f1108883002b1d5    
  
author   : David Steele <david@pgmasters.net>    
date     : Mon, 16 May 2022 08:46:24 -0400    
  
committer: David Steele <david@pgmasters.net>    
date     : Mon, 16 May 2022 08:46:24 -0400    

Bug Fixes:  
  
* Fix error thrown from FINALLY() causing an infinite loop. (Reviewed by Stephen Frost.)  
* Error on all lock failures except another process holding the lock. (Reviewed by Reid Thompson, Geir Råness. Reported by Geir Råness.)  
  
Features:  
  
* Backup file bundling for improved small file support. (Reviewed by Reid Thompson, Stefan Fercot, Chris Bandy.)  
* Verify command to validate the contents of a repository. (Contributed by Cynthia Shang, Reid Thompson. Reviewed by David Steele, Stefan Fercot.)  
* PostgreSQL 15 support. (Reviewed by Stefan Fercot.)  
* Show backup percent complete in info output. (Contributed by Reid Thompson. Reviewed by David Steele.)  
* Auto-select backup for restore command --type=lsn. (Contributed by Reid Thompson. Reviewed by Stefan Fercot, David Steele.)  
* Suppress existing WAL warning when archive-mode-check is disabled. (Contributed by Reid Thompson. Reviewed by David Steele.)  
* Add AWS IMDSv2 support. (Contributed by Nuno Pires. Reviewed by David Steele.)  
  
Improvements:  
  
* Allow repo-hardlink option to be changed after full backup. (Reviewed by Reid Thompson.)  
* Increase precision of percent complete logging for backup and restore. (Contributed by Reid Thompson. Reviewed by David Steele.)  
* Improve path validation for repo-* commands. (Contributed by Reid Thompson. Reviewed by David Steele.)  
* Improve stop command to honor stanza option. (Contributed by Reid Thompson. Reviewed by David Steele. Suggested by ragaoua.)  
* Improve error message for invalid repo-azure-key. (Contributed by Reid Thompson. Reviewed by David Steele. Suggested by Seth Daniel.)  
* Add hint to check the log on archive-get/archive-push async error. (Reviewed by Reid Thompson.)  
* Add ClockError for unexpected clock skew and timezone changes. (Reviewed by Greg Sabino Mullane, Stefan Fercot. Suggested by Greg Sabino Mullane.)  
* Strip extensions from history manifest before showing in error message. (Reviewed by Stefan Fercot.)  
* Add user:group to lock permission error. (Reviewed by Reid Thompson.)  
  
Documentation Bug Fixes:  
  
* Fix incorrect reference to stanza-update in the user guide. (Fixed by Abubakar Mohammed. Reviewed by David Steele.)  
* Fix example for repo-gcs-key-type option in configuration reference. (Reviewed by Reid Thompson.)  
* Fix tls-server-auth example and add clarifications. (Reviewed by Reid Thompson.)  
  
Documentation Improvements:  
  
* Simplify messaging around supported versions in the documentation. (Reviewed by Stefan Fercot, Reid Thompson, Greg Sabino Mullane.)  
* Add option type descriptions. (Contributed by Reid Thompson. Reviewed by David Steele.)  
* Add FAQ about backup types and restore speed. (Contributed by David Christensen. Reviewed by Reid Thompson.)  
* Document required base branch for pull requests. (Contributed by David Christensen. Reviewed by Reid Thompson.)  

commit   : 6979736b4bcdc57e4699eadcca44b699fd1afd29    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 17:21:58 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 17:21:58 -0400    

commit   : db034c2e2e45216439c14e2b7bb99260914d610f    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 14:29:53 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 14:29:53 -0400    

commit   : 6ac9161f69829fe327e393bff83d5f390105a70f    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 17:20:11 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 17:20:11 -0400    

commit   : b5576e1b701c8d690ed1ea8d3c17d5df49de3d7c    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 14:29:53 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 14:29:53 -0400    

commit   : f4206b3e5f816bcc45511411bb208d21a68a7e6a    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 17:18:31 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 17:18:31 -0400    

commit   : b4516b1aea7ac98bc21b47a66ad384f50c2bd2b7    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 14:29:53 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 14:29:53 -0400    

commit   : 4695fdb40fbb1e977e7e62f7d9af1fa948230d6a    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 17:16:30 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 17:16:30 -0400    

commit   : 0c8215c7b6bdf528edab88943438f0db9afad49b    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 14:29:53 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 14:29:53 -0400    

commit   : 0e9cc8c0f3bc411de888a77318d8854ccba90e80    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 17:14:45 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 17:14:45 -0400    

commit   : 0ae1d09575bbadd2e7a9ada5721a88c8ee0b6be3    
  
author   : Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 14:29:53 -0400    
  
committer: Tom Lane <tgl@sss.pgh.pa.us>    
date     : Mon, 9 May 2022 14:29:53 -0400