Administering

• Changing the default port
  • For RHEL
  • For Debian and Ubuntu
• Registering a Postgres server
  • What does registering a Postgres server do?
  • Using the pemworker utility to register a server
    • Examples
  • Registering a server with automatic server discovery
  • Manually registering a database server
  • Verifying the connection and binding
• Registering a PEM agent
  • How to register PEM agents
  • Registering a PEM agent using the pemworker utility
    • Linux
    • Windows
    • Authenticating the pemworker utility
  • Unregistering a PEM agent
    • Linux
    • Windows
  • Advanced usage
    • Setting the agent ID
    • Overriding default configurations - examples
• Managing a PEM server
  • Starting and stopping the PEM server and agents
  • Controlling the PEM server or PEM agent on Linux
  • Controlling the PEM server or PEM agent on Windows
  • Controlling the HTTPD server
  • Managing PEM authentication
  • Editing the PEM server configuration
  • Managing security
    • Login roles
    • Group roles
    • Using PEM predefined roles to manage access to PEM functionality
    • Using a team role
    • Object permissions
  • Server configuration
  • Server configuration parameters - reference
• Managing Postgres servers
  • Starting and stopping monitored database servers
  • Modifying the pg_hba.conf file
  • Creating and maintaining databases and objects
  • Template Linux service script
• Managing a PEM agent
  • Managing job notifications
    • Configuring job notifications at job level
    • Configuring job notifications at agent level
    • Configuring job notifications at server level
  • Managing scheduled jobs
    • Provide general information about the job
    • Define the job steps
    • Define the job schedule
    • Configure the email notifications
  • Modifying agent configuration
    • Contents of the configuration file
    • Contents of the registry
    • About alert threads
  • Reviewing or modifying agent properties
  • Setting agent privileges
    • Root user versus non-root user
    • Functionality affected by limiting operating system privileges
    • Functionality affected by limiting database privileges
    • Error handling
• Managing SSL certificates
  • Web-server certificates
  • PEM backend database server and agent connection certificates
    • How PEM self-signed SSL certificates work
    • Certificate and key files generation
    • PEM self-signed SSL certificate renewal
  • Generate a common agent certificate and key pair
  • Use certificates and keys signed by trusted CA
    • Replace the self-signed server SSL certificates with the certificates signed by the trusted CA
    • Replace the self-signed agent SSL certificates with the certificates signed by the trusted CA
  • Testing certificates
    • Validate a certificate against the root certificate
    • Make a test connection to the PEM backend database
• Managing configuration settings
• Troubleshooting agent issues
  • Restoring a deleted PEM agent
  • Updating configuration file path (agent status displaying as unknown)
  • Using the command line to delete a PEM agent with down or unknown status