English 中文(简体)
Flyway: Support for older DB s
原标题:

I m currently trying to set up some simple migration scripts for our databases. I was checking flyway, which seems to be simple enough for what I need. My problem is that, for Postgres, only version 9 is supported (we re using 8.4). Is it possible to work around/fix this limitation somehow, or should I start looking for other options?

Edit: I forgot to mention that when I run something like mvn flyway:status, I get the error message:

Flyway Error: java.lang.IllegalArgumentException: Unsupported Database: PostgreSQL

I can connect to the DB via psql, and I m using the correct jdbc driver, so when I saw the requirements page in the documentation, I assumed that the version was explicitly checked by flyway.

问题回答

What limitations do you encounter? Flyway is only tested on PostgreSQL version 9.0, that s it. It s not said that older PostgreSQL versions don t work. Just give it a try.

You could also setup a PostgreSQL 9.0 installation on your testbox to see if there is any difference.





相关问题
摘录数据

我如何将Excel板的数据输入我的Django应用? I m将PosgreSQL数据库作为数据库。

Postgres dump of only parts of tables for a dev snapshot

On production our database is a few hundred gigabytes in size. For development and testing, we need to create snapshots of this database that are functionally equivalent, but which are only 10 or 20 ...

How to join attributes in sql select statement?

I want to join few attributes in select statement as one for example select id, (name + + surname + + age) as info from users this doesn t work, how to do it? I m using postgreSQL.

What text encoding to use?

I need to setup my PostgreSQL DB s text encoding to handle non-American English characters that you d find showing up in languages such as German, Spanish, and French. What character encoding should ...

SQL LIKE condition to check for integer?

I am using a set of SQL LIKE conditions to go through the alphabet and list all items beginning with the appropriate letter, e.g. to get all books where the title starts with the letter "A": SELECT * ...

热门标签