3.7 Remotely Starting and Stopping Monitored Servers

Get Postgres Tips and Tricks

Subscribe to get advanced Postgres how-tos.

3 Installing Postgres Enterprise Manager : 3.7 Remotely Starting and Stopping Monitored Servers

3.7 Remotely Starting and Stopping Monitored Servers

PEM allows you to startup and shutdown monitored server instances on remote machines from the PEM client. Each remote server must be properly configured to allow the PEM client to stop or restart the server. To use the PEM client to control the startup or shutdown of a configured server, complete the New Server Registration dialog, registering the database server with PEM:

•

Specify the Store on PEM Server option on the Properties tab.

•

Specify the name of a service script in the Service ID field on the Advanced tab:

For Advanced Server, the service name is ppas-9.x.

For PostgreSQL, the service name is postgresql-9.x.

To connect to the newly-defined server, right click the server name in the tree control, and select Connect from the context menu. Provide a password when prompted.

To start or stop the server, right click the server name in the tree control, and select the Queue Server Startup or Queue Server Shutdown (shown in Figure 3.5) from the context menu.

Figure 3.5 - The context menu of a remotely managed server.

Note that currently, PEM only supports the fast shutdown option of the database server.

3 Installing Postgres Enterprise Manager : 3.7 Remotely Starting and Stopping Monitored Servers