Table of Contents Previous Next

3 Installing Postgres Enterprise Manager™ : 3.6 Adding a Managed Server

To add a new server to PEM, select the Add Server option from the File menu. You can also open the New Server Registration dialog by clicking the Add Server toolbar button.
The New Server Registration dialog contains five tabs on which you provide information about the new server. The first tab (Properties) contains general information about how to connect to the new server (see Figure 3.4)
Screen shot 2013-09-18 at 11
Use the fields on the Properties tab to supply information about the monitored server.
Provide a descriptive Name for the new server.
Specify the Port number that the server is monitoring.
Specify the Username and Password that PEM should use when connecting to the server.
Check the box next to Store password, to instruct the PEM client to store passwords in the ~/.pgpass file ( on Linux) or %APPDATA%\\postgresql\\pgpass.conf (on Windows).
To ensure that the new server will be managed by PEM, check the Store on PEM Server checkbox.
Use the Colour field to specify a colour that will be displayed in the background of the PEM tree control behind each object that resides on this server.
Use the Group field to include the server in a server group; using groups can help you manage large numbers of servers more easily.
Only PEM users who are members of the role name specified in the Team field, who created the server initially, or have superuser privileges on the PEM server will see this server when they logon to PEM. If you do not specify a Team role, all PEM users will see the server.
Use the fields on the SSL tab to provide authentication information specific to your system.
Use the fields on the SSH Tunnel tab to implement SSH tunneling to the new server.
Use the fields on the Advanced tab to specify advanced configuration details:
To allow the PEM server to remotely control startup and shutdown of the monitored Postgres server, enter the service name in the service ID control field.
Use the PEM Agent tab to specify an agent binding for the new server:
Use the drop-down list box in the Bound Agent field to select the PEM Agent that is installed on your managed host system.
Specify the host server’s IP address in the Host field.
Please note that you can specify a different Host address on the PEM agent tab than the address used on the Properties tab. For example, you can configure the PEM agent to connect via a Unix socket to the monitored server, while the client connects using an SSL connection to a forwarded port on an external firewall (that is not appropriate for the agent).
Specify the Port number of the managed system.
Use the SSL field to specify an SSL operational mode.
Use the Database field to specify the name of the Postgres Plus database to which the agent will initially connect.
Provide the password that the agent should use when connecting to the server in the Password field, and verify it by typing it again in the Confirm Password field. If you do not specify a password, you will need to configure the authentication for the agent manually (using a .pgpass file, for example).
When you've completed the New Server Registration dialog, click OK. The name of the new server will be included under the PEM Server Directory node in the tree control.

3 Installing Postgres Enterprise Manager™ : 3.6 Adding a Managed Server

Table of Contents Previous Next