Cannot find database driver: org.postgresql.Driver for RDS postgres connection-Liquibase

Liquibase Development
1

I am trying to connect to RDS postgres from liquibase. Maven dependency is :

<dependency>
    <groupId>software.aws.rds</groupId>
    <artifactId>aws-postgresql-jdbc</artifactId>
    <version>0.1.0</version>
</dependency>

I am not using properties file as the credentials are confidential and I cannot put them in properties file. hence calling using command line

-liquibase --url:jdbc:postgressql://xxxx.rds.amazonaws.com:5432/database_name --username = $username --password = $password --changeLogFile=changelog_aurora.xml update

Also tried :

-liquibase --url:jdbc:postgressql://xxxx.rds.amazonaws.com:5432/database_name --username = $username --password = $password --changeLogFile=changelog_aurora.xml --driver=org.postgressql.Driver update

I am getting below error:

Unexpected error running liquibase: java.lang.RuntimeException:Cannot find database driver: org.postgres.Driver

Please help me here. Do i need to install postgres dependency as well? If so what should be the version? should it match with AWS RDS postgres?

2

I’m not familiar with Liquibase execution via Maven, but do you have the Postgres jdbc driver in Liquibase’s “lib” directory?