Life with Open Source

commit   : 83ed1f71c88ae948a5b6ec6d2a4802cc54470102    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 7 Aug 2023 16:08:18 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 7 Aug 2023 16:08:18 -0400    

commit   : 948757fe493c1031d43bb082b6466db9a08f34a3    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 7 Aug 2023 12:50:15 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 7 Aug 2023 12:50:15 -0400    

commit   : b5b033cc1ce152d387f20681f023b5e1f7c3ed3b    
  
author   : David Steele <[email protected]>    
date     : Mon, 24 Jul 2023 09:12:30 +0200    
  
committer: David Steele <[email protected]>    
date     : Mon, 24 Jul 2023 09:12:30 +0200    

Bug Fixes:  
  
* Preserve block incremental info in manifest during delta backup. (Reviewed by Stephen Frost. Reported by Francisco Miguel Biete Banon.)  
* Fix block incremental file names in verify command. (Reviewed by Reid Thompson. Reported by Francisco Miguel Biete Banon.)  
* Fix spurious automatic delta backup on backup from standby. (Reviewed by Stephen Frost. Reported by krmozejko, Don Seiler.)  
* Skip recovery.signal for PostgreSQL >= 12 when recovery type=none. (Reviewed by Stefan Fercot. Reported by T.Anastacio.)  
* Fix unique label generation for diff/incr backup. (Fixed by Andrey Sokolov. Reviewed by David Steele.)  
* Fix time-based archive expiration when no backups are expired. (Reviewed by Stefan Fercot.)  
  
Improvements:  
  
* Improve performance of SFTP storage driver. (Contributed by Stephen Frost, Reid Thompson. Reviewed by David Steele.)  
* Add timezone offset to info command date/time output. (Reviewed by Stefan Fercot, Philip Hurst. Suggested by Philip Hurst.)  
* Centralize error handling for unsupported features. (Reviewed by Stefan Fercot.)  
  
Documentation Improvements:  
  
* Clarify preference to install from packages in the user guide. (Reviewed by Stefan Fercot. Suggested by dr-kd.)  

commit   : ed1d8ea729ec0589260384605eddbc5df9178d41    
  
author   : David Steele <[email protected]>    
date     : Fri, 9 Jun 2023 18:18:27 +0300    
  
committer: David Steele <[email protected]>    
date     : Fri, 9 Jun 2023 18:18:27 +0300    

commit   : 136b275968c8c42dbe20cacb84f7a80f0fe416e7    
  
author   : David Steele <[email protected]>    
date     : Thu, 27 Apr 2023 22:31:50 +0300    
  
committer: David Steele <[email protected]>    
date     : Thu, 27 Apr 2023 22:31:50 +0300    

commit   : 164d4d950e070eb8a21f07db0cea5acc802e56e6    
  
author   : David Steele <[email protected]>    
date     : Fri, 9 Jun 2023 18:18:27 +0300    
  
committer: David Steele <[email protected]>    
date     : Fri, 9 Jun 2023 18:18:27 +0300    

commit   : be3ede072b2835c36d7bbccc898fedcbce247156    
  
author   : Christophe Pettus <[email protected]>    
date     : Sat, 29 Apr 2023 09:22:53 -0700    
  
committer: GitHub <[email protected]>    
date     : Sat, 29 Apr 2023 09:22:53 -0700    

commit   : 164d4d950e070eb8a21f07db0cea5acc802e56e6    
  
author   : David Steele <[email protected]>    
date     : Fri, 9 Jun 2023 18:18:27 +0300    
  
committer: David Steele <[email protected]>    
date     : Fri, 9 Jun 2023 18:18:27 +0300    

commit   : be3ede072b2835c36d7bbccc898fedcbce247156    
  
author   : Christophe Pettus <[email protected]>    
date     : Sat, 29 Apr 2023 09:22:53 -0700    
  
committer: GitHub <[email protected]>    
date     : Sat, 29 Apr 2023 09:22:53 -0700    

commit   : 164d4d950e070eb8a21f07db0cea5acc802e56e6    
  
author   : David Steele <[email protected]>    
date     : Fri, 9 Jun 2023 18:18:27 +0300    
  
committer: David Steele <[email protected]>    
date     : Fri, 9 Jun 2023 18:18:27 +0300    

commit   : be3ede072b2835c36d7bbccc898fedcbce247156    
  
