To start Control Center, you can either:
Run Control Center from a command line:
Under Gnome, click on the Red Hat main menu button, then select Programs => System Settings => Server Settings => Control Center for PostgreSQL - Red Hat Edition.
Control Center uses menus, icons, and table displays to make it easy for you to create and manage PostgreSQL database services and clusters.
Along the top of the main program window is the Menu Bar. The Menu Bar enables you to create and manage database clusters, control database engine state, edit configuration files, and manage preferences, among other things.
Below the Menu Bar is the Toolbar. The Toolbar enables you to create clusters, start/stop/restart database engines, refresh the displayed information, and hide or show the Detail Area.
Below the Toolbar is the Summary Area. The Summary Area displays the clusters defined on the current server as well as displaying the current state of the clusters.
Below the Summary Area is the Detail Area. The Detail Area displays various information about the selected cluster.
Below the Detail Area is the Status Bar. The Status Bar displays the current state of Control Center as well as the server's name and IP address.
Control Center executes only one operation at a time—all commands are disabled while a command is being performed.
The Menu Bar enables you to create database clusters, control database engine state, edit configuration files, and manage preferences, among other things.
File contains the following items:
New creates a new database cluster.
Exit closes Control Center.
Edit contains the following items:
Clusters enables you to edit (and view) the settings of the cluster. You can modify the name, TCP/IP settings, encoding, and locale options for the cluster.
Engines enables you to add, remove, edit, and view database engines.
Locations enables you to edit the locations of the secondary database storage areas for the cluster.
HBA enables you to edit the Host-Based Authentication (pg_hba.conf) configuration file for the cluster.
Run Time Options enables you to edit the run time options associated with the cluster.
Log Settings enables you to configure PostgreSQL logging. You can modify log location, log level, log rotation, and compression.
Delete enables you to remove a cluster. Note that this operation cannot be undone.
Preferences enables you to configure whether the Detail Area is displayed on startup and whether Control Center utilizes tooltips.
Init contains the following items:
Assign Engine assigns a database engine to the cluster.
Initialize Main Storage Area initializes the cluster main location. This is equivalent to performing an initdb on the cluster.
Regression Tests invokes the PostgreSQL regression tests against the cluster.
Control contains the following items:
Start starts the selected database engine.
Stop stops the selected database engine.
Restart restarts the selected database engine.
View contains the following items:
Show Details Area controls the display of the Details Area in the main window.
Show Session Transcript launches the Control Center Session Transcript dialog, which displays information regarding the execution of the tool.
Log launches the Red Hat Log Viewer to display PostgreSQL system logs.
Refresh causes the information in the Summary Area and Detail Area to refresh.
Help contains information about Control Center in the About menu item. It also gives access to the appropriate sections of this manual in HTML.
Some Menu Bar functions can be activated from the keyboard.
The Toolbar enables you to create clusters, manage database engine state, refresh the displayed information, and control the display of the Detail Area.
The Summary Area displays information about the clusters defined on the current server. The cluster's name, catalog version, service port, and engine state are displayed. More information about the Summary Area can be found in Section 7.1 Browsing Information about Database Clusters.
The Detail Area displays information about the selected cluster on tabbed pages. You can toggle the display of the Detail Area on and off by selecting the Show Details icon in the Toolbar.
Displays information regarding the current status of the cluster, such as PGDATA, whether TCP/IP is enabled and on which port, and the command line arguements used when starting the postmaster.
Displays the contents of the pg_control file for the cluster.
Displays information regarding the various location areas associated with the cluster.
Displays the contents of the Host-Based Authentication (pg_hba.conf) configuration file of the cluster.
Displays the run time options of the cluster.
Display the PostgreSQL log of the cluster.