buildOperations

pgRDF runs inside PostgreSQL 18, so you operate it with the tools you already use for PostgreSQL: roles and grants, backups, EXPLAIN, pg_stat_statements. This section covers what is specific to pgRDF.

In this section

• build Install: Docker in two minutes, your own image, an existing server, the signed OCI bundle.
• settings Supported platforms: PostgreSQL 18 on Linux x86-64 and arm64 with glibc 2.39 or newer.
• fact_check Errors and diagnostics: SQLSTATE codes, completeness checks, settings, version and capability checks.
• query_stats Counters and health: pgrdf.stats() for dashboards, last_call_stats() for a single query.
• layers_clear Cache control: the two caches, and the one time you need to reset one.
• bolt Plan cache: how repeated SPARQL queries skip translation.
• hub Composing with SQL: join, materialise and wrap SPARQL results in views.

Checklist for a new server

1. PostgreSQL 18 on a supported platform.
2. shared_preload_libraries = 'pgrdf' in postgresql.conf, then a restart.
3. CREATE EXTENSION pgrdf; as a superuser, then grant an application role.
4. Confirm what is running:

SELECT pgrdf.version(), pgrdf.build_id(),
       (SELECT extversion FROM pg_extension WHERE extname = 'pgrdf') AS extversion,
       pgrdf.stats() -> 'shmem_ready' AS shmem_ready;

 version | build_id | extversion | shmem_ready
---------+----------+------------+-------------
 0.6.34  | v0.6.34  | 0.6.34     | true

The three version values should agree. shmem_ready is true when the preload is in effect. Then take the ten-minute tour.