author   : Christophe Pettus <[email protected]>    
date     : Sat, 29 Apr 2023 09:22:53 -0700    
  
committer: GitHub <[email protected]>    
date     : Sat, 29 Apr 2023 09:22:53 -0700    

commit   : b461f7c6f884dba8056858464d1b571e708dad77    
  
author   : David Steele <[email protected]>    
date     : Mon, 22 May 2023 11:13:13 +0300    
  
committer: David Steele <[email protected]>    
date     : Mon, 22 May 2023 11:13:13 +0300    

Features:  
  
* Block incremental backup. (Reviewed by John Morris, Stephen Frost, Stefan Fercot.)  
* SFTP support for repository storage. (Contributed by Reid Thompson. Reviewed by Stephen Frost, David Steele.)  
* PostgreSQL 16 support. (Reviewed by Stefan Fercot.)  
  
Improvements:  
  
* Allow page header checks to be skipped. (Reviewed by David Christensen. Suggested by David Christensen.)  
* Avoid chown() on recovery files during restore. (Reviewed by Stefan Fercot, Marcelo Henrique Neppel. Suggested by Marcelo Henrique Neppel.)  
* Add error retry detail for HTTP retries.  
  
Documentation Improvements:  
  
* Add warning about using recovery type=none. (Reviewed by Stefan Fercot.)  
* Add note about running stanza-create on already-created repositories.  

commit   : f96e531b1c079ae148b927a204845c7150a573f8    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 17:21:16 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 17:21:16 -0400    

commit   : 8dec3e375380dcdffea20d95ce3993c1bf79b045    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 12:38:08 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 12:38:08 -0400    

commit   : 117dd58fd9cd01e661a2c36977e16a2722306a6d    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 17:19:25 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 17:19:25 -0400    

commit   : 666bc999e9e0ecccb00140e370f03c5f52a91d16    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 12:38:08 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 12:38:08 -0400    

commit   : 2faab87390b03929a8cbb5a9336a04faa45a27c5    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 17:17:31 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 17:17:31 -0400    

commit   : aeed67f1af446dd425e2c8d6db97ea29c25b8887    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 12:38:08 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 12:38:08 -0400    

commit   : b6cf730e80e8571066c0ce76e76ce99b9144c149    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 17:15:52 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 17:15:52 -0400    

commit   : fe0b69fc66446b611025c888a05a7c03309eec80    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 12:38:08 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 12:38:08 -0400    

commit   : 8382864eb5c9f9ebe962ac20b3392be5ae304d23    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 17:13:20 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 17:13:20 -0400    

commit   : 8cd6b5af5898900e674885284f855c0a0abdcd70    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 12:38:08 -0400    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 8 May 2023 12:38:08 -0400    

commit   : 6ad79d16ca638b7ccdc81b5530a39007b8e01aed    
  
author   : David Steele <[email protected]>    
date     : Mon, 20 Mar 2023 09:37:23 +0800    
  
committer: David Steele <[email protected]>    
date     : Mon, 20 Mar 2023 09:37:23 +0800    

Bug Fixes:  
  
* Skip writing recovery.signal by default for restores of offline backups. (Reviewed by Stefan Fercot. Reported by Marcel Borger.)  
  
Features:  
  
* Block incremental backup (BETA). (Reviewed by John Morris, Stephen Frost, Stefan Fercot.)  
  
Improvements:  
  
* Keep only one all-default group index. (Reviewed by Stefan Fercot.)  
  
Documentation Improvements:  
  
* Add explicit instructions for upgrading between 2.x versions. (Contributed by Christophe Courtois. Reviewed by David Steele.)  
* Remove references to SSH made obsolete when TLS was introduced.  

commit   : 0da63ea07a3b610a5f0c4fc43595d76f3d8fa0d7    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 16:46:39 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 16:46:39 -0500    

commit   : f280ad2ca2d808a8cee6489dbbe2ec1e9ca02434    
  
author   : Peter Eisentraut <[email protected]>    
date     : Mon, 6 Feb 2023 12:22:35 +0100    
  
committer: Peter Eisentraut <[email protected]>    
date     : Mon, 6 Feb 2023 12:22:35 +0100    

commit   : 533cc39b750bd7600e8e2e5cab819a27f1717960    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 16:45:00 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 16:45:00 -0500    

