Install timeseriesdb in a given PostgreSQL schema. Make sure the database user has sufficient rights to perform the necessary operations on the schema. In the process tables, roles, triggers and functions will be created. Also extensions will be installed and rights will be granted and revoked from the freshly created roles. Note also, that the functions created are created as SECURITY DEFINER roles.

install_timeseriesdb(
  con,
  schema = "timeseries",
  verbose = FALSE,
  install_tables = TRUE,
  install_functions = TRUE
)

Arguments

con

RPostgres connection object.

schema

character name of the database schema. Defaults to 'timeseries'

verbose

boolean Should progress messages be printed? Default FALSE

install_tables

boolean Should the tables be created? Default TRUE

install_functions

boolean Should the functions be installed? Default TRUE

Details

install_tables and install_functions can be used to install components of timeseriesdb independently (e.g. only update function definitions without touching the table structure). They are used mainly for development purposes.