Top
Enterprise Postgres 14 SP1 Installation and Setup Guide for Server
FUJITSU Software

4.1 Operating Method Types and Selection

This section describes how to operate FUJITSU Enterprise Postgres.

There are two methods of managing FUJITSU Enterprise Postgres operations - select one that suits your purposes:

The Operation Guide describes the operating method using WebAdmin, and the equivalent operating method using the server commands.

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.

Usage method

Usage is started by using WebAdmin to create the instance.

By using an external scheduler and the pgx_dmpall command, periodic backups can be performed, which can then be used in recovery using WebAdmin.

Note

Do not use a server command other than pgx_dmpall and pgx_keystore or a server application. Operation modes that use server commands and server applications cannot be used in conjunction with WebAdmin. If used, WebAdmin will not be able to manage the instances correctly.
In addition, to perform a backup by copy command from the pgx_dmpall command, select the operating method using the server commands.
Refer to Reference and the PostgreSQL Documentation for information on server commands and server applications.

Advanced operation management using server commands

An overview of the operating method using the GUI, and its relationship with the operating method using the server commands, are shown below.

Refer to the Operation Guide for details.

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.

See

Refer to "Periodic Operations" and "Actions when an Error Occurs" in the Operation Guide for information on monitoring and database recovery.