3.5. Clusters
Clusters are at the top level of the object hierarchy.
Before you begin using Administrator, you must initialize a database cluster. Refer to the PostgreSQL 7.3 Administrator's Guide for details on how to create and initialize a database cluster.
Once the cluster has been created and initialized, you can use Administrator to administer it.
 | Note |
|---|---|
Administrator cannot create or initialize clusters; it can only connect to existing clusters. |
3.5.1. Adding a Cluster
To add a cluster, from the Menu Bar choose File => Manage Clusters to display the Manage Clusters dialog. Click New to create a new cluster. The New Cluster dialog appears.
Configure the connection to the cluster as follows:
| Field | Description |
|---|---|
| Nickname | Specify a unique name for the new cluster. |
| Host | Enter the host name or host IP address. |
| Port | Enter the TCP/IP port that the backend is listening on. |
| User Name and Password | Enter the name and password for the user you are connecting as. (To learn how to create a user, see Section 3.27 Users.) The password entered can be used for authorization purposes based on how the pg_hba.conf file is configured. |
To test to see if the configuration is correct, click the Test button. If the test passes, click OK to commit the changes.
 | Tip |
|---|---|
Refer to the Client Authentication section of the PostgreSQL 7.3 Administrator's Guide for more information on the pg_hba.conf file and password authentication. |
3.5.2. Reconfiguring a Cluster
To reconfigure an existing cluster, right-click the cluster name and choose Configure Cluster from the context menu, or File => Manage Clusters, select a cluster from the list of existing clusters displayed in the resulting dialog, and click Edit. The Edit Cluster clustername dialog box appears, where clustername is the name of the chosen cluster.
Change the options desired and click OK.
Figure 3-20 shows how to reconfigure a cluster named sample_cluster to allow the user postgres to connect to the cluster on the host toboggan over TCP/IP on port 5432.
3.5.3. Removing a Cluster
To remove a cluster, right-click the cluster name in Tree View and choose REMOVE CLUSTER from the context menu, or select File => Manage Cluster, select a cluster to remove from the list of existing clusters displayed in the resulting dialog, and click Delete. If Preferences => Ask For Confirmations is enabled, you are asked to confirm that you want the cluster removed; if it is disabled, the cluster is removed immediately.
| Note |
|---|---|
The REMOVE CLUSTER operation clears the cluster configuration settings that enable Administrator to connect to that cluster, but does not affect the database cluster itself. |
To learn more about clusters, refer to the PostgreSQL 7.3 Administrator's Guide.