Using Liquibase with PostgreSQL Platforms

PostgreSQL is an open-source, object-relational database system that supports a large part of the SQL standard and offers many modern features. For more information, see the PostgreSQL documentation page.

You can use Liquibase with several PostgreSQL database management systems, including PostgreSQL, PostgreSQL AWS RDS, Postgres AWS Aurora, Google Cloud SQL, and Azure Database on Postgres.

Getting started tutorials

To learn how to configure your PostgreSQL database with Liquibase, see the following topics:

Verified database versions

PostgreSQL PostgreSQL AWS RDS PostgreSQL AWS Aurora PostgreSQL Azure Database Google Cloud SQL
  • 16
  • 15
  • 14
  • 13
  • 12
  • 16
  • 15
  • 14
  • 13
  • 12
  • 16
  • 15
  • 14
  • 13
  • 12
  • 11
 Flexible Server:
  • 16
  • 15
  • 13
Single Server:
  • 11
  • 14
  • 13
  • 12
  • 11

Deprecated Versions

  • PostgreSQL Server 11 and Amazon AWS RDS for PostgreSQL 11 are deprecated as of November 9, 2023.

    • Liquibase support for these versions ends on February 7, 2024.
    • Other versions remain supported.
Change Type Supported
addAutoIncrement Supported
addCheckConstraint Supported
addColumn Supported
addDefaultValue Supported
addForeignKeyConstraint Supported
addLookupTable Supported
addNotNullConstraint Supported
addPrimaryKey Supported
addUniqueConstraint Supported
alterSequence Supported
createFunction Supported
createIndex Supported
createPackage Supported
createPackageBody Supported
createProcedure Supported
createSequence Supported
createSynonym Not Supported
createTable Supported
createTrigger Supported
createView Supported
customChange Supported
delete Supported
disableCheckConstraint Not Supported
disableTrigger Supported
dropAllForeignKeyConstraints Supported
dropCheckConstraint Supported
dropColumn Supported
dropDefaultValue Supported
dropForeignKeyConstraint Supported
dropFunction Supported
dropIndex Supported
dropNotNullConstraint Supported
dropPackage Supported
dropPackageBody Supported
dropPrimaryKey Supported
dropProcedure Supported
dropSequence Supported
dropSynonym Not Supported
dropTable Supported
dropTrigger Supported
dropUniqueConstraint Supported
dropView Supported
empty Supported
enableCheckConstraint Not Supported
enableTrigger Supported
executeCommand Supported
insert Supported
loadData Supported
loadUpdateData Supported
markUnused Not Supported
mergeColumns Supported
modifyDataType Supported
output Supported
renameColumn Supported
renameSequence Supported
renameTable Supported
renameTrigger Supported
renameView Supported
setColumnRemarks Supported
setTableRemarks Supported
sql Supported
sqlFile Supported
stop Supported
tagDatabase Supported
update Supported
Command Supported
calculate-checksum Supported
changelog-sync Supported
changelog-sync-sql Supported
changelog-sync-to-tag Supported
changelog-sync-to-tag-sql Supported
clear-checksums Supported
db-doc Supported
diff Supported
diff JSON Supported
diff-changelog Supported
drop-all Supported
future-rollback-count-sql Supported
future-rollback-from-tag-sql Supported
future-rollback-sql Supported
generate-changelog Supported
help Supported
history Supported
list-locks Supported
mark-next-changeset-ran Supported
mark-next-changeset-ran-sql Supported
release-locks Supported
rollback Supported
rollback-count Supported
rollback-count-sql Supported
rollback-one-changeset Supported
rollback-one-changeset-sql Supported
rollback-one-update Supported
rollback-one-update-sql Supported
rollback-sql Supported
rollback-to-date Supported
rollback-to-date-sql Supported
snapshot Supported
snapshot-reference Supported
status Supported
tag Supported
tag-exists Supported
unexpected-changesets Supported
update Supported
update-sql Supported
update-count Supported
update-count-sql Supported
update-testing-rollback Supported
update-to-tag Supported
update-to-tag-sql Supported
validate Supported

Related links