Table of Contents Previous Next


11 Postgres Expert - Best Practice Enforcement : 11.1 Using the Postgres Expert Wizard

To use the Postgres Expert wizard select the Postgres Expert option from the Management menu in the PEM client. When the wizard's Welcome window opens (see Figure 11.1), click Next to continue.
The wizard displays a tree control that allows you to choose the Experts and Rules with which Postgres Expert will evaluate the specified server or database (see Figure 11.2).
Select from the Configuration Expert rules to analyze the parameter settings of the server or operating system to find any adjustments that might improve system performance.
Select from the Schema Expert rules to analyze schema objects (locating missing primary keys, foreign keys without indexes, etc).
Select from the Security Expert rules to review the system to find security vulnerabilities.
Check the box next to Servers/Databases to instruct Postgres Expert to review the selected server for all of the items in the tree control.
Deselct the box next to Servers/Databases to to un-check all of the rules; then, navigate through the tree control, specifying only the items that you wish Postgres Expert to evaluate.
After making your selections, click Next to continue to the Server/Databases tree control (see Figure 11.3).
You can select the default option and click Finish to view an onscreen report from Postgres Expert, or check the box next to Download the report to save a copy of the report to an HTML file for later use. If you choose to save the report to a file, the download will begin immediately. The file will be saved in your default download directory.

11 Postgres Expert - Best Practice Enforcement : 11.1 Using the Postgres Expert Wizard

Table of Contents Previous Next