changelog-master-post-deploy.xml

<?xml version="1.0" encoding="UTF-8"?>  

<databaseChangeLog  
        xmlns="http://www.liquibase.org/xml/ns/dbchangelog"  
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
        xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext"  
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-4.5.xsd
        http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">  

<!-- placeholder for system objects creation to be run first during registry deployment -->
	<property  name="dbname" value="registry"/>

    <preConditions>
		<sqlCheck expectedResult="t">
			SELECT current_database() = '${dbname}'
		</sqlCheck>
    </preConditions>

	<changeSet author="registry owner" id="tag database post-deploy" context="all">
	  <tagDatabase tag="post-deploy"/>  
	</changeSet>

    <include file="changeLogs-postDeploy/publication.xml" context="pub" relativeToChangelogFile="true"/>
	<include file="changeLogs-postDeploy/subscription.xml" context="sub" relativeToChangelogFile="true"/>

	<changeSet author="registry owner" id="version control update" runAlways="true" runOnChange="true" context="all">
		<comment>Procedure to update registry versions</comment>
		<sql dbms="postgresql" endDelimiter=";" splitStatements="true" stripComments="true">
			CALL p_version_control('${reg_version}');
		</sql>
	</changeSet>

</databaseChangeLog>