The target environment will be Azure PostgreSQL for this post’s purposes, but it can be any target database in accordance with your needs. The focus of this blog post will be to create a multi stage yaml pipeline for deploying database changes using Maven, Liquibase and Azure DevOps. However we have not discussed putting everything together and creating a multi stage pipeline using some sort of CI/CD tool like Azure DevOps, Jenkins, TeamCity etc. We have seen and discussed various commands and attributes available. When prompted, select PostgreSQL as the database type and enter the previously created PostgreSQL user information.In our previous series of blog posts, we discussed what is Liquibase and how we can leverage Liquibase to manage database changes and associated functionality. Navigate to port 8111 on the server in a web browser.Enter the following config into /etc/systemd/system/rvice: ĮxecStart=/opt/TeamCity/bin/teamcity-server.sh runĮxecStop=/opt/TeamCity/bin/teamcity-server.sh stop.Change ownership of the TeamCity directory to the teamcity user.usermod -shell /usr/sbin/nologin teamcity Disable logging in for the teamcity user.Create the teamcity user and home directory.Extract the tar.gz into the /opt directory.Be sure to replace the wget URL with the latest direct download link.

Download the tar.gz installer from the JetBrains Website.

CREATE USER teamcity WITH PASSWORD '-PASSWORDHERE-'

Exit psql and the postgres user when finished. Create the teamcity user and associated database.Login to the postgres account and login to the PostgreSQL database.apt-get install postgresql postgresql-contrib

Download teamcity ci cd