Accessing the web interface v9
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
pemdatabase 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 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.
Accessing in-app help for UI details
The in-app help provides comprehensive details about the PEM web interface, including the menu items, charts and graphs on the dashboards, and the options on the dialog boxes. The in-app help also includes instructions for creating database objects.
- To access the landing page for the help, select Help > Online help.
- To access context-sensitive help for a dialog box, select ?.
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.
| Option | Action |
|---|---|
| Preferences | Open the Preferences dialog box to customize your PEM client settings. |
| Lock Layout | Open a submenu to select the level for locking the UI layout. |
| Server Configuration | Open the Server Configuration dialog box and update your PEM server configuration settings. |
| Reset Layout | If 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.
| Option | Action |
|---|---|
| Create | Access a menu that provides context-sensitive selections. |
| Refresh | Refresh the currently selected object. |
| Delete/Drop | Delete the currently selected object from the server. |
| Connect Server | Open the Connect to Server dialog box to establish a connection with a server. |
| CREATE Script | Open the Query tool to edit or view the selected script. |
| Disconnect Server | Refresh the currently selected object. |
| BART | Access a menu that provides options for removing BART configuration, taking a BART backup, or revalidating the BART configuration. |
| Clear Saved Password | If you saved the database server password, clear the saved password. Enabled only after password is saved. |
| Clear SSH Tunnel Password | If you saved the ssh tunnel password, clear the saved password. Enabled only after password is saved. |
| Drop Cascade | Delete the currently selected object and all dependent objects from the server. |
| Hide | Hide the currently selected group. To view hidden groups, enable the Show hidden groups option in Preferences. |
| Properties | Review or modify the currently selected object's properties. |
| Trigger(s) | Disable or enable triggers for the currently selected table. |
| Truncate | Remove all rows from a table (Truncate) or remove all rows from a table and its child tables (Truncate Cascade). |
| View Data | Access a menu that provides several options for viewing data. |
| Remove Server | Click to remove the selected server from the browser tree. |
| Delete/Drop | Click to delete the currently selected object from the server. |
| Connect Database | Click to connect to selected database. |
| Count Rows | Click to count the number of rows of the selected table. |
| Reset Statistics | Click to reset the statistics of the selected table. |
| Scripts | Click to CREATE, DELETE, INSERT, SELECT and UPDATE script for the selected table. |
The Management menu
Use the Management menu to access the following PEM features.
| Option | Action |
|---|---|
| Audit Manager | Open the Audit Manager and configure auditing on your monitored servers. |
| Auto Discovery | Open the Auto Discovery dialog box to configure a PEM agent to locate and bind monitored database servers. |
| Capacity Manager | Open the Capacity Manager dialog box and analyze historical or project future resource usage. |
| Log Manager | Open the Log Manager dialog box and configure log collection for a server. |
| Manage Alerts | Open the Manage Alerts tab and create or modify behavior for alerts. |
| Manage Charts | Open the Manage Charts tab to create or modify PEM charts. |
| Manage Dashboards | Open the Manage Dashboards dialog box to VACUUM, ANALYZE, REINDEX, or CLUSTER. |
| Manage Probes | Open the Manage Probes dialog box to VACUUM, ANALYZE, REINDEX, or CLUSTER. |
| Postgres Expert | Open the Postgres Expert wizard and perform a static analysis of your servers and databases. |
| Postgres Log Analysis Expert | Open the Postgres Log Analysis Expert dialog box to analyze log file contents for usage trends. |
| Scheduled Tasks | Open the Scheduled Tasks tab and review tasks that are pending or recently completed. |
| Tuning Wizard | Open the Tuning Wizard dialog box to generate a set of tuning recommendations for your server. |
| Reports | Open the Reports dialog box to generate the system configuration report and core usage report for your server. |
| Schedule Alert Blackout... | Open the Schedule Alert Blackout dialog box and schedule the alerts blackout for your servers and agents. |
The Dashboards menu
Use the context-sensitive Dashboards menu to access dashboards.
| Option | Action |
|---|---|
| Alerts | Open the Alerts dashboard for the selected node. |
| Audit Log | Open the Audit Log Analysis dashboard for the selected node. |
| PGD Admin | Open the PGD Admin dashboard for the selected node. |
| PGD Group Monitoring | Open the PGD Group Monitoring dashboard for the selected node. |
| PGD Node Monitoring | Open the PGD Node Monitoring dashboard for the selected node. |
| Database Server | Open the Database Analysis dashboard for the selected node. |
| I/O Analysis | Open the I/O Analysis dashboard for the selected node. |
| Memory | Open the Memory Analysis dashboard for the selected node. |
| Object Activity | Open the Object Activity Analysis dashboard for the selected node. |
| Operating System | Open the Operating System Analysis dashboard for the selected node. |
| Probe Log | Open the Probe Log Analysis dashboard for the selected node. |
| Server Log | Open the Server Log Analysis dashboard for the selected node. |
| Session Activity | Open the Session Activity Analysis dashboard for the selected node. |
| Storage | Open the Storage Analysis dashboard for the selected node. |
| Streaming Replication | Open the Streaming Replication Analysis dashboard for the selected node. |
| System Wait | Open the System Wait Analysis dashboard for the selected node. |
| Session Waits | Open the Session Waits Analysis Dasbhoard for the selected node. |
| Custom Dashboards | Open the Custom Dashboards that list the custom dashboards configured by the user. |
The Tools menu
Use the options on the Tools menu to access the following features.
| Option | Action |
|---|---|
| Schema Diff | Open the Schema Diff dialog box to compare the schema objects between two database schemas. |
| Search objects | Open the Search Objects dialog box to search the database objects in a database. |
| Server | Access 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 tool | Open the Query tool for the currently selected object. |
| Reload Configuration | Update configuration files without restarting the server. |
| Pause replay of WAL | Pause replay of the WAL log. |
| Resume replay of WAL | Resume replay of the WAL log. |
| Import/Export | Open the Import/Export Data dialog box to import or export data from a table. |
| Maintenance | Open the Maintenance dialog box to VACUUM, ANALYZE, REINDEX, or CLUSTER. |
| Backup | Open the Backup dialog box to back up database objects. |
| Backup Globals | Open the Backup Globals dialog box to back up cluster objects. |
| Backup Server | Open the Backup Server dialog box to back up a server. |
| Restore | Open the Restore dialog box to restore database files from a backup. |
| Grant Wizard | Open the Grant Wizard tool. |
| Schedule Backup | Open the Schedule Backup dialog box for BART backups. |
| New ERD Porject(Beta) | Open the ERD Tool and start designing your database. |
| Storage Manager | Open the Storage manager to upload, delete or download the backup files. |
The Help menu
Use the options on the Help menu to access the online help documents or to review information about the PEM installation.
| Option | Action |
|---|---|
| Quick Search | Type your keywords in the Quick Search field. Typing atleast three characters will display all the matching possibilities under Menu items and the relevant documents under Help articles. Click on the options under Menu items to perform action of particular functionality or object. Click on any of the Help articles to open the help of that topic with highlighted text in a separate window. Note:- If any of the option under Menu items is disabled, then it will provide information via info icon. |
| Online Help | Open in-app documentation for Postgres Enterprise Manager. |
| REST API Reference | Open the REST API Reference. |
| EDB Website | Open the EDB website in a browser window. |
| About Postgres Enterprise Manager | Locate 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.
| Icons | Information |
|---|---|
| View information about the chart, graph, or table. |
| Refresh the content of a chart, graph, or table. |
| Personalize the chart, graph, or table settings for the current user. |
| Download an image of the chart or graph. |
|
| View the legends that are used in the chart, graph, or table. |
| 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.