Add security definer and search_path to event trigger functions.
commit : 438fc93907bbd1c7c96d5acdd8a5a6307266cdfc
author : David Steele <[email protected]>
date : Thu, 4 Nov 2021 16:56:42 -0400
committer: David Steele <[email protected]>
date : Thu, 4 Nov 2021 16:56:42 -0400
Click here for diff
Similar to #156, this prevents users from defining their own versions of functions used in the event triggers. Either one should be sufficient on its own, but both provides better defense against regressions.
M Makefile
A pgaudit–1.5–1.5.1.sql
R083 pgaudit–1.5.sql pgaudit–1.5.1.sql
M pgaudit.control
Add security definer and search_path to event trigger functions.
commit : 881c617084cac4985b9471426510af05c2a49dd7
author : David Steele <[email protected]>
date : Thu, 4 Nov 2021 14:51:17 -0400
committer: GitHub <[email protected]>
date : Thu, 4 Nov 2021 14:51:17 -0400
Click here for diff
Similar to #156, this prevents users from defining their own versions of functions used in the event triggers. Either one should be sufficient on its own, but both provides better defense against regressions.
M Makefile
A pgaudit–1.6–1.6.1.sql
R083 pgaudit–1.6.sql pgaudit–1.6.1.sql
M pgaudit.control
v2.36: Minor Bug Fixes and Improvements
commit : 42fd6ce4e09ee92614cfbfb6766d9c3a6ba9cc1a
author : David Steele <[email protected]>
date : Mon, 1 Nov 2021 08:59:14 -0400
committer: David Steele <[email protected]>
date : Mon, 1 Nov 2021 08:59:14 -0400
Click here for diff
Bug Fixes:
* Allow "global" as a stanza prefix. (Reviewed by Stefan Fercot. Reported by Younes Alhroub.)
* Fix segfault on invalid GCS key file. (Reviewed by Stephen Frost. Reported by Henrik Feldt.)
Improvements:
* Allow link-map option to create new links. (Reviewed by Don Seiler, Stefan Fercot, Chris Bandy. Suggested by Don Seiler.)
* Increase max index allowed for pg/repo options to 256. (Reviewed by Cynthia Shang.)
* Add WebIdentity authentication for AWS S3. (Reviewed by James Callahan, Reid Thompson, Benjamin Blattberg, Andrew L'Ecuyer.)
* Report backup file validation errors in backup.info. (Contributed by Stefan Fercot. Reviewed by David Steele.)
* Add recovery start time to online backup restore log. (Reviewed by Tom Swartz, Stefan Fercot. Suggested by Tom Swartz.)
* Report original error and retries on local job failure. (Reviewed by Stefan Fercot.)
* Rename page checksum error to error list in info text output. (Reviewed by Stefan Fercot.)
* Add hints to standby replay timeout message. (Reviewed by Cynthia Shang, Stefan Fercot. Suggested by Leigh Downs.)
M CONTRIBUTING.md
M README.md
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/release.xml
M src/build/configure.ac
M src/configure
M src/version.h
M test/code-count/file-type.yaml
Stamp 14.0.
commit : 86a4dc1e6f29d1992a2afa3fac1a0b0a6e84568c
author : Tom Lane <[email protected]>
date : Mon, 27 Sep 2021 16:57:41 -0400
committer: Tom Lane <[email protected]>
date : Mon, 27 Sep 2021 16:57:41 -0400
Click here for diff
M configure
M configure.ac
Translation updates
commit : 9f535e4aeafc4e427355760178ecc89055f96942
author : Peter Eisentraut <[email protected]>
date : Mon, 27 Sep 2021 09:22:27 +0200
committer: Peter Eisentraut <[email protected]>
date : Mon, 27 Sep 2021 09:22:27 +0200
Click here for diff
v2.35: Binary Protocol
commit : 3787cf78032cb928f27044c13b6f50d57bf06d20
author : David Steele <[email protected]>
date : Mon, 23 Aug 2021 06:52:51 -0400
committer: David Steele <[email protected]>
date : Mon, 23 Aug 2021 06:52:51 -0400
Click here for diff
IMPORTANT NOTE: The log level for copied files in the backup/restore commands has been changed to detail. This makes the info log level less noisy but if these messages are required then set the log level for the backup/restore commands to detail.
Bug Fixes:
* Detect errors in S3 multi-part upload finalize. (Reviewed by Cynthia Shang, Marco Montagna. Reported by Marco Montagna, Lev Kokotov, Anderson A. Mallmann.)
* Fix detection of circular symlinks. (Reviewed by Stefan Fercot. Reported by Rohit Raveendran.)
* Only pass selected repo options to the remote. (Reviewed by David Christensen, Cynthia Shang. Reported by Greg Sabino Mullane, David Christensen.)
Improvements:
* Binary protocol. (Reviewed by Cynthia Shang.)
* Automatically create data directory on restore. (Contributed by Stefan Fercot. Reviewed by David Steele. Suggested by Chris Bandy.)
* Allow restore --type=lsn. (Contributed by Stefan Fercot. Reviewed by Cynthia Shang. Suggested by James Coleman.)
* Change level of backup/restore copied file logging to detail. (Reviewed by Stefan Fercot. Suggested by Jens Wilke.)
* Loop while waiting for checkpoint LSN to reach replay LSN. (Contributed by Stefan Fercot. Reviewed by David Steele. Suggested by Fatih Mencutekin.)
* Log backup file total and restore size/file total. (Reviewed by Cynthia Shang.)
Documentation Bug Fixes:
* Fix incorrect host names in user guide. (Reviewed by Stefan Fercot. Reported by Greg Sabino Mullane.)
Documentation Improvements:
* Update contributing documentation and add pull request template. (Contributed by Cynthia Shang. Reviewed by David Steele.)
* Rearrange backup documentation in user guide. (Reviewed by Cynthia Shang.)
* Clarify restore --type behavior in command reference. (Contributed by Cynthia Shang. Reviewed by David Steele.)
* Fix documentation and comment typos. (Contributed by Eric Radman. Reviewed by David Steele.)
Test Suite Improvements:
* Add check for test path inside repo path. (Reviewed by Greg Sabino Mullane. Suggested by Greg Sabino Mullane.)
* Add CodeQL static code analysis. (Reviewed by Cynthia Shang.)
* Update tests to use standard patterns. (Contributed by Cynthia Shang. Reviewed by David Steele.)
M CONTRIBUTING.md
M README.md
M doc/RELEASE.md
M doc/release.pl
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/release.xml
M src/build/configure.ac
M src/configure
M src/version.h
M test/code-count/file-type.yaml
Stamp 9.6.23.
commit : b979c788a9b79b615457e94b6e9f709513fe2e27
author : Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 16:56:33 -0400
committer: Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 16:56:33 -0400
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
Translation updates
commit : eb8423e63b22421fb028cf0461c1298824d1cd98
author : Peter Eisentraut <[email protected]>
date : Mon, 9 Aug 2021 12:59:39 +0200
committer: Peter Eisentraut <[email protected]>
date : Mon, 9 Aug 2021 12:59:39 +0200
Click here for diff
Stamp 10.18.
commit : 29abec3a62229a37ce21203acdeb03a7860c1102
author : Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 16:54:22 -0400
committer: Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 16:54:22 -0400
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
Translation updates
commit : f2295cfe878249cfb7b2da3f5bae48ca29958fdf
author : Peter Eisentraut <[email protected]>
date : Mon, 9 Aug 2021 12:58:41 +0200
committer: Peter Eisentraut <[email protected]>
date : Mon, 9 Aug 2021 12:58:41 +0200
Click here for diff
Stamp 11.13.
commit : 2b4006920ca0d0a579579aecff65ef7fe81185bb
author : Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 16:52:43 -0400
committer: Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 16:52:43 -0400
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
Last-minute updates for release notes.
commit : f334490131be5ef1935c56bece186f3afa5fbded
author : Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 14:41:00 -0400
committer: Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 14:41:00 -0400
Click here for diff
Stamp 12.8.
commit : de835071fda945fb5e40340d3ea8dd2ca13e725c
author : Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 16:50:41 -0400
committer: Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 16:50:41 -0400
Click here for diff
M configure
M configure.in
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc
Last-minute updates for release notes.
commit : c6afcafafe95df08f98eea7ac5d5b3ab30f22db4
author : Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 14:41:00 -0400
committer: Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 14:41:00 -0400
Click here for diff
Stamp 13.4.
commit : e849f3f1f884ad140b60a24354c6371cbd2efbb6
author : Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 16:49:05 -0400
committer: Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 16:49:05 -0400
Click here for diff
M configure
M configure.in
Last-minute updates for release notes.
commit : 0145ec9be92b2146e7b94f286cb3dab9eb77ef70
author : Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 14:41:00 -0400
committer: Tom Lane <[email protected]>
date : Mon, 9 Aug 2021 14:41:00 -0400
Click here for diff
Remove remaining references to Vagrant.
commit : 6afeae52d8e4569235bf6088e983d95ec26f13b7
author : David Steele <[email protected]>
date : Thu, 5 Aug 2021 08:22:32 -0400
committer: David Steele <[email protected]>
date : Thu, 5 Aug 2021 08:22:32 -0400
Click here for diff
Testing is entirely Docker-based now.
M .gitignore
M README.md
Fix logic to properly classify SELECT FOR UPDATE as SELECT.
commit : bd6a261f72e08daa3a5f36b46aa4b1728d23709b
author : David Steele <[email protected]>
date : Thu, 5 Aug 2021 08:02:22 -0400
committer: GitHub <[email protected]>
date : Thu, 5 Aug 2021 08:02:22 -0400
Click here for diff
v2.34: PostgreSQL 14 Support
commit : d10a99d73b772f221807024abbf61fdc5ca3a800
author : David Steele <[email protected]>
date : Mon, 7 Jun 2021 06:51:08 -0400
committer: David Steele <[email protected]>
date : Mon, 7 Jun 2021 06:51:08 -0400
Click here for diff
Bug Fixes:
* Fix issues with leftover spool files from a prior restore. (Reviewed by Cynthia Shang, Stefan Fercot, Floris van Nee. Reported by Floris van Nee.)
* Fix issue when checking links for large numbers of tablespaces. (Reviewed by Cynthia Shang, Avinash Vallarapu. Reported by Avinash Vallarapu.)
* Free no longer needed remotes so they do not timeout during restore. (Reviewed by Cynthia Shang. Reported by Francisco Miguel Biete.)
* Fix help when a valid option is invalid for the specified command. (Reviewed by Stefan Fercot. Reported by Cynthia Shang.)
Features:
* Add PostgreSQL 14 support. (Reviewed by Cynthia Shang.)
* Add automatic GCS authentication for GCE instances. (Reviewed by Jan Wieck, Daniel Farina.)
* Add repo-retention-history option to expire backup history. (Contributed by Stefan Fercot. Reviewed by Cynthia Shang, David Steele.)
* Add db-exclude option. (Contributed by Stefan Fercot. Reviewed by Cynthia Shang.)
Improvements:
* Change archive expiration logging from detail to info level. (Contributed by Cynthia Shang. Reviewed by David Steele.)
* Remove stanza archive spool path on restore. (Reviewed by Cynthia Shang, Stefan Fercot.)
* Do not write files atomically or sync paths during backup copy. (Reviewed by Stephen Frost, Stefan Fercot, Cynthia Shang.)
Documentation Improvements:
* Update contributing documentation. (Contributed by Cynthia Shang. Reviewed by David Steele, Stefan Fercot.)
* Consolidate RHEL/CentOS user guide into a single document. (Reviewed by Cynthia Shang.)
* Clarify that repo-s3-role is not an ARN. (Contributed by Isaac Yuen. Reviewed by David Steele.)
M CONTRIBUTING.md
M README.md
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/release.xml
M src/build/configure.ac
M src/configure
M src/version.h
M test/code-count/file-type.yaml
Stamp 9.6.22.
commit : 836dda6f1b31c5f7c70ebf52537364ffc3eff577
author : Tom Lane <[email protected]>
date : Mon, 10 May 2021 16:50:15 -0400
committer: Tom Lane <[email protected]>
date : Mon, 10 May 2021 16:50:15 -0400
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
Last-minute updates for release notes.
commit : cc6c63f8a26d9706bc4b256ac075401bb3d5f759
author : Tom Lane <[email protected]>
date : Mon, 10 May 2021 13:10:30 -0400
committer: Tom Lane <[email protected]>
date : Mon, 10 May 2021 13:10:30 -0400
Click here for diff
Stamp 10.17.
commit : cffc8fd1ecb09fcd4d8aa98134f4ba8613a01a3a
author : Tom Lane <[email protected]>
date : Mon, 10 May 2021 16:47:56 -0400
committer: Tom Lane <[email protected]>
date : Mon, 10 May 2021 16:47:56 -0400
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
Last-minute updates for release notes.
commit : 25387cc56d344eaa9545b8233496296cf6087477
author : Tom Lane <[email protected]>
date : Mon, 10 May 2021 13:10:29 -0400
committer: Tom Lane <[email protected]>
date : Mon, 10 May 2021 13:10:29 -0400
Click here for diff
Stamp 11.12.
commit : fae98e3293de89f2fe8fc6e7c196d351378ce80e
author : Tom Lane <[email protected]>
date : Mon, 10 May 2021 16:45:49 -0400
committer: Tom Lane <[email protected]>
date : Mon, 10 May 2021 16:45:49 -0400
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
Last-minute updates for release notes.
commit : 6c1cfccf226645f4c01b4fee8df2c4e3392f2a32
author : Tom Lane <[email protected]>
date : Mon, 10 May 2021 13:10:29 -0400
committer: Tom Lane <[email protected]>
date : Mon, 10 May 2021 13:10:29 -0400
Click here for diff
Stamp 12.7.
commit : 4bf0bce161097869be5a56706b31388ba15e0113
author : Tom Lane <[email protected]>
date : Mon, 10 May 2021 16:43:52 -0400
committer: Tom Lane <[email protected]>
date : Mon, 10 May 2021 16:43:52 -0400
Click here for diff
M configure
M configure.in
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc
Last-minute updates for release notes.
commit : a9c718bd2d35586da8ebdefa0b72fe7e0d1a725b
author : Tom Lane <[email protected]>
date : Mon, 10 May 2021 13:10:29 -0400
committer: Tom Lane <[email protected]>
date : Mon, 10 May 2021 13:10:29 -0400
Click here for diff
Stamp 13.3.
commit : 272d82ec6febb97ab25fd7c67e9c84f4660b16ac
author : Tom Lane <[email protected]>
date : Mon, 10 May 2021 16:41:42 -0400
committer: Tom Lane <[email protected]>
date : Mon, 10 May 2021 16:41:42 -0400
Click here for diff
M configure
M configure.in
Last-minute updates for release notes.
commit : 9b93a33f455579ee8953c32721c03ff9163b7f96
author : Tom Lane <[email protected]>
date : Mon, 10 May 2021 13:10:29 -0400
committer: Tom Lane <[email protected]>
date : Mon, 10 May 2021 13:10:29 -0400
Click here for diff
v2.33: Multi-Repository and GCS Support
commit : a3d89143d6b34c6019cd29e059d28487037fd109
author : David Steele <[email protected]>
date : Mon, 5 Apr 2021 09:18:20 -0400
committer: David Steele <[email protected]>
date : Mon, 5 Apr 2021 09:18:20 -0400
Click here for diff
Bug Fixes:
* Fix option warnings breaking async archive-get/archive-push. (Reviewed by Cynthia Shang. Reported by Lev Kokotov.)
* Fix memory leak in backup during archive copy. (Reviewed by Cynthia Shang. Reported by Christian ROUX, Efremov Egor.)
* Fix stack overflow in cipher passphrase generation. (Reviewed by Cynthia Shang. Reported by bsiara.)
* Fix repo-ls / on S3 repositories. (Reviewed by Cynthia Shang. Reported by Lesovsky Alexey.)
Features:
* Multiple repository support. (Contributed by Cynthia Shang, David Steele. Reviewed by Stefan Fercot, Stephen Frost.)
* GCS support for repository storage. (Reviewed by Cynthia Shang.)
* Add archive-header-check option. (Reviewed by Stephen Frost, Cynthia Shang. Suggested by Hans-Jürgen Schönig.)
Improvements:
* Include recreated system databases during selective restore. (Contributed by Stefan Fercot. Reviewed by Cynthia Shang.)
* Exclude content-length from S3 signed headers. (Reviewed by Cynthia Shang. Suggested by Brian P Bockelman.)
* Consolidate less commonly used repository storage options. (Reviewed by Cynthia Shang.)
* Allow custom config-path default with ./configure --with-configdir. (Contributed by Michael Schout. Reviewed by David Steele.)
* Log archive copy during backup. (Reviewed by Cynthia Shang, Stefan Fercot.)
Documentation Improvements:
* Update reference to include links to user guide examples. (Contributed by Cynthia Shang. Reviewed by David Steele.)
* Update selective restore documentation with caveats. (Reviewed by Cynthia Shang, Stefan Fercot.)
* Add compress-type clarification to archive-copy documentation. (Reviewed by Cynthia Shang, Stefan Fercot.)
* Add compress-level defaults per compress-type value. (Contributed by Cynthia Shang. Reviewed by David Steele.)
* Add note about required NFS settings being the same as PostgreSQL. (Contributed by Cynthia Shang. Reviewed by David Steele.)
M CONTRIBUTING.md
M README.md
M doc/RELEASE.md
M doc/resource/exe.cache
M doc/resource/git-history.cache
M doc/xml/auto/metric-coverage-report.auto.xml
M doc/xml/release.xml
M src/build/aclocal.m4
M src/build/configure.ac
M src/configure
M src/version.h
M test/code-count/file-type.yaml
M test/lib/pgBackRestTest/Common/CodeCountTest.pm
Stamp 9.5.25.
commit : 202c587e2f28bc295f6935d044e20680b627e7a1
author : Tom Lane <[email protected]>
date : Mon, 8 Feb 2021 17:03:12 -0500
committer: Tom Lane <[email protected]>
date : Mon, 8 Feb 2021 17:03:12 -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
Translation updates
commit : c20a8efa6e2a7374f4cddb76e76213f63b7d7ac5
author : Peter Eisentraut <[email protected]>
date : Mon, 8 Feb 2021 18:13:24 +0100
committer: Peter Eisentraut <[email protected]>
date : Mon, 8 Feb 2021 18:13:24 +0100
Click here for diff
Stamp 9.6.21.
commit : 43b434edefdae5607000bb044caec1cf5e0c25c4
author : Tom Lane <[email protected]>
date : Mon, 8 Feb 2021 17:01:30 -0500
committer: Tom Lane <[email protected]>
date : Mon, 8 Feb 2021 17:01:30 -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
Translation updates
commit : e641bce57deb2bcbd25f04fe8f56fddaeb7757ea
author : Peter Eisentraut <[email protected]>
date : Mon, 8 Feb 2021 18:10:23 +0100
committer: Peter Eisentraut <[email protected]>
date : Mon, 8 Feb 2021 18:10:23 +0100
Click here for diff
Stamp 10.16.
commit : 5aa3189116ae8f6099b9f1a374978282e38edd43
author : Tom Lane <[email protected]>
date : Mon, 8 Feb 2021 16:59:29 -0500
committer: Tom Lane <[email protected]>
date : Mon, 8 Feb 2021 16:59:29 -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
Translation updates
commit : 019a3a90bdde362b3b97c6d8b333bd0cccd37711
author : Peter Eisentraut <[email protected]>
date : Mon, 8 Feb 2021 18:07:32 +0100
committer: Peter Eisentraut <[email protected]>
date : Mon, 8 Feb 2021 18:07:32 +0100
Click here for diff
Stamp 11.11.
commit : db5b64b978290e2c2bb0a18edbf2447c1405ccad
author : Tom Lane <[email protected]>
date : Mon, 8 Feb 2021 16:57:36 -0500
committer: Tom Lane <[email protected]>
date : Mon, 8 Feb 2021 16:57:36 -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
Translation updates
commit : 790567a741cfec6663193084a18890bd05c9e4be
author : Peter Eisentraut <[email protected]>
date : Mon, 8 Feb 2021 18:00:20 +0100
committer: Peter Eisentraut <[email protected]>
date : Mon, 8 Feb 2021 18:00:20 +0100
Click here for diff
Stamp 12.6.
commit : 1b9eb7cde7e9cdacd62d206b75ab66bfe6a9a0a4
author : Tom Lane <[email protected]>
date : Mon, 8 Feb 2021 16:56:03 -0500
committer: Tom Lane <[email protected]>
date : Mon, 8 Feb 2021 16:56:03 -0500
Click here for diff
M configure
M configure.in
M src/include/pg_config.h.win32
M src/interfaces/libpq/libpq.rc.in
M src/port/win32ver.rc
Translation updates
commit : 73844356cfab995b9314f2a66e1de38bc8365f3f
author : Peter Eisentraut <[email protected]>
date : Mon, 8 Feb 2021 17:50:22 +0100
committer: Peter Eisentraut <[email protected]>
date : Mon, 8 Feb 2021 17:50:22 +0100
Click here for diff