Accessing the web interface v8

After installing a PEM server and agent, you can configure PEM to start monitoring and managing PostgreSQL or EDB Postgres Advanced Server instances. The PEM server installer installs the PEM web interface. You can use the interface to review information about objects that reside on monitored servers or to review statistical information gathered by the PEM server.

After the server installation completes, you can open the PEM interface in your choice of browser by navigating to:

https://<ip_address_of_PEM_host>:8443/pem

ip_address_of_PEM_host specifies the IP address of the host of the PEM server.

Use the fields on the Postgres Enterprise Manager Login window to authenticate yourself with the PEM server:

  • Provide the name of a pem database user in the Username field. For the first user connecting, this is the name provided when installing the PEM server.

  • Provide the password associated with the user in the Password field.

After providing your credentials, select Login to connect to PEM.

The PEM web interface opens, displaying the Global Overview dashboard.

The Global Overview Dashboard

The Browser pane displays a tree that provides access to information about the database objects that reside on each server. The tree expands to display a hierarchical view of the servers and objects that the PEM server monitors.

Before you can use the PEM web interface to manage or monitor a database server, you must register that server with the PEM server. When you register a server, you describe the connection to the server, provide authentication information for the connection, and specify any management preferences (optionally binding an agent).

A server can be managed or unmanaged:

  • A managed server is bound to a PEM agent. The PEM agent monitors the server to which it's bound and performs tasks or reports statistics for display on the PEM dashboards. A managed server has access to extended PEM functionality such as custom alerting. When registering a server, you can also allow PEM to restart a managed server as required.
  • An unmanaged server isn't bound to a PEM agent. You can create database objects on an unmanaged server, but extended PEM functionality (such as custom alerting) isn't supported on an unmanaged server.

You must also ensure the pg_hba.conf file of the server that you're registering allows connections from the host of the PEM web interface.

To access online help for the PEM web interface, select Help from the menu bar. The online help content is also available from the EDB website.

The PEM menu bar

The PEM menu bar provides access to commands and features that you can use to manage your database servers and the objects that reside on those servers. If an option is disabled:

  • The database server to which you are currently connected might not support the selected feature.

  • The selected menu option might not apply to the current object.

  • The role that you used to connect to the server might not have enough privileges to change the selected object.

Context-sensitive menus across the top of the PEM web interface allow you to customize your environment and provide access to the enterprise management features of PEM.

The File menu

Use the File menu to access the following options.

OptionAction
PreferencesOpen the Preferences dialog box to customize your PEM client settings.
Lock LayoutOpen a submenu to select the level for locking the UI layout.
Server ConfigurationOpen the Server Configuration dialog box and update your PEM server configuration settings.
Reset LayoutIf a workspace panel is popped out by mistake or intentionally, you can reset it to the default using Reset Layout.

The Object menu

The Object menu is context sensitive. Use the Object menu to access the following options.

OptionAction
CreateAccess a menu that provides context-sensitive selections.
RefreshRefresh the currently selected object.
Delete/DropDelete the currently selected object from the server.
Connect ServerOpen the Connect to Server dialog box to establish a connection with a server.
CREATE ScriptOpen the Query tool to edit or view the selected script.
Disconnect ServerRefresh the currently selected object.
BARTAccess a menu that provides options for removing BART configuration, taking a BART backup, or revalidating the BART configuration.
Clear Saved PasswordIf you saved the database server password, clear the saved password. Enabled only after password is saved.
Clear SSH Tunnel PasswordIf you saved the ssh tunnel password, clear the saved password. Enabled only after password is saved.
Drop CascadeDelete the currently selected object and all dependent objects from the server.
HideHide the currently selected group. To view hidden groups, enable the Show hidden groups option in Preferences.
PropertiesReview or modify the currently selected object's properties.
Trigger(s)Disable or enable triggers for the currently selected table.
TruncateRemove all rows from a table (Truncate) or remove all rows from a table and its child tables (Truncate Cascade).
View DataAccess a menu that provides several options for viewing data.

The Management menu

Use the Management menu to access the following PEM features.

