Skip to content
This repository has been archived by the owner on Jul 13, 2023. It is now read-only.

Latest commit

 

History

History
39 lines (30 loc) · 1.12 KB

Postgres.md

File metadata and controls

39 lines (30 loc) · 1.12 KB
Raw

The Postgres Integration

Description and Purpose

The Postgres Integration currently provides facilities for logging AGHAST Event data to a PostgreSQL database.

It logs, as simply as possible, values from AGHAST Events in one of three tables:

  • logged_integers
  • logged_floats
  • logged_strings

Also, the names table indexes the Logger Names provided in the configuration file. It is automatically populated.

Configuration

Consult the provided setup.sql for configuring your DB before using this Integration.

Example postgres.toml file...

# Postgres connection details
PgHost = "localhost"
PgPort = "5432"        # Use quotes for this
PgUser = "steve"
PgPassword = "aghast"  # Use a !!SECRET in production
PgDatabase = "aghast"

[[Logger]]  
  Name = "MusicActualTemp" 
  Topic = "pizero01/gpio/sensor/dht22_temperature"
  DataType = "float"                    # Either 'float', 'integer', or 'string'
  
[[Logger]]
  Name = "SteveOfficeUnitTemp"       
  Topic = "daikin2mqtt/Steve_Office/controls"
  Key = "set_temp"                      # payload is JSON, so must specify key
  DataType = "integer"

Usage