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.
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 pgAdmin or 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
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.
If anti-virus software is used, set scan exception settings for directories so that none of the files that comprise Fujitsu Enterprise Postgres are scanned for viruses. 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.
