pgcopydb clone follow -- Failed to parse test_decoding message

[sivaprakash888]

Hi all,

We are using pgcopydb tool to a live migration of Postgresql DB to new hardware. When we pgcopydb clone follow, there were some errors in the follow process and follow exited with below errors. Error log file attached below,

pgcopydb clone --table-jobs 16 --index-jobs 16 --follow --dir /u04/pgcopydb > pgcopydb_output.log 2>&1 &

pgcopydb.log

[dimitri]

I see you're running pgcopydb v0.13. Current release is v0.15 ; please try again with that version, and if it does not work, please try also with the version from the current main branch, building from source or using the CI builds.

[sivaprakash888]

Thanks Dimitri for quick repsonse,

Currently production migration is struck here and your help will be really appreciated. Is this a known issue with v0.13 ? Because for installing v0.15, if you confirm it will give the confidence.

Please find more details,

Source : Postgres DB version 11 Target : Postgres DB Version 13 We are not using any migration server, we have installed pgcopydb on the target server. this should be fine right ?

[sivaprakash888]

Also I don't see pgcopydb v0.15 rpm in below downloads link. Please help if I miss something,

https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-8-x86_64/

[dimitri]

Currently production migration is struck here and your help will be really appreciated. Is this a known issue with v0.13 ? Because for installing v0.15, if you confirm it will give the confidence.

Well given pgcopydb team size it only makes sense for us to maintain a single release. The only maintained release at this point is the latest one, v0.15, and when we fix bugs then to benefit from the fixes you will have to use v0.16. About RPM releases, that's done by the Postgres RPM community, I don't know anything about that. All I can do is maybe kindly ping @devrimgunduz.

[devrimgunduz]

@sivaprakash888 @dimitri there is a build problem with 0.15 (which did not appear in 0.13). I'll create another issue for that

[devrimgunduz]

@sivaprakash888 oh, that issue does not affect RHEL 8 or 9. Will push the packages later today.

[sivaprakash888]

I am looking for RHEL 8. That will be a great help @devrimgunduz !!

Thanks again for all support & effort @devrimgunduz @dimitri

[sivaprakash888]

@sivaprakash888 oh, that issue does not affect RHEL 8 or 9. Will push the packages later today.

@devrimgunduz I can see v0.15 is now uploaded for RHEL 9 but still unavailable for RHEL 8.

[hanefi]

@sivaprakash888 v0.17 rpms are available since Aug 23. FYI.