Request a Demo
Part V. Using PPEM
Prev UpPostgres Pro Enterprise Manager 2.9 DocumentationHome Next

Part V. Using PPEM

Important

Read Chapter 9 before you begin.

Table of Contents

36. Logging in to the Web Application
37. Web Application Interface
38. System Configuration
38.1. Viewing PPEM Summary Information
38.2. Configuring PPEM Repository Database
38.3. Agents
38.4. Tags
39. User Management
39.1. Users
39.2. User Account
39.3. User Groups
39.4. User Roles and Privileges
40. Instances
40.1. Creating an Instance
40.2. Viewing Instances
40.3. Restarting an Instance
40.4. Checking the Consistency of an Instance Data Directory
40.5. Stopping and Starting an Instance
40.6. Creating a Backup
40.7. Applying and Removing a Configuration Preset From an Instance
40.8. Editing an Instance
40.9. Selecting a Repository Instance
40.10. Configuring Metrics and Log Collection for an Instance
40.11. Deleting an Instance
41. Clusters
41.1. Creating a Cluster
41.2. Viewing Clusters
41.3. Editing a Cluster
41.4. Deleting a Cluster
41.5. Managing Nodes
41.6. Viewing Cluster Events
41.7. Migration of BiHA Clusters with Minimal Downtime
41.8. Configuring Metrics and Log Collection for Cluster Nodes
42. Configuration Presets
42.1. Creating a Configuration Preset
42.2. Viewing Configuration Presets
42.3. Applying a Configuration Preset
42.4. Editing a Configuration Preset
42.5. Deleting a Configuration Preset
43. Tablespaces
43.1. Creating a Tablespace
43.2. Viewing Tablespaces
43.3. Renaming a Tablespace
43.4. Deleting a Tablespace
44. Databases
44.1. Creating a Database
44.2. Viewing Databases
44.3. Running the psql Terminal
44.4. Collecting the Planner Statistics for a Database
44.5. Editing a Statistics Collecting Schedule for a Database
44.6. Reindexing a Database
44.7. Editing a Database Reindexing Schedule
44.8. Vacuuming a Database
44.9. Editing a Database Vacuuming Schedule
44.10. Renaming a Database
44.11. Deleting a Database
45. Schemas
45.1. Creating a Schema
45.2. Viewing Schemas
45.3. Editing a Schema
45.4. Deleting a Schema
46. Tables
46.1. Creating a Table
46.2. Viewing Tables
46.3. Collecting the Planner Statistics for a Table
46.4. Editing a Statistics Collecting Schedule for a Table
46.5. Reindexing a Table
46.6. Editing a Table Reindexing Schedule
46.7. Vacuuming a Table
46.8. Editing a Table Vacuuming Schedule
46.9. Viewing Table Constraints
46.10. Viewing Table Storage Layers
46.11. Editing a Table
46.12. Viewing Table Columns
46.13. Editing a Table Column
46.14. Deleting a Table Column
46.15. Deleting a Table
46.16. Table Storage Parameters
47. Indexes
47.1. Creating an Index
47.2. Viewing Indexes
47.3. Reindexing an Index
47.4. Editing an Index
47.5. Deleting an Index
48. Functions
48.1. Creating a Function
48.2. Viewing Functions
48.3. Editing a Function
48.4. Deleting a Function
49. Sequences
49.1. Creating a Sequence
49.2. Viewing Sequences
49.3. Editing a Sequence
49.4. Deleting a Sequence
50. Control Center
51. Metrics
51.1. Viewing Main Metrics
51.2. Creating an SQL Metric
51.3. Viewing SQL Metrics
51.4. Editing an SQL Metric
51.5. Deleting an SQL Metric
52. Alerts
52.1. Pre-Configuring Alerts
52.2. Creating an Alert
52.3. Viewing Alerts
52.4. Viewing Detailed Alert Information
52.5. Disabling and Enabling Alerts
52.6. Editing an Alert
52.7. Editing Alert Recipients
52.8. Clearing Alert History
52.9. Deleting an Alert
53. Activity
53.1. User Sessions
53.2. Wait Event Statistics
53.3. Vacuum Processes
53.4. Statistics Collection Processes
53.5. Clustering Processes
53.6. Reindexing or Index Creation Processes
53.7. Base Backup Processes
53.8. Copying Processes
54. Backend Diagnostics
54.1. Configuring Backend Diagnostics
54.2. Downloading a Diagnostic File
54.3. Deleting a Diagnostic File
55. CPU Usage Reports
55.1. Viewing a CPU Usage Report
55.2. Viewing a Detailed Hourly CPU Usage Report
55.3. Configuring the Retention Period for CPU Usage Reports
55.4. Downloading a CPU Usage Report
56. SQL Statistics
57. Active Session History
57.1. Managing Active Session Profiling
57.2. Viewing Active Session History
58. Repository Maintenance
58.1. Creating a Housekeeping Rule
58.2. Viewing the Repository Summary
58.3. Viewing Housekeeping Rules
58.4. Viewing Detailed Housekeeping Rule Information
58.5. Running a Housekeeping Rule
58.6. Truncating Tables Manually
58.7. Editing a Housekeeping Rule
58.8. Deleting a Housekeeping Rule
59. Instance Parameters
59.1. Viewing Instance Parameters
59.2. Editing Instance Parameters
60. Cluster Parameters
60.1. Viewing Cluster Parameters
60.2. Editing Cluster Parameters
61. Extensions
61.1. Installing Extensions
61.2. Viewing Extensions
61.3. Editing an Extension
61.4. Deleting an Extension
62. Profiler
62.1. Profiler Servers
62.2. Snapshots
62.3. Viewing Profiler Graphs
62.4. Snapshot Schedules
62.5. Reports
63. Authentication
63.1. Viewing Authentication Rules
63.2. Editing Authentication Rules
64. Instance Roles
64.1. Creating an Instance Role
64.2. Viewing Instance Roles
64.3. Editing an Instance Role
64.4. Deleting an Instance Role
65. Message Log
66. Task Console
66.1. Viewing Tasks
66.2. Managing Schedules
66.3. Managing Mass Instance Operations
67. Backup
67.1. Dashboard
67.2. Storages
67.3. Instance Binds
67.4. Backups
67.5. Backup Schedules
67.6. Configuring Backup Storage Parameters
68. Event Log
68.1. Pre-Configuring Logging of Audit Events
68.2. Viewing Event Log
68.3. Viewing Detailed Event Information
68.4. Downloading Event Log
68.5. Clearing Event Log
69. Query Plan Visualization
69.1. Creating a Query Plan
69.2. Visualizing a Query Plan
69.3. Editing a Query Plan
69.4. Sharing a Query Plan With Other Users
69.5. Deleting a Query Plan
70. Adaptive Query Optimization (AQO)
70.1. Installing aqo
70.2. Disabling and Enabling aqo
70.3. Managing aqo Databases
70.4. Configuring aqo Parameters
70.5. Cleaning aqo Storage
70.6. Viewing aqo Views
70.7. Uninstalling aqo
71. Interacting with Ask Postgres
71.1. Configuring the Chat
71.2. Using the Chat
Prev Up Next
Chapter 35. Configuration Behind a Reverse Proxy Home Chapter 36. Logging in to the Web Application
epub pdf