pgsql: Doc: Fix the ambiguity in the description of failover slots.

2024-08-28 Thread Amit Kapila
Doc: Fix the ambiguity in the description of failover slots. The failover slots ensure a seamless transition of a subscriber after the standby is promoted. But the docs for it also explain the behavior of asynchronous replication which can confuse the readers. Reported-by: Masahiro Ikeda Backpatc

pgsql: Doc: Fix the ambiguity in the description of failover slots.

2024-08-28 Thread Amit Kapila
Doc: Fix the ambiguity in the description of failover slots. The failover slots ensure a seamless transition of a subscriber after the standby is promoted. But the docs for it also explain the behavior of asynchronous replication which can confuse the readers. Reported-by: Masahiro Ikeda Backpatc

pgsql: Rename the conflict types for the origin differ cases.

2024-08-28 Thread Amit Kapila
Rename the conflict types for the origin differ cases. The conflict types 'update_differ' and 'delete_differ' indicate that a row to be modified was previously altered by another origin. Rename those to 'update_origin_differs' and 'delete_origin_differs' to clarify their meaning. Author: Hou Zhij

pgsql: Fixup for prefetching support on macOS

2024-08-28 Thread Peter Eisentraut
Fixup for prefetching support on macOS The new code path (commit 6654bb92047) should call FileAccess() first, like the posix_fadvise() path. Reported-by: Thomas Munro Discussion: https://www.postgresql.org/message-id/flat/0827edec-1317-4917-a186-035eb1e3241d%40eisentraut.org Branch -- mast

pgsql: Refactor some code for ALTER TABLE SET LOGGED/UNLOGGED in tablec

2024-08-28 Thread Michael Paquier
Refactor some code for ALTER TABLE SET LOGGED/UNLOGGED in tablecmds.c Both sub-commands use the same routine to switch the relpersistence of a relation, duplicated the same checks, and used a style inconsistent with access methods and tablespaces. SET LOGEED/UNLOGGED is refactored to avoid any du