There are two methods of managing Fujitsu Enterprise Postgres operations:
Operation management using GUI tools
Operation management using commands
See
Before performing database multiplexing using database multiplexing, refer to "Database Multiplexing Mode" in the Cluster Operation Guide (Database Multiplexing).
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, create a streaming replication cluster, 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 Fujitsu Enterprise Postgres, you can use the expanded features provided by Fujitsu Enterprise Postgres on the PostgreSQL SQL commands.
See
Refer to pgAdmin Help for information on the expanded features of pgAdmin provided by Fujitsu Enterprise Postgres.
Operation management using commands
You can use commands for configuring and operating the database and managing operations.
Points to consider when choosing an operation method
You cannot combine WebAdmin and server commands to perform the following operations:
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.
To operate an instance created using the initdb command in WebAdmin, the instance needs to be imported using WebAdmin.
You can perform backup and restoration in pgAdmin, but the backup data obtained with WebAdmin and pgx_dmpall is not compatible with the backup data obtained with 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 | Operation with the GUI | Operation with commands | |
|---|---|---|---|
Setup | Creating an instance | WebAdmin is used. | The configuration file is edited directly using the initdb command. |
Creating a standby instance | WebAdmin is used. WebAdmin performs a base backup of the source instance and creates a standby instance. | A standby instance is created using the pg_basebackup command. | |
Changing the configuration files | WebAdmin is used. | The configuration file is edited directly. | |
Starting and stopping an instance | WebAdmin is used. | The pg_ctl command is used. | |
Creating a database | This is defined using pgAdmin of the GUI tool, or using the psql command or the application after specifying the DDL statement. | ||
Backing up the database | WebAdmin, or the pgx_dmpall command, is used. | It is recommended that the pgx_dmpall command be used. Recovery to the latest database can be performed. | |
Database recovery | WebAdmin is used. | To use the backup that was performed using the pgx_dmpall command, the pgx_rcvall command is used. | |
Monitoring | Database errors | The status in the WebAdmin window can be checked. (*1) | The messages that are output to the database server log are monitored (*1) |
Disk space | The status in the WebAdmin window can be checked. A warning will be displayed if the free space falls below 20%. (*1) | This is monitored using the df command of the operating system, for example. (*1) | |
Connection status | This can be checked using pgAdmin of the GUI tool, or referencing pg_stat_activity of the standard statistics view from psql or the application. | ||
*1: This can be used together with system log monitoring using operations management middleware (Systemwalker Centric Manager, for example).
