search

citusdata / citus_docs

Documentation for Citus. Distributed PostgreSQL as an extension.
Creative Commons Attribution 4.0 International
58 stars 59 forks source link

Improve upgrade steps for Citus 11 #1048

Closed onderkalaci closed 2 years ago

onderkalaci commented 2 years ago

I have two notes on citus_finalize_upgrade_to_citus11 UDF call:

Part 1:

So, we made this procedure a part of Citus version upgrade, not specific to Citus 11.0. So, after Citus 11.0, we want this always called. That's why, we renamed it to citus_finish_citus_upgrade (and made it a procedure). So, should we make the following as a regular text instead of a "Note"

If upgrading to Citus 11.x (or any later version), run this extra command:

-- only on the coordinator node
CALL citus_finish_citus_upgrade();

Part 2: When a user first ever crosses Citus 11.0 (so say could be an upgrade of 9.2 -> 11.2), the following is true. Maybe, we make only that part as "Note"? And, probably improve wording a bit?

When upgraded to Citus 11.0, the upgrade function will make sure that all worker nodes have the right schema and metadata. It may take several minutes to run, depending on how much metadata needs to be synced.