postgresql-17-rum

PostgreSQL RUM access method

This PostgreSQL extension provides the RUM access method, an inverted index with additional information in posting lists.

postgresql-17-prioritize

Get and set the nice priorities of PostgreSQL backends

This module implements an interface to getpriority() and setpriority() for PostgreSQL backends, callable from SQL functions. Essentially, this module allows users to `renice' their backends.

postgresql-17-set-user

PostgreSQL privilege escalation with enhanced logging and control

The set_user PostgreSQL extension allows switching users and optional privilege escalation with enhanced logging and control. It provides an additional layer of logging and control when unprivileged users must escalate themselves to superuser or object owner roles in order to perform needed maintenance tasks.

postgresql-17-unit

SI Units for PostgreSQL

postgresql-unit implements a PostgreSQL datatype for SI units, plus byte. The base units can be combined to named and unnamed derived units using operators defined in the PostgreSQL type system. SI prefixes are used for input and output, and quantities can be converted to arbitrary scale.

postgresql-17-prefix

Prefix Range module for PostgreSQL

This PostgreSQL module provides the prefix_range datatype, allowing to index searches such as finding the longest prefix matching a telephone number, having prefixes in a table and telephone number as a parameter:

remrun

copy a file to a remote host and execute it there

The remrun tool may be useful for one-off execution of a series of commands or a complicated command that does not easily lend itself to shell quoting and escaping via SSH. It copies the specified file to the remote host using SSH under a temporary filename, executes it on the remote side, then removes the temporary file.