jackc / pglogrepl

PostgreSQL logical replication library for Go.
MIT License
319 stars 59 forks source link

Base backups Postgres 10 #25

Closed JerrySievert closed 1 year ago

JerrySievert commented 2 years ago

Hi,

I'm attempting to use base backups on Postgres 10, and am receiving an error when running the tests:

error: unexpected response: &{%!t(string=ERROR) %!t(string=42601) %!t(string=syntax error) %!t(string=) %!t(string=) %!t(int32=0) %!t(int32=0) %!t(string=) %!t(string=) %!t(string=) %!t(string=) %!t(string=) %!t(string=) %!t(string=) %!t(string=repl_scanner.l) %!t(int32=217) %!t(string=replication_yyerror) map[%!t(uint8=86):%!t(string=ERROR)]}
--- FAIL: TestBaseBackup (0.01s)
    pglogrepl_test.go:351:
            Error Trace:    pglogrepl_test.go:351
            Error:          "0" is not greater than or equal to "1"
            Test:           TestBaseBackup
FAIL
exit status 1
FAIL    github.com/jackc/pglogrepl  0.812s

which essentially translates to:

&{ERROR 42601 syntax error   %!s(int32=0) %!s(int32=0)        repl_scanner.l %!s(int32=217) replication_yyerror map[%!s(uint8=86):ERROR]}

the error is being thrown by getBaseBackupInfo so I suspect something in the options is not compatible with pg10.

I'll update the ticket as I find more.

JerrySievert commented 2 years ago

looks like our winner is: NOVERIFY_CHECKSUMS.

this could be as easy a documentation addition.

jackc commented 2 years ago

this could be as easy a documentation addition.

👍