Additional PostgreSQL Configuration Action include Cluster information and function for postgreSQL cluster start, stop and restart and removing configruation.
1. Cluster Information
This option is used to display the information regarding
Parameters relevant to the type of DR cluster created
The databases that are in the cluster
Size of the databases
The overall size of the cluster
tablespace information
To view the cluster information, Click on any PostgreSQL configuration on the dashboard, and on the right ACTIONS pane, this option is available:
On the following screen, you will be able to see configuration information, cluster information. Configuration information differs for WAL Streaming and WAL archiving configurations, cluster information is same for both.
A. WAL Streaming Configuration information
The backup location indicates location for the base backup which was used for creating the DR postgreSQL cluster
B. WAL Archiving Configuration information
The WAL Archiving configuration cluster information displays in addition the WAL Archive settings.
C. Cluster information
Cluster information includes cluster status for primary and standby (1) and also information about the databases, tablespace and their sizes.
2. Start/Stop Cluster
Dbvcontrol dashboard enables you to easily start, stop and restart postgreSQL cluster. If you want perform these operations on primary or standby cluster, select Start/Stop cluster from the ACTIONS pane:
On the following screen you will be able to perform start, stop and restart actions (2) for primary and/or standby cluster (1):
pg_ctl is used to perform these actions
3. Removing Configuration
PostgreSQL configuration can be removed by going to ACTIONS pane and clicking on “Remove Configuration”:
Only the dbvcontrol dashboard configuration will be removed, postgreSQL instance and datafiles on primary will be kept untouched
Comments