This section provides an overview of Postgres Enterprise Manager™ (PEM) installation and configuration; for more detailed instructions, please consult the Postgres Enterprise Manager™ Installation Guide, available at:
1. Install the PEM server components. The PEM server software and backend database (named pem) may reside on the same host as the supporting Apache/PHP server, or may reside on a separate host. You may use an existing Postgres server to host the PEM server, or use the PostgreSQL 9.3 installer bundled with the PEM server installer to create the backend database.You can use the PEM web client (installed by default with the PEM server installer) to manage your PEM installation, or install the full-featured PEM client. Unlike the lighter web-client, the full-featured PEM client allows you to execute SQL commands through a secure SSH tunnel.
4. The SQL Profiler installer prompts you for the location of your Postgres installation, and places the required software into that directory. The SQL Profiler plugin is already installed on Advanced Server instances, and requires only configuration to enable profiling.