SUNScholar/Upgrading/Server Software/Step 2 - Revision history

Hgibson at 09:15, 28 May 2016

2016-05-28T09:15:39Z

Hgibson: /* STEP 2 - PostgreSQL upgrade */

2016-05-24T09:46:18Z

STEP 2 - PostgreSQL upgrade

Hgibson: /* Upgrade 12.04 LTS to 14.04 LTS */

2016-05-04T10:19:47Z

Upgrade 12.04 LTS to 14.04 LTS

Hgibson: /* Upgrade 14.04 LTS to 16.04 LTS */

2016-05-04T10:19:04Z

Upgrade 14.04 LTS to 16.04 LTS

Hgibson: /* Upgrade 12.04 LTS to 14.04 LTS */

2016-05-04T10:17:19Z

Upgrade 12.04 LTS to 14.04 LTS

Hgibson: /* STEP 2 - PostgreSQL upgrade */

2016-05-04T10:16:35Z

STEP 2 - PostgreSQL upgrade

Hgibson at 18:09, 19 April 2016

2016-04-19T18:09:19Z

Hgibson: Created page with "==STEP 2 - PostgreSQL upgrade== Check the following before doing the PostgreSQL upgrade: *http://wiki.lib.sun.ac.za/index.php/SUNScholar/Prepare_Ubuntu/S06/Ubuntu-14.04#Step_6..."

2016-04-19T18:05:38Z

Created page with "==STEP 2 - PostgreSQL upgrade== Check the following before doing the PostgreSQL upgrade: *http://wiki.lib.sun.ac.za/index.php/SUNScholar/Prepare_Ubuntu/S06/Ubuntu-14.04#Step_6..."

New page

==STEP 2 - PostgreSQL upgrade==
Check the following before doing the PostgreSQL upgrade:
*http://wiki.lib.sun.ac.za/index.php/SUNScholar/Prepare_Ubuntu/S06/Ubuntu-14.04#Step_6.1:_Increase_the_kernel_shared_memory_for_PostgreSQL_server_client_connections
*Then restart PostgreSQL: <tt>sudo service postgresql restart</tt>
===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 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

← Older revision		Revision as of 09:15, 28 May 2016
Line 74:		Line 74:
	And then upgrade the 8.3 cluster to 8.4:		And then upgrade the 8.3 cluster to 8.4:
	pg_upgradecluster 8.3 main		pg_upgradecluster 8.3 main
		+	[[Category:System Administration]]

← Older revision		Revision as of 10:19, 4 May 2016
Line 25:		Line 25:

	pg_upgradecluster 9.3 main		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 12.04 LTS to 14.04 LTS===		===Upgrade 12.04 LTS to 14.04 LTS===

← Older revision		Revision as of 18:09, 19 April 2016
Line 1:		Line 1:
		+	<center>
		+	'''[[SUNScholar/Upgrading/Server Software\|Back to Upgrading Server]]'''
		+	</center>
		+
	==STEP 2 - PostgreSQL upgrade==		==STEP 2 - PostgreSQL upgrade==
	Check the following before doing the PostgreSQL upgrade:		Check the following before doing the PostgreSQL upgrade:

@@ Line 4: / Line 4: @@
 ==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.

@@ Line 14: / Line 14: @@
 ''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:
+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.3 (This will be done automatically with a system upgrade)
+   apt-get install postgresql-9.5 (This will be done automatically with a system upgrade)
-After the Ubuntu upgrade, then drop the default 9.3 cluster:
+After the Ubuntu upgrade, then drop the default 9.5 cluster:
-   pg_dropcluster 9.3 main --stop
+   pg_dropcluster 9.5 main --stop
-And then upgrade the 9.1 cluster to 9.3:
+And then upgrade the 9.3 cluster to 9.5:
-   pg_upgradecluster 9.1 main
+   pg_upgradecluster 9.3 main
 ===Upgrade 12.04 LTS to 14.04 LTS===

@@ Line 7: / Line 7: @@
 *http://wiki.lib.sun.ac.za/index.php/SUNScholar/Prepare_Ubuntu/S06/Ubuntu-14.04#Step_6.1:_Increase_the_kernel_shared_memory_for_PostgreSQL_server_client_connections
 *Then restart PostgreSQL: <tt>sudo service postgresql restart</tt>
 ===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.