pgsql: Handle compression level in pg_receivewal for LZ4

2022-04-17 Thread Michael Paquier
Handle compression level in pg_receivewal for LZ4 The new option set of pg_receivewal introduced in 042a923 to control the compression method makes it now easy to pass down various options, including the compression level. The change to be able to do is simple, and requires one LZ4F_preferences_t

pgsql: Fix race in TAP test 002_archiving.pl when restoring history fil

2022-04-17 Thread Michael Paquier
Fix race in TAP test 002_archiving.pl when restoring history file This test, introduced in df86e52, uses a second standby to check that it is able to remove correctly RECOVERYHISTORY and RECOVERYXLOG at the end of recovery. This standby uses the archives of the primary to restore its contents, wi

pgsql: Fix race in TAP test 002_archiving.pl when restoring history fil

2022-04-17 Thread Michael Paquier
Fix race in TAP test 002_archiving.pl when restoring history file This test, introduced in df86e52, uses a second standby to check that it is able to remove correctly RECOVERYHISTORY and RECOVERYXLOG at the end of recovery. This standby uses the archives of the primary to restore its contents, wi

pgsql: Fix race in TAP test 002_archiving.pl when restoring history fil

2022-04-17 Thread Michael Paquier
Fix race in TAP test 002_archiving.pl when restoring history file This test, introduced in df86e52, uses a second standby to check that it is able to remove correctly RECOVERYHISTORY and RECOVERYXLOG at the end of recovery. This standby uses the archives of the primary to restore its contents, wi

pgsql: Fix race in TAP test 002_archiving.pl when restoring history fil

2022-04-17 Thread Michael Paquier
Fix race in TAP test 002_archiving.pl when restoring history file This test, introduced in df86e52, uses a second standby to check that it is able to remove correctly RECOVERYHISTORY and RECOVERYXLOG at the end of recovery. This standby uses the archives of the primary to restore its contents, wi

pgsql: Fix race in TAP test 002_archiving.pl when restoring history fil

2022-04-17 Thread Michael Paquier
Fix race in TAP test 002_archiving.pl when restoring history file This test, introduced in df86e52, uses a second standby to check that it is able to remove correctly RECOVERYHISTORY and RECOVERYXLOG at the end of recovery. This standby uses the archives of the primary to restore its contents, wi

pgsql: Add additional documentation for row filters.

2022-04-17 Thread Amit Kapila
Add additional documentation for row filters. Commit 52e4f0cd47 added a feature to allow specifying row filters for logical replication of tables. This patch adds detailed documentation on that feature including examples to make it easier for users to understand. Author: Peter Smith, Euler Taveir

pgsql: Fix second race condition in 002_archiving.pl with archive_clean

2022-04-17 Thread Michael Paquier
Fix second race condition in 002_archiving.pl with archive_cleanup_command Checking the execution of archive_cleanup_command on a standby requires a valid checkpoint coming from its primary, but the logic did not check that the standby replayed up to the point of the checkpoint, causing the test c