2.1.1 Using an RPM Package to Upgrade the PEM Server

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

2 Upgrading a PEM Installation : 2.2 Upgrading the PEM Server : 2.1.1 Using an RPM Package to Upgrade the PEM Server

2.1.1 Using an RPM Package to Upgrade the PEM Server

If you installed your PEM server with an RPM package, you can use an RPM to upgrade your PEM server. Please note that if you used a graphical installer to install your existing PEM server, you must remove the existing server before using an RPM package to install PEM 7.5. For detailed information about using an RPM package to install PEM, please consult the PEM Installation Guide, available at:

https://www.enterprisedb.com/resources/product-documentation

To use an RPM package to upgrade an existing RPM installation, you must:

1.

Use your package manager to upgrade the installed version of the PEM server:

yum upgrade edb-pem edb-pem-server

2.

If used, set SE Linux to permissive mode:

setenforce 0

3.

Configure the upgraded server:

/usr/edb/pem/bin/configure-pem-server.sh

When invoking the configuration script, you can include command line options to specify configuration properties; the script will prompt you for values that you omit on the command line. The accepted options are:

Option

Description

-acp

Defines PEM Agent certificate path. The default is /root/.pem.

-ci

CIDR formatted network address range that agents will connect to the server from, to be added to the server's pg_hba.conf file. For example, 192.168.1.0/24. The default is 0.0.0.0/0.

-d

The data directory path for the PEM backing database.

-dbi

The directory for the database server installation. For example, /usr/edb/as10 for Advanced Server or /usr/pgsql-10 for PostgreSQL.

-ds

The unit file name of the PEM database server. For Advanced Server, the default file name is edb-as-10; for PostgreSQL, it is postgresql-10.

-ho

The host address of the PEM database server.

-p

The port number of the PEM database server.

-ps

The service name of the pemagent; the default value is pemagent.

-sp

The superuser password of the PEM database server. This value is required.

-su

The superuser name of the PEM database server.

-t

The installation type: Specify 1 if the configuration is for web services and backing database, 2 if you are configuring web services, or 3 if you are configuring the backing database. If you specify 3, please note that the database must reside on the local host.

If you do not provide configuration properties on the command line, you will be prompted for values by the script. To view script-related help, use the command:

/usr/edb/pem/bin/configure-pem-server.sh --help

After executing the PEM server configuration file, use your version-specific service control command to restart the httpd service.

For detailed information about using an RPM package to install or configure the PEM server, please see the PEM Installation Guide or the Advanced Server Installation Guide, available at:

http://www.enterprisedb.com/products-services-training/products/documentation/enterpriseedition

2 Upgrading a PEM Installation : 2.2 Upgrading the PEM Server : 2.1.1 Using an RPM Package to Upgrade the PEM Server

Option	Description
-acp	Defines PEM Agent certificate path. The default is /root/.pem.
-ci	CIDR formatted network address range that agents will connect to the server from, to be added to the server's pg_hba.conf file. For example, 192.168.1.0/24. The default is 0.0.0.0/0.
-d	The data directory path for the PEM backing database.
-dbi	The directory for the database server installation. For example, /usr/edb/as10 for Advanced Server or /usr/pgsql-10 for PostgreSQL.
-ds	The unit file name of the PEM database server. For Advanced Server, the default file name is edb-as-10; for PostgreSQL, it is postgresql-10.
-ho	The host address of the PEM database server.
-p	The port number of the PEM database server.
-ps	The service name of the pemagent; the default value is pemagent.
-sp	The superuser password of the PEM database server. This value is required.
-su	The superuser name of the PEM database server.
-t	The installation type: Specify 1 if the configuration is for web services and backing database, 2 if you are configuring web services, or 3 if you are configuring the backing database. If you specify 3, please note that the database must reside on the local host.