CODEWITHSUNDEEP
postgresqlcitus
Nils
Nils

Reputation: 146

Update PostgreSQL 14 to 15 with active citus extension

I am trying to use the official way to upgrade from PG 14 to 15 with Citus. If I would follow these instructions, I would have upgraded PG, but not citus, since nowhere the citus111_15 rpm is being installed (CentOS 7)? I am a little bit confused about this.

It says update citus first, then postgres...

Upvotes: 1

Views: 539

Answers (1)

Nils
Nils

Reputation: 146

I now installed postgres15 first and then did the pg_upgrade --check.

There is an error since the citus extension is missing.

So after installing citus111_15 the check looks ok.

So the citus-upgrades that have to be done first are to be done on the old major version of postgres - here 14.5. e.g. from citus 11.0 to 11.1.4. Now the procedure is clear to me.

Upvotes: 1

Related Questions