Article ID: 115912, created on Apr 5, 2013, last review on May 11, 2014

  • Applies to:
  • Operations Automation 5.4

Installation

PostgreSQL server 9.0.13 must be installed on nodes that host the following:
- POA system database
- Configuration databases of shared NG clusters
- Shared PostgreSQL9 databases
- PACI Instance Manager Database

Attention: Do not update PostgreSQL packages on POA system servers using the yum utility or any other Linux package management tool; download the packages linked below this article and install them using the rpm utility.

Note:

PostgreSQL 9.0.13 is much more sensitive than PostgreSQL 9.0.4 to the "hostssl" directive in the pg_hba.conf file. This directive controls access to the DB via SSL. When this directive is in use, complementary configurations must be made in the postgresql.conf file and server certificates must be present (http://www.postgresql.org/docs/9.0/static/auth-pg-hba-conf.html, http://www.postgresql.org/docs/9.0/static/ssl-tcp.html). If these conditions are not met, then PostgreSQL will refuse to start.

If SSL connections to the DB are not used then "hostssl" directives must be disabled in the pg_hba.conf file. Otherwise make sure that all necessary complementary configurations are made as well.

Note:

With 8.x versions, PostgreSQL is not affected by the vulnerability. There is no need to update PostgreSQL 8.x on any hosts.

Installation on POA System Database Node


1) Log in to the POA system database node.

2) Make a backup of the POA system database.

3) Download the following RPM packages:
- postgresql90-9.0.13-2.parallels
- postgresql90-libs-9.0.13-2.parallels
- postgresql90-server-9.0.13-2.parallels

Refer to the Packages section for the exact links of these RPMs, which depend on your OS/architecture.

4) Log in to the POA MN and stop POA services:
service pem stop

5) Return to the POA database node and stop PostgreSQL services:
service postgresql-9.0 stop

6) Update PostgreSQL RPMs:
rpm -Uhv --nodeps --replacefiles postgresql90-9.0.13-2.parallels*.rpm postgresql90-libs-9.0.13-2.parallels*.rpm postgresql90-server-9.0.13-2.parallels*.rpm

7) Start PostgreSQL services:
service postgresql-9.0 start

8) Log in to the POA MN and start POA services:
service pem start

Installation on Node with Configuration Database of Shared NG Cluster


1) Log in to the node that hosts the configuration database of the shared NG cluster.

2) Check if PostgreSQL 9 is installed on the node:
rpm -qa | grep postgresql90

If there are no PostgreSQL 9 packages reported, then an update of PostgreSQL on this node is not required.

3) Make a backup of all databases whose names start with web_cluster_db.

4) Download the following RPMs:
- postgresql90-9.0.13-2.parallels
- postgresql90-libs-9.0.13-2.parallels
- postgresql90-server-9.0.13-2.parallels

Refer to the Packages section for the exact links of these RPMs, which depend on your OS/architecture.

5) Stop PostgreSQL services on this node:
service postgresql-9.0 stop

6) Update PostgreSQL RPMs:
rpm -Uhv --replacefiles postgresql90-9.0.13-2.parallels*.rpm postgresql90-libs-9.0.13-2.parallels*.rpm postgresql90-server-9.0.13-2.parallels*.rpm

7) Start PostgreSQL services:
service postgresql-9.0 start

Installation on Node with Shared PostgreSQL 9 Database


1) Log in to the node that hosts the shared PostgreSQL v. 9 database.

2) Download the following RPMs:
- postgresql90-9.0.13-2.parallels
- postgresql90-libs-9.0.13-2.parallels
- postgresql90-server-9.0.13-2.parallels

Refer to the Packages section for the exact links of these RPMs, which depend on your OS/architecture.

3) Stop PostgreSQL services on this node:
service postgresql-9.0 stop

4) Update PostgreSQL RPMs:
rpm -Uhv --replacefiles postgresql90-9.0.13-2.parallels*.rpm postgresql90-libs-9.0.13-2.parallels*.rpm postgresql90-server-9.0.13-2.parallels*.rpm

5) Start PostgreSQL services:
service postgresql-9.0 start

Installation on Node with PACI Instance Manager Database


1) Log in to the node that hosts PACI Instance Manager Database.

2) Make a backup of instance manager database (refer to properties of paci_im_db package for the name of this database).

3) Download the following RPMs:
- postgresql90-9.0.13-2.parallels
- postgresql90-libs-9.0.13-2.parallels
- postgresql90-server-9.0.13-2.parallels

Refer to the Packages section for the exact links of these RPMs, which depend on your OS/architecture.

4) Stop PostgreSQL services on this node:
service postgresql-9.0 stop

5) Update PostgreSQL RPMs:
rpm -Uhv --replacefiles postgresql90-9.0.13-2.parallels*.rpm postgresql90-libs-9.0.13-2.parallels*.rpm postgresql90-server-9.0.13-2.parallels*.rpm

6) Start PostgreSQL services:
service postgresql-9.0 start

Packages

RHES 4:

 - 32-bit:
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/rhes4/postgresql90-9.0.13-2.parallels.i386.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/rhes4/postgresql90-libs-9.0.13-2.parallels.i386.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/rhes4/postgresql90-server-9.0.13-2.parallels.i386.rpm
- 64-bit:
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/rhes4/postgresql90-9.0.13-2.parallels.x86_64.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/rhes4/postgresql90-libs-9.0.13-2.parallels.x86_64.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/rhes4/postgresql90-server-9.0.13-2.parallels.x86_64.rpm

RHEL 5:

- 32-bit:
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el5/postgresql90-9.0.13-2.parallels.i386.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el5/postgresql90-libs-9.0.13-2.parallels.i386.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el5/postgresql90-server-9.0.13-2.parallels.i386.rpm
- 64-bit:
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el5/postgresql90-9.0.13-2.parallels.x86_64.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el5/postgresql90-libs-9.0.13-2.parallels.x86_64.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el5/postgresql90-server-9.0.13-2.parallels.x86_64.rpm

RHEL 6:
- 32-bit:
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el6/postgresql90-9.0.13-2.parallels.i386.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el6/postgresql90-libs-9.0.13-2.parallels.i386.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el6/postgresql90-server-9.0.13-2.parallels.i386.rpm
- 64-bit:
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el6/postgresql90-9.0.13-2.parallels.x86_64.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el6/postgresql90-libs-9.0.13-2.parallels.x86_64.rpm
   http://download.pa.parallels.com/poa/5.4/hotfixes/postgresql90-9.0.13/el6/postgresql90-server-9.0.13-2.parallels.x86_64.rpm

ac82ce33439a9c1feec4ff4f2f638899 caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF