{"repo":"rosenloecher-it/mqtt-pg-logger","free":true,"listed":false,"github":"https://github.com/rosenloecher-it/mqtt-pg-logger","clone":"git clone https://github.com/rosenloecher-it/mqtt-pg-logger.git","description":"MQTT to PostgreSQL Logger","language":"Python","stars":18,"topics":["mqtt","smarthome","postgresql"],"license":"MIT","category":"databases-storage","readme_excerpt":"mqtt-pg-logger Collects MQTT messages and stores them in a Postgres database. - Runs as Linux service. - Provides the message payload as standard VARCHAR text and additionally converts the payload into a JSONB column if compatible. (See: trigger.sql and convert.sql) - Clean up old messages (after x days). Startup Prerequisites Python 3 ... Prepare python environment Configuration Edit your mqtt-pg-logger.yaml . See comments there. Run Register as systemd service Additional infos Database infos Consider running a VACUUM ANALYZE on your Postgres database on a periodic base (CRON). This will reclaim storage occupied by dead tuples. MQTT broker related infos If no messages get logged check your broker. Not that retained messages get logged again after a restart of the service. And especially stale messages of meanwhile unused topic gets logged again and again. Maintainer & License MIT © Raul Rosenlöcher The code is available at [GitHub][home]. [home]: https://github.com/rosenloecher-it/mqtt-pg-logger","default_branch":null,"files":null,"tree":[],"storefront":"/r/rosenloecher-it","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/rosenloecher-it/mqtt-pg-logger/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}