PostgreSQL Upgrade from 9.6. to 11
I recently upgraded one of my PostgreSQL clusters to version 11.
Since then, cmon is not able pull the config file, because it is still trying the old 9.6 path.
(WARNING) Could not pull config file '/etc/postgresql/9.6/main/postgresql.conf' from <hidden server name>: /bin/cat: /etc/postgresql/9.6/main/postgresql.conf: No such file or directory
How can I change the path to the correct value for version 11?
Thank you in advance
Currently, there's no way to do this easily via ClusterControl as we don't support upgrade on Postgres yet as what you came across now. Although you can rename the configuration files since it had changed including the path but also naming conventions such as pg_xlog to pg_wal for example. But I cannot recommend this. The nearest and safest to do is to delete the cluster and re-import the nodes but this time as Postgres 11 version.
Our devs mentioned that there's already an on-going jira ticket for this so this can be provided in the future but we cannot promise you when it can be released.
Please sign in to leave a comment.