OptionAction
Audit ManagerOpen the Audit Manager and configure auditing on your monitored servers.
Auto DiscoveryOpen the Auto Discovery dialog box to configure a PEM agent to locate and bind monitored database servers.
Capacity ManagerOpen the Capacity Manager dialog box and analyze historical or project future resource usage.
Log ManagerOpen the Log Manager dialog box and configure log collection for a server.
Manage AlertsOpen the Manage Alerts tab and create or modify behavior for alerts.
Manage ChartsOpen the Manage Charts tab to create or modify PEM charts.
Manage DashboardsOpen the Manage Dashboards dialog box to VACUUM, ANALYZE, REINDEX, or CLUSTER.
Manage ProbesOpen the Manage Probes dialog box to VACUUM, ANALYZE, REINDEX, or CLUSTER.
Postgres ExpertOpen the Postgres Expert wizard and perform a static analysis of your servers and databases.
Postgres Log Analysis ExpertOpen the Postgres Log Analysis Expert dialog box to analyze log file contents for usage trends.
Scheduled TasksOpen the Scheduled Tasks tab and review tasks that are pending or recently completed.
Tuning WizardOpen the Tuning Wizard dialog box to generate a set of tuning recommendations for your server.
ReportsOpen the Reports dialog box to generate the system configuration report and core usage report for your server.

The Dashboards menu

Use the context-sensitive Dashboards menu to access dashboards.

OptionAction
AlertsOpen the Alerts dashboard for the selected node.
Audit LogOpen the Audit Log Analysis dashboard for the selected node.
BDR AdminOpen the BDR Admin dashboard for the selected node.
BDR Group MonitoringOpen the BDR Group Monitoring dashboard for the selected node.
BDR Node MonitoringOpen the BDR Node Monitoring dashboard for the selected node.
Database ServerOpen the Database Analysis dashboard for the selected node.
I/O AnalysisOpen the I/O Analysis dashboard for the selected node.
MemoryOpen the Memory Analysis dashboard for the selected node.
Object ActivityOpen the Object Activity Analysis dashboard for the selected node.
Operating SystemOpen the Operating System Analysis dashboard for the selected node.
Probe LogOpen the Probe Log Analysis dashboard for the selected node.
Server LogOpen the Server Log Analysis dashboard for the selected node.
Session ActivityOpen the Session Activity Analysis dashboard for the selected node.
StorageOpen the Storage Analysis dashboard for the selected node.
Streaming ReplicationOpen the Streaming Replication Analysis dashboard for the selected node.
System WaitOpen the System Wait Analysis dashboard for the selected node.

The Tools menu

Use the options on the Tools menu to access the following features.

OptionAction
Schema DiffOpen the Schema Diff dialog box to compare the schema objects between two database schemas.
Search objectsOpen the Search Objects dialog box to search the database objects in a database.
ServerAccess the various server-related tools such as Add Named Restore Point, Performance Diagnostics, Queue Server Startup, Queue Server Shutdown, Replace Cluster Primary, Switchover EFM Cluster, and SQL Profiler.
Query toolOpen the Query tool for the currently selected object.
Reload ConfigurationUpdate configuration files without restarting the server.
Pause replay of WALPause replay of the WAL log.
Resume replay of WALResume replay of the WAL log.
Import/ExportOpen the Import/Export Data dialog box to import or export data from a table.
MaintenanceOpen the Maintenance dialog box to VACUUM, ANALYZE, REINDEX, or CLUSTER.
BackupOpen the Backup dialog box to back up database objects.
Backup GlobalsOpen the Backup Globals dialog box to back up cluster objects.
Backup ServerOpen the Backup Server dialog box to back up a server.
RestoreOpen the Restore dialog box to restore database files from a backup.
Grant WizardOpen the Grant Wizard tool.
Schedule BackupOpen the Schedule Backup dialog box for BART backups.

The Help menu

Use the options on the Help menu to access the online help documents or to review information about the PEM installation.

OptionAction
Online HelpOpen documentation for Postgres Enterprise Manager.
REST API ReferenceOpen the REST API Reference.
EDB WebsiteOpen the EDB website in a browser window.
About Postgres Enterprise ManagerLocate versioning and user information for Postgres Enterprise Manager.

Controlling and customizing charts, graphs and tables

Use the icons in the upper-right corner of each graphic on a dashboard to control and customize the charts, graphs, and tables displayed in the PEM client for your current user session.

The following table gives the information about icons.

IconsInformation
icon6 View information about the chart, graph, or table.
icon1 Refresh the content of a chart, graph, or table.
icon3 Personalize the chart, graph, or table settings for the current user.
icon4 Download an image of the chart or graph.
icon5 View the legends that are used in the chart, graph, or table.
icon2 Expand the chart or graph to full-screen.

For more information about customizing the graphics displayed on the PEM dashboards, see the PEM client online help.