The host was running postgresql v10, which is unsupported. After upgrading the DB to v12 the migrations worked as expected.
The host was running postgresql v10, which is unsupported. After upgrading the DB to v12 the migrations worked as expected.