Configuration does not include shared_preloaded_libraries when performing pg_upgrade
Summary
Check why configuration does not include shared_preloaded_libraries when performing pg_upgrade
Current Behaviour
Having an cluster with an extension that requires to be in shared_preloaded_libraries
like citus
and performing a major version upgrade operation the pg_upgrade
command fails telling that citus
is missing from shared_preloaded_libraries
.
Steps to reproduce
- Create a cluster for postgres 13 with citus extension version 10.2
- Run the command
SELECT citus_prepare_pg_upgrade();
on the primary instance - Perform a major version upgrade to postgres 14
- Run the command
SELECT citus_finish_pg_upgrade();
(step not doable just here for reference on complete operation).
Expected Behavior
The cluster major version upgrade operation completes
Possible Solution
Launch Patroni in order to generate the final configuration for the cluster.
Environment
- StackGres version: 1.1.0-RC1
- Kubernetes version: ?
- Cloud provider or hardware configuration: ?
Relevant logs and/or screenshots
Edited by Matteo Melli