This is a document for PGroonga 2.X. See PGroonga 1.x document when you're using old PGroonga.

pgroonga_database module

Since 2.1.8.

Summary

pgroonga_database module provides functions that manage PGroonga database. Normally, you don't need to use this module.

Note that this module provides dangerous functions. You should not enable this module until you need this module.

Usage

You can install pgroonga_database module as an extension but you should care which users can use functions provided by this module.

You can restrict users who can use functions provided by this module by schema.

Here is an example to restrict user "admin" by creating pgroonga_admin schema and installing pgroonga_database module to the pgroonga_admin schema:

CREATE ROLE admin LOGIN;
CREATE SCHEMA pgroonga_admin AUTHORIZATION admin;
CREATE EXTENSION pgroonga_database SCHEMA pgroonga_admin;

In this example, users except the "admin" can't use functions provided by this module.

The "admin" user can use functions provided by this module with pgroonga_admin. prefix:

SELECT pgroonga_admin.pgoronga_database_remove();

See upgrade document for upgrading pgroonga_database module.

Functions

pgroonga_database module provides the following functions: