This section describes how to operate Symfoware Server.
There are two methods of managing Symfoware Server operations - select one that suits your purposes:
Simple operation management using a web-based GUI tool (WebAdmin)
Suitable when using frequently used basic settings and operations for operation management.
This method allows you to perform simple daily tasks such as starting the system before beginning business, and stopping the system when business is over, using an intuitive operation.
Advanced operation management using server commands
When operating in a system that is automated by operation management middleware (Systemwalker Centric Manager, for example), this method allows you to use more detailed settings and operations and perform higher level operation management.
Note that it is not possible to combine WebAdmin and server commands in the following ways:
Using WebAdmin to operate instances created with the initdb command
Using commands to operate instances created with WebAdmin
Using commands to recover databases backed up with WebAdmin
For instances created with WebAdmin, however, backup can be obtained with the pgx_dmpall command. Also, WebAdmin can perform recovery by using the backup obtained with the pgx_dmpall command.
The following table shows the GUI and command operations used at different phases of operation:
Operation | Operation with the GUI | Operation with commands | |
|---|---|---|---|
Setup | Creating an instance | WebAdmin | initdb command |
Changing the configuration files | WebAdmin | Direct editing of the configuration file | |
Start an instance | WebAdmin | pg_ctl command | |
Creating a database | pgAdmin | Specify with a DDL statement and define with psql and applications | |
Backing up the database | WebAdmin | pgx_dmpall command | |
Monitoring | Database errors | WebAdmin (*1) | Messages output to the system log (*1) |
Disk space | WebAdmin (*1) (*2) | OS df command (*1) | |
Connection status | pgAdmin | psql command (*3) | |
Database recovery | WebAdmin | pgx_rcvall command | |
*1: It is possible to monitor with operation management middleware (Systemwalker Centric Manager, for example).
*2: A warning is displayed when disk usage exceeds 80%
*3: Status is monitored by retrieving data from the pg_stat_activity standard statistics information view.
See
Refer to "Periodic Operations" and "Actions when an Error Occurs" in the Operation Guide for information on monitoring and database recovery.
