1

Theres a way to upgrade a cluster of postgreSQL to specific version?.

An example:

I have a 9.4.17 - 9.6.8 and 10.3

The 10.3 has cluster on The 9.4.17 has cluster on

I need upgrade the 9.4.17 to 9.6.8, i'm wondering if i use:

pg_upgradecluster 9.4 main

The cluster will be upgraded to the latest version ( i guess 10.3 ). I need update the cluster to 9.6.8

fantasia
  • 13
  • 2

1 Answers1

1

The -v flag of pg_upgradecluster allows you to specify the new version you want.

From https://manpages.debian.org/stretch/postgresql-common/pg_upgradecluster.1.en.html :

-v newversion
Set the version to upgrade to (default: latest available). 

So pg_upgradecluster -v 9.6.8 9.4 main for you.

It is of course always recommended to have backups before starting anything.

Patrick Mevzek
  • 9,273
  • 7
  • 29
  • 42