Other Resources
Postgres as a Service
Deploy a Managed Postgres Cluster in Minutes! Enterprise-ready and Oracle compatible.
Upgrading a PEM Installation on Windows host¶
To upgrade PEM component software on Windows hosts, simply invoke a newer version of the PEM component installers in the following order:
- Invoke the PEM agent installer on each monitored node except the PEM server node.
- Invoke the PEM server installer; this installer will upgrade both the PEM server and the PEM agent that resides on the PEM server node.
During an installation, the component installer will automatically detect an existing installation, and perform an upgrade. After upgrading the PEM agent and server, you should upgrade SQL Profiler; this step is platform-specific.
The following sections will walk you through the upgrade process on a Windows host, step-by-step.
Upgrading a PEM Agent on Windows host¶
To upgrade a system that is currently monitored by a PEM agent to a more-recent version of PEM agent, simply download and invoke a newer version of the platform-specific PEM agent installer on the system that the agent is monitoring.
You can invoke the installer by right-clicking on the downloaded installer’s icon, and selecting Run as Administrator
. The PEM Agent Setup Wizard
opens, welcoming you.
Read and accept the `License Agreement
before clicking Next
to continue.
The setup wizard will automatically detect an existing agent, and upgrade the installed version. Click Next
to continue.
When the Ready to Install
dialog informs you that the installation is about to begin, click Next
to continue.
The setup wizard displays progress bars to inform you of each component that is being installed.
The PEM Agent Setup Wizard
will inform you when the installation completes. Click Finish
to exit the wizard and close the window.
Note
If you have already configured or planning to configure any shell/batch script run by a Windows agent that is upgraded from any lower version to version 7.11, you must set the AllowBatchJobSteps
parameter as True
in the agent.cfg
file. By default pemagent will not execute any batch/shell script.
Upgrading the PEM Server on a Windows host¶
The PEM server installer facilitates upgrading directly between major versions of the PEM server (for example, you can upgrade directly from version 5.0 to version 7.5 without first upgrading to version 6.0).
You can invoke the installer by right-clicking on the downloaded installer’s icon, and selecting Run as Administrator
.
The PEM Server Setup Wizard
welcomes you, as shown in the image. Click Next
to continue to the License Agreement
.
The PEM server setup wizard
will prompt you to accept the License Agreement
. After reviewing the license agreement,
check the radio button next to I accept the agreement
, and click Next
to continue to the Existing installation dialog
.
The wizard will check the PEM server host for an existing PEM server installation; if the wizard locates an installation, it will perform an
upgrade. Click Next
to continue.
Before upgrading the PEM server, the wizard will confirm that the requirements of the new PEM server are present. If any supporting components are missing, or are a version that will not support the new PEM installation, the PEM installation wizard will inform you that it must upgrade the dependencies, and will invoke the required installers.
When the installation wizards complete the dependency upgrades, focus will return to the PEM server setup wizard.
The wizard then opens the Database Server Installation Details
dialog, prompting you for connection credentials for database superuser of the PEM backing database. Provide:
- The name of the database superuser in the
User
field. - The password associated with the database superuser in the
Password
field.
Click Next
to continue.
The pemAgent service account
dialog may prompt you for the password of the account under which the PEM agent service runs. If prompted, provide the password, and click Next
to continue.
The Ready to Install
dialog will inform you that the setup wizard is ready to perform the installation. Click Next
to start the installation.
During the installation, progress bars will keep you informed of the progress of the update.
After updating the PEM server (and the agent that resides on the same host as the PEM server) and configuring the webservice, the PEM setup wizard notifies you of the port on which the service is listening. Use this port number when connecting to the PEM Server with the PEM client.
Click OK
to close the Info
popup. The PEM server setup wizard informs you that the installation is complete.
If you have installed the PEM backend database server and PEM-HTTPD on different hosts, then you must run the PEM server installer twice – once on each host. Extract the language pack installer, and install it on the host of PEM-HTTPD before invoking the PEM installer. Include the following keywords when invoking the installer to extract the language pack:
--extract-languagepack <path>
Where <path>
specifies an existing path for extracting the language pack installer.
After upgrading the PEM server, you may wish to upgrade the backing database to a more recent version; for information about upgrading the backing database, see Upgrading the backing database.
Upgrading SQL Profiler on Windows host¶
If you are using SQL Profiler on a Windows host, Windows will lock any files that have been executed or loaded into memory. To release any locked files, you must stop the Postgres server before performing an upgrade.
On Windows, you can use the Services
dialog to control the service. To open the Services
dialog, navigate through the Control Panel
to the
System and Security menu
. Select Administrative Tools
, and then double-click the Services
icon. When the Services
dialog opens,
highlight the service name in the list, and use the option provided on the dialog to Stop
the service.
After stopping the Postgres Server:
Delete the existing SQL Profiler query set on each node by invoking the
uninstall-sql-profiler.sql
script.By default, the script resides in the
share\contrib
directory under your Advanced Server or PostgreSQL installation.Invoke the new SQL Profiler installer on each node you wish to profile.
Then, restart the Postgres Server, to resume profiling the node from a PEM client. After updating the PEM components, you are ready to update the backing database.