Flyway 7.1.0 postgresql breaks our deployments. Currently stuck!!!
hkelderpxs
Posts: 4 Bronze 1
in PostgreSQL
Since release 7.1.0 Flyway / Postgresql adds OWNER statements.
e.g. ALTER PROCEDURE inp2.prc_purge_database() OWNER TO admin;
This breaks our deployment since the OWNER differs per target machine.
In previous releases no OWNER was set.
I am unable to find a previous 7.x version and the 6.8 version cannot be used due to changes in the project format.
Is there a setting to disable this new behavior?
Tagged:
Answers
Sorry, to hear you're experiencing this issue!
We have the following documentation page which shows how to disable owner/privileges in Postgres: https://documentation.red-gate.com/flyway/database-development-using-flyway-desktop/configuring-comparisons-and-script-generations/filters-ignore-rules/postgresql-and-mysql-filtering
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
As it turns out this does solve the issue.
Still what remains is that again and again you folks keep changing stuff in the behaviour of Flyway that is unexpected. In this case I lost most of the day trying to figure out what caused the problems I ran into.
I would strongly suggest including release notes where these kinds of behavioural changes are announced.