Provides information about the master encryption key being used when using the key management system as a keystore.
Column | Type | Description |
|---|---|---|
local_key_id | integer | Sequence of encryption keys used internally by Fujitsu Enterprise Postgres |
kms_name | text | Key management system name |
key_name | text | Not currently used |
key_id | text | Key ID in key management system |
start_time | timestamp | Time the key was activated |
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;
local_key_id | kms_name | key_name| key_id | start_time | status
-------------+-----------+--------+--------------------------------------+-------------------+-----
1 | mykmipsvr | | a0eebc99-9c0b-0000-0000-000000000000 |2022-12-16 05:43:49| 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.