Top
Enterprise Postgres 17 SP1 Knowledge DataManagement FeatureUser's Guide

4.5.1 Encrypting the Graph

A graph consists of multiple database objects, and even after the graph is created by the create_graph function, a new table will be created when a new label is added. If you want to encrypt multiple database objects that make up a graph, including those that will be created in the future, set the default tablespace of the entire database that stores the graph to an encrypted tablespace.

Example) When encrypting the entire database for which this feature is enabled

CREATE DATABASE rag_database TABLESPACE = encrypted_tablespace;
CREATE EXTENSION age;

To encrypt a graph when you cannot use a single tablespace per database, temporarily change the default tablespace to an encrypted tablespace before the operation that creates the graph.

Example) Specifying table space and creating a graph

SET default_tablespace = 'secure_tablespace';
SELECT create_graph('graph1');