SUNScholar/Upgrading/Server Software/Step 2

Back to Upgrading Server

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