aboutsummaryrefslogtreecommitdiff
path: root/contrib/postgres_fdw/option.c
diff options
context:
space:
mode:
authorMichael Paquier <michael@paquier.xyz>2021-10-26 09:30:37 +0900
committerMichael Paquier <michael@paquier.xyz>2021-10-26 09:30:37 +0900
commitf61e1dd2cee6b1a1da75c2bb0ca3bc72f18748c1 (patch)
treed7b636d11bc014ae29eb2ff32b5878b4dbb3b6d6 /contrib/postgres_fdw/option.c
parent8781b0ce25e702ba4a4f032d00da7acdef8dbfe1 (diff)
downloadpostgresql-f61e1dd2cee6b1a1da75c2bb0ca3bc72f18748c1.tar.gz
postgresql-f61e1dd2cee6b1a1da75c2bb0ca3bc72f18748c1.zip
Allow pg_receivewal to stream from a slot's restart LSN
Prior to this patch, when running pg_receivewal, the streaming start point would be the current location of the archives if anything is found in the local directory where WAL segments are written, and pg_receivewal would fall back to the current WAL flush location if there are no archives, as of the result of an IDENTIFY_SYSTEM command. If for some reason the WAL files from pg_receivewal were moved, it is better to try a restart where we left at, which is the replication slot's restart_lsn instead of skipping right to the current flush location, to avoid holes in the WAL backed up. This commit changes pg_receivewal to use the following sequence of methods to determine the starting streaming LSN: - Scan the local archives. - Use the slot's restart_lsn, if supported by the backend and if a slot is defined. - Fallback to the current flush LSN as reported by IDENTIFY_SYSTEM. To keep compatibility with older server versions, we only attempt to use READ_REPLICATION_SLOT if the backend version is at least 15, and fallback to the older behavior of streaming from the current flush LSN if the command is not supported. Some TAP tests are added to cover this feature. Author: Ronan Dunklau Reviewed-by: Kyotaro Horiguchi, Michael Paquier, Bharath Rupireddy Discussion: https://postgr.es/m/18708360.4lzOvYHigE@aivenronan
Diffstat (limited to 'contrib/postgres_fdw/option.c')
0 files changed, 0 insertions, 0 deletions