Skip to content

v0.5.0-M1

Compare
Choose a tag to compare
@mkubala mkubala released this 25 Feb 10:49
· 337 commits to master since this release
4a81fdf

Highlights

This release brings major change for journals partitioned by ordering values. (persistence_id, sequence_number) index is now unique and can be (re)built without taking any locks that prevent concurrent inserts, updates, or deletes on the table. In other words migration can be lockless.

See full list of changes: https://github.com/SwissBorg/akka-persistence-postgres/milestone/7?closed=1

Migration from akka-persistence-postgres 0.4.0

New indices need to be created on each partition, to avoid locking production databases for too long, it should be done in 2 steps:

  1. manually create indices CONCURRENTLY,
  2. deploy new release with migration scripts.

Manually create indices CONCURRENTLY

Execute DDL statements produced by the sample migration script, adapt top level variables to match your journal configuration before executing.

Deploy new release with migration scripts

See sample flyway migration script and adapt top level variables to match your journal configuration.