jackc / pglogrepl

PostgreSQL logical replication library for Go.
MIT License
339 stars 63 forks source link

Issues with PostgreSQL <11 or >12 #43

Closed wttw closed 2 years ago

wttw commented 2 years ago

PostgreSQL 10 does not have the NOVERIFY_CHECKSUMS parameter to BASE_BACKUP, so StartBaseBackup() returns a syntax error if BaseBackupOptions.NoVerifyChecksums is set.

PostgreSQL 15 changes the syntax of the BASE_BACKUP command, to have parentheses around a comma-separated list of options rather than space separated options. It also changes some options - "WAIT false" instead of NOWAIT, "CHECKPOINT 'fast'" instead of "FAST" and "VERIFY_CHECKSUMS false" instead of "NOVERIFY_CHECKSUMS". This causes StartBaseBackup() to return a syntax error.

PostgreSQL 13 and later sends additional checkpoint requests which causes TestBaseBackup() to fail.

wttw commented 2 years ago

Fixed by #44