Liquibase is not creating database after setting createDatabaseIfNotExist=true

Question

I added database configuration in build.gradle

liquibase {
   activities {
   main {      
      changeLogFile "${this.rootDir}/src/main/resources/changelog-master.xml"
      url "jdbc:postgresql://localhost:5432/test?createDatabaseIfNotExist=true"
      username "xxxx"
      password "xxxx"

     } 
  }
 runList = 'main'
}

createDatabaseIfNotExist is set to true in the URL.

When I start the server, it gives database does not exists.

I want liquibase to create database if it doesn't exists.

Any suggestions please

score 1 · Answer 1 · answered Jul 14 '15 at 07:41

1

This is a postgres jdbc issue, not liquibase.

I searched the postgres documentation and could not find "createDatabaseIfNotExist". Is that a mysql connection parameter?

answered Jul 14 '15 at 07:41

Mark O'Connor

76,015
10
139
185

1

Yes its mysql. How to create postgresql database if not exists after server start for java based web application? – Sindhu Shashidhar Jul 14 '15 at 16:23
See: http://stackoverflow.com/questions/18389124/simulate-create-database-if-not-exists-for-postgresql – Mark O'Connor Jul 15 '15 at 00:34

Liquibase is not creating database after setting createDatabaseIfNotExist=true

1 Answers1