pgsql: Add support for zstd base backup compression.

2022-03-08 Thread Robert Haas
Add support for zstd base backup compression. Both client-side compression and server-side compression are now supported for zstd. In addition, a backup compressed by the server using zstd can now be decompressed by the client in order to accommodate the use of -Fp. Jeevan Ladhe, with some edits

pgsql: Fix LZ4 tests for remaining buffer space.

2022-03-08 Thread Robert Haas
Fix LZ4 tests for remaining buffer space. We should flush the buffer when the remaining space is less than the maximum amount that we might need, not when it is less than or equal to the maximum amount we might need. Jeevan Ladhe, per an observation from me. Discussion: http://postgr.es/m/canm2

pgsql: plpython: add missing plpython.h include to plpy_plpymodule.h

2022-03-08 Thread Andres Freund
plpython: add missing plpython.h include to plpy_plpymodule.h The include was missing before 9b7e24a2cb3, but starting with that commit the missing include causes cpluspluscheck to fail because the use of PyMODINIT_FUNC isn't incidentally protected by an ifdef anymore. Discussion: https://postgr

pgsql: Stabilize test_decoding touching with sequences

2022-03-08 Thread Tomas Vondra
Stabilize test_decoding touching with sequences Some of the test_decoding regression tests are unstable due to modifying a sequence. The first increment of a sequence after a checkpoint is always logged (and thus decoded), which makes the output unpredictable. The runs are usually much shorter tha

pgsql: plpython: Restore alternative output for plpython_error test.

2022-03-08 Thread Andres Freund
plpython: Restore alternative output for plpython_error test. In db23464715f I removed the alternative output for plpython_error. Wrongly so, because the output changed in Python 3.5, not Python 3. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/43e7787dd3387a7455fc

pgsql: doc: Improve references to term "FSM" in pageinspect and pgfrees

2022-03-08 Thread Michael Paquier
doc: Improve references to term "FSM" in pageinspect and pgfreespacemap Author: Dong Wook Lee Reviewed-by: Laurenz Albe Discussion: https://postgr.es/m/CAAcBya+=F=HaHxJ7tGjAM1r=A=+bdbimpsex8vqrb4gjqfd...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdif

pgsql: doc: Add ALTER/DROP ROUTINE to the event trigger matrix

2022-03-08 Thread Michael Paquier
doc: Add ALTER/DROP ROUTINE to the event trigger matrix ALTER ROUTINE triggers the events ddl_command_start and ddl_command_end, and DROP ROUTINE triggers sql_drop, ddl_command_start and ddl_command_end, but this was not mention on the matrix table. Reported-by: Leslie Lemaire Discussion: https:

pgsql: doc: Add ALTER/DROP ROUTINE to the event trigger matrix

2022-03-08 Thread Michael Paquier
doc: Add ALTER/DROP ROUTINE to the event trigger matrix ALTER ROUTINE triggers the events ddl_command_start and ddl_command_end, and DROP ROUTINE triggers sql_drop, ddl_command_start and ddl_command_end, but this was not mention on the matrix table. Reported-by: Leslie Lemaire Discussion: https:

pgsql: doc: Add ALTER/DROP ROUTINE to the event trigger matrix

2022-03-08 Thread Michael Paquier
doc: Add ALTER/DROP ROUTINE to the event trigger matrix ALTER ROUTINE triggers the events ddl_command_start and ddl_command_end, and DROP ROUTINE triggers sql_drop, ddl_command_start and ddl_command_end, but this was not mention on the matrix table. Reported-by: Leslie Lemaire Discussion: https:

pgsql: doc: Add ALTER/DROP ROUTINE to the event trigger matrix

2022-03-08 Thread Michael Paquier
doc: Add ALTER/DROP ROUTINE to the event trigger matrix ALTER ROUTINE triggers the events ddl_command_start and ddl_command_end, and DROP ROUTINE triggers sql_drop, ddl_command_start and ddl_command_end, but this was not mention on the matrix table. Reported-by: Leslie Lemaire Discussion: https:

pgsql: doc: Add ALTER/DROP ROUTINE to the event trigger matrix

2022-03-08 Thread Michael Paquier
doc: Add ALTER/DROP ROUTINE to the event trigger matrix ALTER ROUTINE triggers the events ddl_command_start and ddl_command_end, and DROP ROUTINE triggers sql_drop, ddl_command_start and ddl_command_end, but this was not mention on the matrix table. Reported-by: Leslie Lemaire Discussion: https: