Top
Enterprise Postgres 14 SP1 Operation Guide
FUJITSU Software

D.1 pgx_tde_master_key

Provides information about the master encryption key being used when using the key management system as a keystore.

Column

Type

Description

kms_name

text

Key management system name

key_id

text

Key ID in key management system

local_key_id

integer

Sequence of keys used internally by FUJITSU Enterprise Postgres

status

enum

in-use: Current master encryption key in use

used: 過Master encryption key used in the past

scheduled: A new encryption key that was requested to update the master encryption key and is to be used.

Execution example

postgres=# select * from pgx_tde_master_key;
 kms_name  |                key_id                | local_key_id  | status  
-----------+--------------------------------------+---------------+---------
 mykmipsvr | a0eebc99-9c0b-0000-0000-000000000000 |           1   | in-use  
(1 row)

Note

Do not use queries with "*" in the selection list, as the order of the columns may change or columns may be added.