Preface

Purpose of this document

The Fujitsu Enterprise Postgres database system extends the PostgreSQL features and runs on the Linux platform.

This document is the Fujitsu Enterprise Postgres Operation Guide.

Intended readers

This document is intended for those who install and operate Fujitsu Enterprise Postgres.

Readers of this document are assumed to have general knowledge of:

PostgreSQL
SQL
Linux

Structure of this document

This document is structured as follows:

Chapter 1 Operating Fujitsu Enterprise Postgres: Describes how to operate Fujitsu Enterprise Postgres.

Chapter 2 Starting an Instance and Creating a Database: Describes how to start a Fujitsu Enterprise Postgres instance, and how to create a database.

Chapter 3 Backing Up the Database: Describes how to back up the database.

Chapter 4 Configuring Secure Communication Using Secure Sockets Layer: Describes communication data encryption between the client and the server.

Chapter 5 Protecting Storage Data Using Transparent Data Encryption: Describes how to encrypt the data to be stored in the database.

Chapter 6 Using Transparent Data Encryption with Key Management Systems as Keystores: Describes the operation of transparent data encryption when a key management system is used as a keystore.

Chapter 7 Policy-based Login Security: Describes how to apply login security policies to users.

Chapter 8 Data Masking: Describes the data masking feature.

Chapter 9 Periodic Operations: Describes the periodic database operations that must be performed on Fujitsu Enterprise Postgres.

Chapter 10 Streaming Replication Using WebAdmin: Describes how to create a streaming replication cluster using WebAdmin.

Chapter 11 Installing and Operating the In-memory Feature: Describes how to install and operate the in-memory feature.

Chapter 12 Parallel Query: Describes the factors taken into consideration by Fujitsu Enterprise Postgres when performing parallel queries.

Chapter 13 High-Speed Data Load: Describes how to install and operate high-speed data load.

Chapter 14 Global Meta Cache: Describes how to use Grobal Meta Cache feature.

Chapter 15 Local Meta Cache Limit: Describes how to use Local Meta Cache Limit feature.

Chapter 16 Backup/Recovery Using the Copy Command: Describes backup and recovery using the copy command created by the user.

Chapter 17 Actions when an Error Occurs: Describes how to perform recovery when disk failure or data corruption occurs.

Appendix A Parameters: Describes the Fujitsu Enterprise Postgres parameters.

Appendix B System Administration Functions: Describes the system administration functions of Fujitsu Enterprise Postgres.

Appendix C System Catalogs: Describes the system catalog used by Fujitsu Enterprise Postgres.

Appendix D System Views: Describes the system view used by Fujitsu Enterprise Postgres.

Appendix E Tables Used by Transparent Data Encryption: Describes the tables used by the transparent data encryption feature.

Appendix F Tables Used by Data Masking: Describes the tables used by the data masking feature.

Appendix G Tables Used by Aggressive Freeze for Tuples: Describes the tables used by the agressive freeze for tuples.

Appendix H Tables Used by High-Speed Data Load: Describes the tables used by high-speed data load.

Appendix I Starting and Stopping the Web Server Feature of WebAdmin: Describes how to start and stop WebAdmin (Web server feature).

Appendix J WebAdmin Wallet: Describes how to use the Wallet feature of WebAdmin.

Appendix K WebAdmin Disallow User Inputs Containing Hazardous Characters: Describes characters not allowed in WebAdmin.

Appendix L Copy Command Samples that Use the Advanced Copy Feature of the ETERNUS Disk Array: Describes copy command samples that use the advanced copy feature of the ETERNUS disk array.

Appendix M Collecting Failure Investigation Data: Describes how to collect information for initial investigation.

Export restrictions

Exportation/release of this document may require necessary procedures in accordance with the regulations of your resident country and/or US export control laws.

Issue date and version

Edition 1.0: November  2024