Hi, I tried to use flywayDB with Amazon Redshift. But, it does not work.
There is no problem for us to use PostgreSQL JDBC driver to connect with Redshift. But, I am failure when I connect flywayDB with Redshift as if redshift is a postgreSQL.
I forked flywaydb source code. and found out it because flyway postgresql support uses some SQL feature and system tables that Redshift does not support now.
I feel it will not be difficult to add support to Redshift with postgreSQL support as a reference.
Will anybody here to work on it? I can do it too with some support from here.
thanks and regards,
The text was updated successfully, but these errors were encountered:
Sure, it shouldn't be that far off. Redshift is based on a stone age version of Postgres (8.0, released 9 years ago!!!). Flyway's Postgres support has been geared at Postgres 9.0 and up.
You can start by implementing DbSupport for Postgres 8.x by using the Postgres 9.x support (https://github.com/flyway/flyway/tree/master/flyway-core/src/main/java/com/googlecode/flyway/core/dbsupport/postgresql) as a base.
Don't forget to make the MigrationTestCase run with Postgres 8.x as well.
Pull request welcome.