Page Comparison

Steps to test liquibase changeset

...

• liquibase.rollbackCount - reverts a specified number of changesets sequentially, starting with the most recent changes and working backward until the value specified is reached :

  • 
    

    Code Block
    mvn clean compile org.liquibase:liquibase-maven-plugin:3.8.7:rollback -Dliquibase.url=jdbc:postgresql://localhost:5432/cpsdb

    \

    -Dliquibase.username=cps

    \

    -Dliquibase.password=cps

    \

    -Dliquibase.changeLogFile=changelog/changelog-master.yaml -Dliquibase.rollbackCount=x

    
    

• liquibase.rollbackTag - reverts all changes that were made to the database after the specified tag:

  • 
    

    Code Block
    mvn clean compile org.liquibase:liquibase-maven-plugin:3.8.7:rollback -Dliquibase.url=jdbc:postgresql://localhost:5432/cpsdb

    \

    -Dliquibase.username=cps

    \

    -Dliquibase.password=cps

    \

    -Dliquibase.changeLogFile=changelog/changelog-master.yaml -Dliquibase.rollbackTag=<liquibase_tag_for_changesets_to_be_rolled_back>

    
    

• liquibase.rollbackDate - reverts all changes made to your database from today's date to the date and time you specify.

  • 
    

    Code Block
    mvn clean compile org.liquibase:liquibase-maven-plugin:3.8.7:rollback -Dliquibase.url=jdbc:postgresql://localhost:5432/cpsdb

    \

    -Dliquibase.username=cps

    \

    -Dliquibase.password=cps

    \

    -Dliquibase.changeLogFile=changelog/changelog-master.yaml -Dliquibase.rollbackDate=2020-11-26

    
    

Note about rollback

See:

* https://docs.liquibase.com/concepts/bestpractices.html in "Always think about rollback" section
* https://docs.liquibase.com/workflows/liquibase-community/using-rollback.html