There are two methods of managing Symfoware Server operations:
Operation management using GUI tools
Operation management using commands
See
Before performing switchover or failover operation using database multiplexing, refer to "Database Multiplexing Mode" in the Cluster Operation Guide.
Operation management using GUI tools
This involves managing operations using the WebAdmin and pgAdmin GUI tools.
Management using WebAdmin
This removes the requirement for complex environment settings and operational design for backup and recovery that is usually required for running a database. It enables you to easily and reliably monitor the state of the database, back up the database, and restore it even if you do not have expert knowledge of databases.
Management using pgAdmin
When developing applications and maintaining the database, you can use pgAdmin to perform simple operations on database objects, such as:
Rebuild indexes and update statistics
Create, delete, and update database objects
In addition, from pgAdmin of Symfoware Server, you can use the expanded features provided by Symfoware Server on the PostgreSQL SQL commands.
See
Refer to pgAdmin Help for information on the expanded features of pgAdmin provided by Symfoware Server.
Operation management using commands
You can use commands for configuring and operating the database and managing operations. However, note that if you start managing operations using commands, you cannot switch to WebAdmin-based operation management.
Note
You cannot combine WebAdmin and server commands to perform the following operations:
Use WebAdmin to operate an instance created using the initdb command
Use commands to operate an instance created using WebAdmin
Use WebAdmin to recover a database backed up using commands
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.
You can perform backup and restoration in pgAdmin, but the backup data obtained with WebAdmin and pgx_dumpall is not compatible with the backup data obtained with pgAdmin.
Refer to pgAdmin Help for other notes on pgAdmin.
Features used in each phase
The following table lists the features used in each phase for GUI-based operations and command-based operations.
Operation | GUI-based operation | Command-based operation | |
|---|---|---|---|
Setup | Instance creation | WebAdmin | initdb command |
Modification of the configuration file | WebAdmin | Directly edit the configuration file | |
Instance start | WebAdmin | OS-provided net command or sc command | |
Database creation | pgAdmin | Specify using the DDL statement, and define using psql and applications | |
Database backup | WebAdmin | pgx_dmpall command | |
Monitoring | Database failure | WebAdmin(*1) | Messages output to the event log (*1) |
Disk space | WebAdmin (*1) (*2) | OS-provided fsutil command (check available capacity) and dir command (check used capacity) | |
Connection status | pgAdmin | psql command (*3) | |
Database recovery | WebAdmin | pgx_rcvall command | |
*1: Operations can be monitored using operation management middleware (such as Systemwalker Centric Manager).
*2: A warning is displayed when disk usage reaches 80%.
*3: This command searches for pg_stat_activity in the standard statistics views and monitors the state.
