Management Basics¶
PEM provides a graphical interface that you can use to simplify management of your Postgres servers and the objects that reside on them.
The Grant Wizard simplifies the task of privilege management; to open the Grant Wizard, highlight the name of a server, database, or schema in the PEM client tree control, and select Grant Wizard... from the Tools menu.
PEM provides an easy to use environment in which to manage restore points, import/export tasks, and organize vacuum/analyze management.
A powerful, but user-friendly interface provides an easy way to use take backups and create copies of databases or database objects.
You can also use the client to manage objects that reside on managed and unmanaged database servers:
- Managing Cluster Level Objects
- Managing Database Objects
- Cast Dialog
- Collation Dialog
- Domain Dialog
- Domain Constraints Dialog
- Event Trigger Dialog
- Extension Dialog
- Foreign Data Wrapper Dialog
- Foreign Server Dialog
- Foreign Table Dialog
- FTS Configuration dialog
- FTS Dictionary Dialog
- FTS Parser Dialog
- FTS Template Dialog
- Function Dialog
- Language Dialog
- Materialized View Dialog
- Package Dialog
- Procedure Dialog
- Publication Dialog
- Schema Dialog
- Sequence Dialog
- Subscription Dialog
- Synonym Dialog
- Trigger function Dialog
- Type Dialog
- User Mapping Dialog
- View Dialog
- Creating or Modifying a Table