There are two methods of managing Symfoware Server operations:
Operation management using GUI tools
Operation management using commands
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 or maintaining the database, you may need to manipulate the database objects defined in the database. For this, use pgAdmin, which is a GUI tool that performs this task easily.
The NCHAR type is available in Symfoware Server pgAdmin.
See
Refer to "Support for National Characters" in the Application Development Guide for information on the NCHAR type.
Refer to "1.7 Notes on pgAdmin" if using the features below in pgAdmin:
Query tool
Data view
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.
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 | pg_ctl 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 system log (*1) |
Disk space | WebAdmin (*1) (*2) | OS-provided df command (*1) | |
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.
