Table of Contents Previous Next


4 Managing a Monitored Server : 4.3 Using the pemworker Utility to Register a Server
4.3 Using the pemworker Utility to Register a Server
You can use the pemworker utility to register a server for monitoring by the PEM server or to unregister a database server. During registration, the pemworker utility will bind the new server to the agent that resides on the system from which you invoked the registration command. To register a server:
pemworker --register-server
on a Windows host, use the command:
pemworker.exe REGISTER-SERVICE
Append command line options to the command string when invoking the pemworker utility. Each option should be followed by a corresponding value:
Option
Description
-–pem-user
Specifies the name of the PEM administrative user. Required.
-–server-addr
Specifies the IP address of the server host, or the fully qualified domain name. On Unix based systems, the address field may be left blank to use the default PostgreSQL Unix Domain Socket on the local machine, or may be set to an alternate path containing a PostgreSQL socket. If you enter a path, the path must begin with a /. Required.
-–server-port
Specifies the port number of the host. Required.
-–server-database
Specifies the name of the database to which the server will connect. Required.
--server-user
Specify the name of the user that will be used by the agent when monitoring the server. Required.
--server-service-name
Specifies the name of the database service that controls operations on the server that is being registered (STOP, START, RESTART, etc.). Optional.
--remote-monitoring
Include the --remote-monitoring clause and a value of false (the default) to indicate that the server is installed on the same machine as the PEM agent. When remote monitoring is enabled (true), agent level statistics for the monitored server will not be available for custom charts and dashboards, and the remote server will not be accessible by some PEM utilities (such as Audit Manager, Capacity Manager, Log Manager, Postgres Expert and Tuning Wizard). Required.
-–efm-cluster-name
Specifies the name of the Failover Manager cluster that monitors the server (if applicable). Optional.
-–efm-install-path
Specifies the complete path to the installation directory of Failover Manager (if applicable). Optional.
-–asb-host-name
Specifies the name of the host to which the agent is connecting.
-–asb-host-port
Specifies the port number that the agent will use when connecting to the database.
-–asb-host-db
Specifies the name of the database to which the agent will connect.
-–asb-host-user
Specifies the database user name that the agent will supply when authenticating with the database.
-–asb-ssl-mode
Specifies the type of SSL authentication that will be used for connections. Supported values include: prefer, require, disable, verify-CA, verify-full.
-–group
Specifies the name of the group in which the server will be displayed.
-–team
Specifies the name of the group role that will be allowed to access the server.
-–owner
Specifies the name of the role that will own the monitored server.
When registering a database server, you must provide the password associated with the administrative user on the new server. Use the PEM_NEW_SERVER_PASSWORD environment variable to provide the associated password.
Before any changes are made on the PEM database, the connecting agent is authenticated with the PEM database server. When invoking the pemworker utility, you must provide the password associated with the PEM server administrative user. There are three ways to specify the administrative password; you can:
•
set the PEM_MONITORED_SERVER_PASSWORD environment variable.
•
provide the password on the command line with the PGPASSWORD keyword.
•
create an entry in the .pgpass file.
Failure to provide the password will result in a password authentication error. The PEM server will acknowledge that the server has been registered properly.
4 Managing a Monitored Server : 4.3 Using the pemworker Utility to Register a Server

Table of Contents Previous Next