Registering a PEM agent v8
Before a PEM agent can be used, you must register it with a PEM server. PEM agents installed by the PEM server package are registered automatically during server configuration. For all other agents you must follow these instructions.
Note
After upgrading the PEM agent, you need to restart it. You don't need to register it again.
How to register PEM agents
On Linux and Windows hosts, the PEM agent package includes a command line utility called pemworker. You can use it to perform management tasks, including registering the PEM agent.
On Windows, the PEM agent graphical installer allows you to register the agent when installing it. This convenience option doesn't support all the possibilities provided by pemworker. If you don't want the installer to register the agent, clear the Register now checkbox. For more details, see the installation instructions.
Registering a PEM agent using the pemworker utility
The pemworker utility is installed automatically with the PEM agent. It's located in the /usr/edb/pem/agent/bin
directory on Linux and C:\Program Files\edb\pem\agent-x64\bin
on Windows.
To register an agent, invoke the utility and add the relevant options from the table as needed. Follow each option with a corresponding value.
Linux
Windows
Option | Description |
---|---|
--pem-server | The IP address of the PEM backend database server. This parameter is required. |
--pem-port | The port of the PEM backend database server. The default value is 5432 . |
--pem-user | The name of the database user having superuser privileges of the PEM backend database server. This parameter is required. |
--pem-agent-user | The agent user to connect the PEM server backend database server. |
--cert-path | The complete path to the directory where certificates are created. If you don't provide a path, certificates are created in ~/.pem on Linux and %APPDATA%/pem on Windows |
--config-dir | The directory path for the configuration file. The default is <pemworker path>/../etc . |
--display-name | A user-friendly name for the agent to display in the PEM browser tree. The default is the system hostname. |
--force-registration | Include the force_registration clause to register the agent with the arguments provided. This clause is useful if you're overriding an existing agent configuration. The default value is Yes . |
--group | The name of the group in which the agent is displayed. |
--team | The name of the database role on the PEM backend database server with access to the monitored database server. |
--owner | The name of the database user on the PEM backend database server who owns the agent. |
--allow_server_restart | Enable the allow-server_restart parameter to allow PEM to restart the monitored server. The default value is True . |
--allow-batch-probes | Enable the allow-batch-probes parameter to allow PEM to run batch probes on this agent. The default value is False . |
--batch-script-user | The operating system user to use for executing the batch/shell scripts. The default value is none. The scripts don't execute if you leave this parameter blank or the specified user doesn't exist. |
--enable-heartbeat-connection | Enable the enable-heartbeat-connection parameter to create a dedicated heartbeat connection between the PEM agent and server to update the active status. The default value is False . |
--enable-smtp | Enable the enable-smtp parameter to allow the PEM agent to send the email on behalf of the PEM server. The default value is False . |
--enable-snmp | Enable the enable-snmp parameter to allow the PEM agent to send the SNMP traps on behalf of the PEM server. The default value is False . |
Allowing the agent to restart the database server
If you use any feature of PEM that requires a database server restart by the PEM agent (such as Audit Manager, Log Manager, or the Tuning Wizard), then you must set the value of allow_server_restart
to true
in the agent.cfg
file or restart the server manually for changes to take effect.
Running shell/batch jobs
If you want to run shell/batch jobs using an agent, you must specify the user for the batch_script_user
parameter. We strongly recommend that you use a non-root user to run the scripts.
Using the root user might result in compromising the data security and operating system security.
Authenticating the pemworker utility
Before any changes are made on the PEM database, the connecting is authenticated with the PEM database server. When invoking the pemworker utility, you must provide the password associated with the PEM server administrative user role (postgres). You can specify the administrative password in three ways:
- Set the
PEM_SERVER_PASSWORD
environment variable. - Provide the password on the command line with the
PGPASSWORD
keyword. - Create an entry in the
.pgpass
file.
If you don't provide the password, a password authentication error occurs. After authentication succeeds, you're prompted for any other missing required information. When the registration is complete, the server confirms that the agent was successfully registered.
Unregistering a PEM agent
You can use the pemworker utility to unregister a PEM agent. To unregister an agent, invoke the pemworker utility as shown.
Linux
Windows
When invoking the pemworker utility, append command line options to the command string. Follow each option with a corresponding value.
Option | Description |
---|---|
--pem-user <username> | Specifies the name of the database user (member of pem_admin role) of the PEM backend database server. This parameter is required. |
--config-dir | Specifies the directory path for the configuration file. The default is "<pemworker path>/../etc" . |
Advanced usage
These are some advanced options for PEM agent registration.
Using a non-root user account to register a PEM agent on Linux
To use a non-root user account to register a PEM agent, you must first install the PEM agent as a root user. After installation, assume the identity of a non-root user, such as edb. Then:
Log in as edb. Create
pem
andlogs
directories and assign read, write, and execute permissions:Register the agent with PEM server:
Change the parameters of the
agent.cfg
file:Where
<id>
is the assigned PEM agent ID.Create a
tmp
directory, set the environment variable, and start the agent:Your PEM agent is now registered and started with the edb user. If your machine restarts, then this agent doesn't restart automatically. You need to start it manually using the previous command.
Optionally, you can create the service for this PEM agent as the root user to start this agent at machine restart as follows:
a. Update the values for the configuration file path and the user in the
pemagent
service file as superuser:b. Stop the running agent process, and then restart the agent service:
Check the agent status on the PEM dashboard.
Note
Any probes and jobs that require root permission or access to a file owned by another user (for example, enterprisedb) fail.