Sage and PostgreSQL

The SaGe server providers several command line utilities for initializing and manipulating RDF graphs hosted by the PostgreSQL backends.

Initializing a PostgreSQL graph

Usage: sage-postgres-init [OPTIONS] CONFIG GRAPH_NAME

  Initialize the RDF graph GRAPH_NAME with the postgres or postgres-mvcc
  backends, as described in the configuration file CONFIG.

Options:
  --index / --no-index  Enable/disable indexing of SQL tables. The indexes can
                        be created separately using the command sage-postgre-index
  --help                Show this message and exit.

Insert RDF triples into PostgreSQL

Usage: sage-postgres-put [OPTIONS] RDF_FILE CONFIG GRAPH_NAME

  Insert RDF triples from file RDF_FILE into the RDF graph GRAPH_NAME,
  described in the configuration file CONFIG. The graph must use the
  postgres or postgres-mvcc backends.

Options:
  -f, --format [nt|ttl|hdt]       Format of the input file. Supported: nt
                                  (N-triples), ttl (Turtle) and hdt (HDT).
                                  [default: nt]
  -b, --block_size INTEGER        Block size used for the bulk loading
                                  [default: 100]
  -c, --commit_threshold INTEGER  Commit after sending this number of RDF
                                  triples  [default: 500000]
  --help                          Show this message and exit.

(Re)generate indexes to speed-up query processing

Usage: sage-postgres-index [OPTIONS] CONFIG GRAPh_NAME

  Create the additional B-tree indexes on the RDF graph GRAPH_NAME,
  described in the configuration file CONFIG. The graph must use the
  postgres or postgres-mvcc backends.

Options:
  --help  Show this message and exit.