Upgrade to more recent postgres version

[uweschaefer]

currently using 11.5. We'd need to make sure that more recent versions work as expected.

[bedaka]

Will try to move 15.2 (latest supported by RDS)

[uweschaefer]

There is a snag to this: (Credits to @mweirauch )

2023-02-22 09:42:58.511 ERROR 101 — [ main]
liquibase.changelog.ChangeSet : Change Set
classpath:/db/changelog/db.changelog-master.yaml::transformationcache_and_schemastore_col_to_jsonb::uweschaefer
failed. Error: ERROR: DISCARD ALL cannot be executed within a pipeline
[Failed SQL: (0) ALTER TABLE fact ALTER COLUMN header SET STORAGE
MAIN, ALTER COLUMN payload SET STORAGE EXTENDED;

A similar report:
liquibase/liquibase#3806
related (and linked from above issue):
DbUp/dbup-postgresql#10
https://www.postgresql.org/message-id/4139340.1676050723%40sss.pgh.pa.us

[uweschaefer]

liquibase seems to use a batch, where it should not.

[mweirauch]

Any recently released (2023-03) minor of PostgreSQL is affected. We trapped into this with 13.10. Unfortunately that liquibase issue didn't get much traction, yet.

(Sorry for not creating the ticket when you asked for Uwe. Life's kinda busy over here.)

[bedaka]

In this case we'll pause this issue to see if they can come up with a solution.

[otbe]

I started working on a workaround for the liquibase issue and some other minor fixes for PG15 compatibility. Stay tuned 🥳