Top
Enterprise Postgres 14 SP1 Operation Guide
FUJITSU Software

1.1 Operating Methods

There are two methods of managing FUJITSU Enterprise Postgres operations:

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.

Operation management using commands

You can use commands for configuring and operating the database and managing operations.

Note

  • 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.

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 server machine capacity, and the optimum parameter for operations using WebAdmin, are set automatically.

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

None.

This is defined 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.

The messages that are output to the database server log are monitored.

Disk space

The status in the WebAdmin window can be checked. A warning will be displayed if the free space falls below 20%.

This is monitored using the df command of the operating system, for example.

Connection status

None.

This can be checked referencing pg_stat_activity of the standard statistics view from psql or the application.