Install timeseriesdb — install_timeseriesdb • timeseriesdb

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.