PostgreSQL - Red Hat Edition: Graphical Tools Guide
Prev	Chapter 7. Control Center Reference	Next

7.14. Stopping a Database Cluster's Engine

To stop a cluster engine, select the Database Cluster and choose Control => Stop or click the Stop Toolbar button.

When you use Control => Stop, an option dialog is presented where you can select the mode of database server shutdown to be used:

Smart
Fast
Immediate

For more information on stop strategies, refer to pg_ctl in the PostgreSQL 7.3 Reference Manual.

Figure 7-29. The Stop Cluster Engine Options Dialog

The Stop Toolbar button always invokes the safer Smart database server shutdown mode.

The system updates the Status Bar at each step of the operation and refreshes the dialog when done.

	Note
	With the Smart option, the backend waits for all transactions to finish. If there is a long-running transaction, the Control Center may timeout and believe that the stop operation has failed. However, the Smart stop request has already been sent to the backend and it will eventually stop. You need to correct the pending transaction problems and use the Refresh option after that to confirm that the database service has stopped.

Note

With the Smart option, the backend waits for all transactions to finish. If there is a long-running transaction, the Control Center may timeout and believe that the stop operation has failed. However, the Smart stop request has already been sent to the backend and it will eventually stop. You need to correct the pending transaction problems and use the Refresh option after that to confirm that the database service has stopped.

Figure 7-30. The Status Bar After a Stop Operation

Prev	Home	Next
Starting a Database Cluster's Engine	Up	Restarting a Database Cluster's Engine