Upgrading Liquibase version from 4.5.0 to 4.23.1

General Discussion
1

Does anyone face this error when updating the liquibase version to 4.23.1 from 4.5.0?
My spring-boot version is pointed to 3.1.2 and I am using databasechangelog.yaml file as config for liquibase

Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: ERROR: cannot update table “databasechangelog” because it does not have a replica identity and publishes updates
Hint: To enable updating the table, set REPLICA IDENTITY using ALTER TABLE. [Failed SQL: (0) UPDATE {schemaName}.databasechangelog SET MD5SUM = NULL]

2

Hello @ponnatd ! Seems this error is not related to liquibase but it is a Postgresql configuration (PostgreSQL: Documentation: 12: 30.1. Publication) . The easier solution would be to run the following sql:

ALTER TABLE databasechangelog REPLICA IDENTITY FULL;