Postgres database creation with liquibase

Question

I'm trying to create an empty database using liqubase. I use this approach to do this, but the problem is it doesn't work for me.

I use Postgresql 10 and there are my configurations for maven and liqubase:

 <plugin>
          <groupId>org.liquibase</groupId>
          <artifactId>liquibase-maven-plugin</artifactId>
          <version>3.0.5</version>
          <configuration>
             <propertyFile>src/main/resources/liquibase/liquibase.properties</propertyFile>
          </configuration>
          <executions>
              <execution>
                    <phase>process-resources</phase>
                    <goals>
                        <goal>update</goal>
                    </goals>
              </execution>
          </executions>
  </plugin>

And my liqubase.properties:

changeLogFile=src/main/resources/liquibase/db.changelog.xml
driver=org.postgresql.Driver
dropFirst=false
url=jdbc:postgresql://localhost:5432/auth?createDatabaseIfNotExist=true
username=postgres
password=root

The error on mvn clean package is:

org.postgresql.util.PSQLException: FATAL: database "auth" does not exist

SteveDonie · Accepted Answer · 2018-05-01 16:39:24Z

4

Liquibase will not create a database that does not exist at all. I also imagine that the url parameter ?createDatabaseIfNotExist=true that is referenced in the linked question/answer is probably MySql specific.

answered May 1, 2018 at 16:39

SteveDonie

9,0463 gold badges47 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Randall · Accepted Answer · 2023-08-01 16:01:00Z

4

This is slightly beyond the scope of your question, but you could use liquibase against a Docker postgres instance, and per the docker-library's documentation on ENVIRONMENT VARIABLES, set POSTGRES_DB to "auth" (in your case), and it will create the "auth" db when the docker image launches, with which liquibase can then interact.

edited Aug 1, 2023 at 16:01

answered Oct 16, 2018 at 22:26

Randall

3,0642 gold badges24 silver badges30 bronze badges

Collectives™ on Stack Overflow

Postgres database creation with liquibase

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related