Get Postgres Tips and Tricks
Subscribe to get advanced Postgres how-tos.
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.
Contents:
PEM provides an easy to use environment in which to manage restore points, import/export tasks, and organize vacuum/analyze management.
Contents:
A powerful, but user-friendly interface provides an easy way to use take backups and create copies of databases or database objects.
Contents:
You can also use the client to manage objects that reside on managed and unmanaged database servers:
Contents:
- 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
- Schema Dialog
- Sequence Dialog
- Synonym Dialog
- Trigger function Dialog
- Type Dialog
- User Mapping Dialog
- View Dialog
- Creating or Modifying a Table