Showing details for patch bf5ca6f7245f506d957ba6143b46c421f5f7602d.
2024-02-02 (Fri), 8:52 AM - Jens Grassel - bf5ca6f7245f506d957ba6143b46c421f5f7602d
TAG v0.11.0
This release contains BREAKING CHANGES in the database structure!
To mitigate the effect create a backup of your database first. Then follow
these instructions:
1. stop the service
2. dump the data of your database only (`pg_dump -a dbname > data.sql`)
3. !!! Remove the `flyway_schema_history` tables from the dump !!!
4. drop the database and create a new one with the same name
5. apply the update
6. start the service
7. stop the service after the migrations have been applied
8. restore the data (`cat data.sql | psql dbname`)
Please note that you might need additional parameters for `pg_dump` and `psql`
depending on your database configuration like username, password or prepended
`sudo` command.
Changed
-------
- **BREAKING CHANGE** remove unnecessary quoting in sql