View source for SUNScholar/Upgrading/Server Software/Step 2

<center>
 '''[[SUNScholar/Upgrading/Server Software|Back to Upgrading Server]]'''
</center>

==STEP 2 - PostgreSQL upgrade==
===Upgrade 14.04 LTS to 16.04 LTS===
When installing a postgresql-X.Y package from scratch, a default cluster 'main' will automatically be created.

This operation is equivalent to doing 'pg_createcluster X.Y main --start'.

''Due to this default cluster, an immediate attempt to upgrade an earlier 'main' cluster to a new version will fail and you need to remove the newer default cluster first.''

E. g., if you have postgresql-9.3 installed and want to upgrade to 9.5, you first install postgresql-9.5:

  apt-get install postgresql-9.5 (This will be done automatically with a system upgrade)

After the Ubuntu upgrade, then drop the default 9.5 cluster:

  pg_dropcluster 9.5 main --stop

And then upgrade the 9.3 cluster to 9.5:

  pg_upgradecluster 9.3 main

===Upgrade 12.04 LTS to 14.04 LTS===
When installing a postgresql-X.Y package from scratch, a default cluster 'main' will automatically be created.

This operation is equivalent to doing 'pg_createcluster X.Y main --start'.

''Due to this default cluster, an immediate attempt to upgrade an earlier 'main' cluster to a new version will fail and you need to remove the newer default cluster first.''

E. g., if you have postgresql-9.1 installed and want to upgrade to 9.3, you first install postgresql-9.3:

  apt-get install postgresql-9.3 (This will be done automatically with a system upgrade)

After the Ubuntu upgrade, then drop the default 9.3 cluster:

  pg_dropcluster 9.3 main --stop

And then upgrade the 9.1 cluster to 9.3:

  pg_upgradecluster 9.1 main

===Upgrade 10.04 LTS to 12.04 LTS===
When installing a postgresql-X.Y package from scratch, a default cluster 'main' will automatically be created.

This operation is equivalent to doing 'pg_createcluster X.Y main --start'.

''Due to this default cluster, an immediate attempt to upgrade an earlier 'main' cluster to a new version will fail and you need to remove the newer default cluster first.''

E. g., if you have postgresql-8.4 installed and want to upgrade to 9.1, you first install postgresql-9.1:

  apt-get install postgresql-9.1 (This will be done automatically with a system upgrade)

After the Ubuntu upgrade, then drop the default 9.1 cluster:

  pg_dropcluster 9.1 main --stop

And then upgrade the 8.4 cluster to 9.1:

  pg_upgradecluster 8.4 main

===Upgrade 8.04 LTS to 10.04 LTS===
When installing a postgresql-X.Y package from scratch, a default cluster 'main' will automatically be created.

This operation is equivalent to doing 'pg_createcluster X.Y main --start'. 

''Due to this default cluster, an immediate attempt to upgrade an earlier 'main' cluster to a new version will fail and you need to remove the newer default cluster first.''

E. g., if you have postgresql-8.3 installed and want to upgrade to 8.4, you first install postgresql-8.4:
 apt-get install postgresql-8.4  (This will be done automatically with a system upgrade)
After the Ubuntu upgrade, then drop the default 8.4 cluster:
 pg_dropcluster 8.4 main --stop
And then upgrade the 8.3 cluster to 8.4:
 pg_upgradecluster 8.3 main
[[Category:System Administration]]