pgsql: Extend check_GUC_init() with checks on flag combinations when lo

2023-02-05 Thread Michael Paquier
Extend check_GUC_init() with checks on flag combinations when loading GUCs This extends the work begun by a73952b, with the addition of a GUC check for flag combinations in check_GUC_init(), making sure that anything defined with GUC_NO_SHOW_ALL also includes GUC_NOT_IN_SAMPLE, as first step. The

pgsql: Add support for progress reporting to pg_verifybackup

2023-02-05 Thread Michael Paquier
Add support for progress reporting to pg_verifybackup This adds a new option to pg_verifybackup called -P/--progress, showing every second some information about the progress of the checksum verification based on the data of a backup manifest. Similarly to what is done for pg_rewind and pg_baseba

Re: pgsql: Do assorted mop-up in the planner.

2023-02-05 Thread Robins Tharakan
On Mon, 6 Feb 2023 at 05:57, Tom Lane wrote: > I'd hoped that some of these failures shared a root cause, but nope > they were really four different bugs :-(. I've now pushed fixes > for all four, and I hope you'll turn your fuzzer back on. This > is very valuable testing. Thanks Tom for fixing

pgsql: Revert refactoring of restore command code to shell_restore.c

2023-02-05 Thread Michael Paquier
Revert refactoring of restore command code to shell_restore.c This reverts commits 24c35ec and 57169ad. PreRestoreCommand() and PostRestoreCommand() need to be put closer to the system() call calling a restore_command, as they enable in_restore_command for the startup process which would in turn

pgsql: Release notes for 15.2, 14.7, 13.10, 12.14, 11.19.

2023-02-05 Thread Tom Lane
Release notes for 15.2, 14.7, 13.10, 12.14, 11.19. Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/e8c21223e758000be6040785f2cfd0916dc05e97 Modified Files -- doc/src/sgml/release-14.sgml | 1008 ++ 1 file cha

pgsql: Release notes for 15.2, 14.7, 13.10, 12.14, 11.19.

2023-02-05 Thread Tom Lane
Release notes for 15.2, 14.7, 13.10, 12.14, 11.19. Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/70192be7bd9ecc5e1e18989ab7a90ac00ce90e9b Modified Files -- doc/src/sgml/release-13.sgml | 827 +++ 1 file cha

pgsql: Release notes for 15.2, 14.7, 13.10, 12.14, 11.19.

2023-02-05 Thread Tom Lane
Release notes for 15.2, 14.7, 13.10, 12.14, 11.19. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a4e7cb5b7dab68dca1003ec6e9186860a09777a9 Modified Files -- doc/src/sgml/release-12.sgml | 770 +++ 1 file cha

pgsql: Release notes for 15.2, 14.7, 13.10, 12.14, 11.19.

2023-02-05 Thread Tom Lane
Release notes for 15.2, 14.7, 13.10, 12.14, 11.19. Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/80d43843e70aaa168d17f9a0c2ecc8c88a46b430 Modified Files -- doc/src/sgml/release-15.sgml | 116 +++ 1 file cha

pgsql: Release notes for 15.2, 14.7, 13.10, 12.14, 11.19.

2023-02-05 Thread Tom Lane
Release notes for 15.2, 14.7, 13.10, 12.14, 11.19. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1efc127978f8c90f8fe9225b85b1a2adba3a2ea0 Modified Files -- doc/src/sgml/release-11.sgml | 674 +++ 1 file cha

Re: pgsql: Do assorted mop-up in the planner.

2023-02-05 Thread Tom Lane
Robins Tharakan writes: > I'll probably switch off testing master for a day (and probably stop > posting more on this thread), but thought I'd post one last > (seemingly different) signature around the same commit, before > I wrap up for the day. I'd hoped that some of these failures shared a roo

pgsql: Fix over-optimistic updating of info about commutable outer join

2023-02-05 Thread Tom Lane
Fix over-optimistic updating of info about commutable outer joins. make_outerjoininfo was set up to update SpecialJoinInfo's commute_below, commute_above_l, commute_above_r fields as soon as it found a pair of outer joins that look like they can commute. However, this decision could be negated lat