PostgreSQL Upgrade from 9.6. to 11

Follow

Christian Leonhardt

• April 03, 2020 11:52

Hello everyone,

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

Leo

 

0

• 

  Paul Namuag

  • April 03, 2020 15:02

  Hi Leo,

   

  We'll get back to you on this question. Either way, it seems you're right that cmon sticks to the old config but I have to confirm this.

  0

  Comment actions Permalink
• 

  Paul Namuag

  • April 03, 2020 16:17

  Hi Leo,

  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.

  0

  Comment actions Permalink
• 

  Christian Leonhardt

  • April 06, 2020 08:37

  Hi Paul,

  thank you for your fast reply.

  I created a symlink from 11 -> 9.6. At this point this is sufficient for me.

  I will looking forward for a better sollution.

  Have a great day.

  Leo

   

  0

  Comment actions Permalink

Please sign in to leave a comment.