Fujitsu Enterprise Postgres consists of the following files for controlling and storing the database. The table below shows the relationship between the number of such files and their location within a single instance.
Do not place files for use with Fujitsu Enterprise Postgres in a directory mounted over the network except when creating a database space in a storage device on a network. Examples include NFS (Network File System) and CIFS (Common Internet File System). This is because the database might hang if the network fails.
File type | Required | Quantity | How to specify the location |
|---|---|---|---|
Program files | Y | Multiple | Note that "<x>" indicates the product version. /opt/fsepv<x>server64 |
Database cluster | Y | 1 | Specify using WebAdmin or server commands. |
Tablespace | Y | Multiple | Specify a space other than that under the database cluster, using the DDL statement. |
Backup | Y | Multiple | Specify using WebAdmin or server commands. |
Core file | Y | Multiple | Specify using WebAdmin, server commands, or postgresql.conf. |
Server certificate file (*1) | N | 1 | Specify using postgresql.conf. |
Server private key file (*1) | N | 1 | Specify using postgresql.conf. |
Master encryption key file (*1) | N | 1 | Specify the directory created as the key store using postgresql.conf. |
Connection service file (*1) | N | 1 | Specify using environment variables. |
Password file (*1) | N | 1 | Specify using environment variables. |
CA certificate file (*1) | N | 1 | Specify using environment variables. |
Y: Mandatory
N: Optional
*1: Set manually when using the applicable feature.
Note
If anti-virus software is used, the instance might not start or not respond during operation, and proper operation of the database might not be guaranteed. Do scan exclusion for directories so that all files that comprise Fujitsu Enterprise Postgres are excluded from virus scanning. Alternatively, if the files that comprise Fujitsu Enterprise Postgres are to be scanned for viruses, stop Fujitsu Enterprise Postgres and perform the scan when tasks that use Fujitsu Enterprise Postgres are not operating.