commit   : bd46d1b5413d52af224db982de79f429a0cf12de    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 11:43:10 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 11:43:10 -0500    

commit   : 20aba55fae83cd0b6f7511365d172da8cd7e0135    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 16:42:56 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 16:42:56 -0500    

commit   : 6926350d6b90181193e776d3313c49226cbca2ea    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 11:43:10 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 11:43:10 -0500    

commit   : e4c4e6258c747d440e161f387d2eff84a835ca08    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 16:41:14 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 16:41:14 -0500    

commit   : dfb5ad7cf0d83ac3bb78f0177721f68a6ba60486    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 11:43:10 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 11:43:10 -0500    

commit   : 78ec02d612a9b69039ec2610740f738968fe144d    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 16:39:04 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 16:39:04 -0500    

commit   : 6788a55898053ba513753f9bc4ba7d3731676cdb    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 11:43:10 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Mon, 6 Feb 2023 11:43:10 -0500    

commit   : 053468bfb156a8ecbd5d0325d35141056c89ec52    
  
author   : David Steele <[email protected]>    
date     : Mon, 30 Jan 2023 09:15:44 +0700    
  
committer: David Steele <[email protected]>    
date     : Mon, 30 Jan 2023 09:15:44 +0700    

Improvements:  
  
* Remove support for PostgreSQL 9.0/9.1/9.2. (Reviewed by Stefan Fercot.)  
* Restore errors when no backup matches the current version of PostgreSQL. (Contributed by Stefan Fercot. Reviewed by David Steele. Suggested by Soulou.)  
* Add compress-level range checking for each compress-type. (Reviewed by Stefan Fercot. Suggested by gkleen, ViperRu.)  
  
Documentation Improvements:  
  
* Add warning about enabling "hierarchical namespace" on Azure storage. (Reviewed by Stefan Fercot. Suggested by Vojtech Galda, Pluggi, asjonos.)  
* Add replacement for linefeeds in monitoring example. (Reviewed by Stefan Fercot. Suggested by rudonx, gmustdie, Ivan Shelestov.)  
* Clarify target-action behavior on various PostgreSQL versions. (Contributed by Chris Bandy. Reviewed by David Steele, Anton Kurochkin, Stefan Fercot. Suggested by Anton Kurochkin, Chris Bandy.)  
* Updates and clarifications to index page. (Reviewed by Stefan Fercot.)  
* Add dark mode to the website. (Suggested by Stephen Frost.)  

commit   : c18c12c983a84d55e58b176969782c7ffac3272b    
  
author   : Tom Lane <[email protected]>    
date     : Tue, 17 Jan 2023 16:00:39 -0500    
  
committer: Tom Lane <[email protected]>    
date     : Tue, 17 Jan 2023 16:00:39 -0500    

test_extensions' test_ext_cine extension has the same upgrade hazard  
as test_ext7: the regression test leaves it in an updated state  
from which no downgrade path to default is provided.  This causes  
the update_extensions.sql script helpfully provided by pg_upgrade  
to fail.  So drop it in cross-version-upgrade testing.  
  
Not entirely sure how come I didn't hit this in testing yesterday;  
possibly I'd built the upgrade reference databases with  
testmodules-install-check disabled.  
  
Backpatch to v10 where this module was introduced.  

commit   : 4bcf3521290af5317b6ff1f5ae98682e96a3013f    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 16 Jan 2023 20:35:53 -0500    
  
committer: Tom Lane <[email protected]>    
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/[email protected]  

commit   : bfa3d27906646f39599901891a237a736191ffc9    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 16 Jan 2023 20:35:53 -0500    
  
committer: Tom Lane <[email protected]>    
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/[email protected]  

commit   : 3911fd55f53a930fcca6bc4889209021cc50ec2f    
  
author   : Tom Lane <[email protected]>    
date     : Mon, 16 Jan 2023 20:35:53 -0500    
  
committer: Tom Lane <[email protected]>    
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/[email protected]  

commit   : cc2ffd8264bb4e10e6b289ce3978452018f725e8    
  
author   : David Steele <[email protected]>    
date     : Mon, 28 Nov 2022 17:47:48 +0800    
  
committer: David Steele <[email protected]>    
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 <[email protected]>    
date     : Tue, 22 Nov 2022 10:20:59 +0800    
  
committer: David Steele <[email protected]>    
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.)