Management Basics v8

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.

• Grant Wizard

PEM provides an easy to use environment in which to manage restore points, import/export tasks, and organize vacuum/analyze management.

• Add named restore point Dialog
• Import/Export data Dialog
• Maintain a database object
• Storage Manager

A powerful, but user-friendly interface provides an easy way to use take backups and create copies of databases or database objects.

• Backup Dialog
• Backup Globals Dialog
• Backup Server Dialog
• Restore Dialog

You can also use the client to manage objects that reside on managed and unmanaged database servers:

• Managing Cluster Level Objects
• Managing Database Objects
• Creating or Modifying a Table