Using Liquibase With Maven Plugin

General Discussion
1

Having an issue with my liquibase I have setup via a liquibase.properties and my pom.xml

Here is my liquibase.properties(obviously make some variables to show example here):

url: jdbc:postgresql://$DATABASE_TO_DEPLOY_TO:5432/$DATABASE_NAME
username: $RDSUSER
password: $RDSPASS
verbose: true
liquibase.liquibaseSchemaName: “public”
defaultSchemaName: “public”
changelogSchemaName: “public”
driver: org.postgresql.Driver

However, when I run the liquibase via my pom:

<build>
    <plugins>
        <plugin>
            <groupId>org.liquibase</groupId>
            <artifactId>liquibase-maven-plugin</artifactId>
            <version>4.5.0</version>
            <configuration>
                <propertyFileWillOverride>true</propertyFileWillOverride>
                <promptOnNonLocalDatabase>false</promptOnNonLocalDatabase>
                <propertyFile>liquibase.properties</propertyFile>
                <changeLogFile>db.changelog-scorch.xml</changeLogFile>
            </configuration>
        </plugin>
    </plugins>
</build>

I get the following error:
[ERROR] Error setting up or running Liquibase:
[ERROR] liquibase.exception.DatabaseException: ERROR: no schema has been selected to create in
[ERROR] Position: 14 [Failed SQL: (0) CREATE TABLE databasechangeloglock (ID INTEGER NOT NULL, LOCKED BOOLEAN NOT NULL, LOCKGRANTED TIMESTAMP WITHOUT TIME ZONE, LOCKEDBY VARCHAR(255), CONSTRAINT databasechangeloglock_pkey PRIMARY KEY (ID))]

I’ve been banging my head every which way to figure out why it’s not selecting public as my default schema and my liquibase schema
I also tried with
liquibaseSchemaName: “public”
And not quoting it as well.

But this did not resolve it. Not sure what I’m doing wrong here.

2

Found out the issue was as follows:
you need to set the property:

but that is NOT the schema you are intending to use as your liquibase schema.