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 may not support the selected feature.
  • The selected menu option may not be valid for the current object (by design).
  • The role that you have used to connect to the server may have insufficient privileges to change the selected object.

The File Menu

PEM file menu

Use the File menu to access the following options:

Option Action
Preferences Click to open the Preferences dialog to customize your PEM client settings.
Reset Layout If you have modified the workspace, click to restore the default layout.

The Object Menu

PEM object menu

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

Option Action
Connect Server… Click to open the Connect to Server dialog to establish a connection with a server.
Create Click Create to access a context menu that provides context-sensitive selections. Your selection opens a Create dialog for creating a new object.
Delete/Drop Click to delete the currently selected object from the server.
Disconnect Server… Click to refresh the currently selected object.
Drop Cascade Click to delete the currently selected object and all dependent objects from the server.
Hide… Click to hide the currently selected group.
Properties… Click to review or modify the currently selected object’s properties.
Refresh… Click to refresh the currently selected object.
Scripts Click to open the Query tool to edit or view the selected script.
Trigger(s) Click to Disable or Enable trigger(s) for the currently selected table.
Truncate Click to remove all rows from a table (Truncate) or to remove all rows from a table and its child tables (Truncate Cascade).
View Data Click to access a context menu that provides several options for viewing data (see below).

The Management Menu

PEM management menu

Use the Management menu to access the following PEM features:

Option PEM Feature Information
Audit Manager… Click to open the Audit Manager and configure auditing on your monitored servers.
Auto Discovery… Click to open the Auto Discovery dialog to instruct a PEM agent to locate and bind monitored database servers.
Capacity Manager… Click to open the Capacity Manager dialog and analyze historical or project future resource usage.
Log Manager… Click to open the Log Manager dialog and configure log collection for a server.
Manage Alerts… Click to access the Manage Alerts tab and create or modify alerting behavior.
Manage Charts… Click to open the Manage Charts tab to create or modify PEM charts.
Manage Dashboards… Click to open the Manage Dashboards dialog to VACUUM, ANALYZE, REINDEX, or CLUSTER.
Manage Probes… Click to open the Manage Probes dialog to VACUUM, ANALYZE, REINDEX, or CLUSTER.
Package Deployment… Click to open the Package Deployment wizard and install or update packages.
Postgres Expert… Click to open the Postgres Expert wizard and perform a static analysis of your servers and databases.
Postgres Log Analysis Expert… Click to access the Postgres Log Analysis Expert dialog analyze log file contents for usage trends.
Queue Server Startup… Click to instruct the PEM server to start the currently selected server.
Queue Server Shutdown Click to instruct the PEM server to shut down the currently selected server.
Replace Cluster Master Click to replace the current master node of your replication scenario.
Scheduled Tasks Click to open the Scheduled Tasks tab and review tasks that are pending or recently completed.
Server Configuration… Click to open the Server Configuration dialog and update your PEM server configuration settings.
SQL Profiler… Click to open the SQL Profiler dialog to capture statistical information about SQL query performance.
Streaming Replication… Click to access the Streaming Replication dialog configure a streaming replication scenario.
Tuning Wizard… Click to open the Tuning Wizard dialog to generate a set of tuning recommendations for your server.

The Dashboards Menu

PEM dashboard menu

The Dashboards menu is context-sensitive; use the Dashboards menu to access the following options:

Option Action
Alerts Dashboard Click to open the Alerts Dashboard for the selected node.
Audit Log Analysis Click to open the Audit Log Analysis Dashboard for the selected node.
Database Analysis Click to open the Database Analysis Dashboard for the selected node.
I/O Analysis Click to open the I/O Analysis Dashboard for the selected node.
Memory Analysis Click to open the Memory Analysis Dashboard for the selected node.
Object Activity Analysis Click to open the Object Activity Analysis Dashboard for the selected node.
Operating System Analysis Click to open the Operating System Analysis Dashboard for the selected node.
Probe Log Analysis Click to open the Probe Log Analysis Dashboard for the selected node.
Server Analysis Click to open the Server Analysis Dashboard for the selected node.
Server Log Analysis Click to open the Server Log Analysis Dashboard for the selected node.
Session Activity Analysis Click to open the Session Activity Analysis Dashboard for the selected node.
Storage Analysis Click to open the Storage Analysis Dashboard for the selected node.
Streaming Replication Analysis Click to open the Streaming Replication Analysis Dashboard for the selected node.
System Wait Analysis Click to open the System Wait Analysis Dashboard for the selected node.

The Tools Menu

PEM tools menu

Use the Tools menu to access the following options:

Option Action
Add named restore point Click to open the Add named restore point… dialog to take a point-in-time snapshot of the current server state.
Backup… Click to open the Backup… dialog to backup database objects.
Backup Globals… Click to open the Backup Globals… dialog to backup cluster objects.
Backup Server… Click to open the Backup Server… dialog to backup a server.
Grant Wizard… Click to access the Grant Wizard tool.
Import/Export… Click to open the Import/Export data… dialog to import or export data from a table.
Maintenance… Click to open the Maintenance… dialog to VACUUM, ANALYZE, REINDEX, or CLUSTER.
Pause replay of WAL Click to pause the replay of the WAL log.
Query tool Click to open the Query tool for the currently selected object.
Reload Configuration… Click to update configuration files without restarting the server.
Restore… Click to access the Restore dialog to restore database files from a backup.
Resume replay of WAL Click to resume the replay of the WAL log.

The Help Menu

PEM help menu

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

Option Action
About Postgres Enterprise Manager Click to locate versioning and user information for Postgres Enterprise Manager.
Online Help Click to open documentation for Postres Enterprise Manager.
pgAdmin Website Click to open the pgAdmin.org website in a browser window.
PostgreSQL Website Click to access the PostgreSQL core documentation hosted at the PostgreSQL site.