MQTT & POSTGRESQL on Raspberry

[Colin]

Please see the link below on how to share a flow here so that it is importable. You can edit your previous post accordingly.
Do you have a particular reason for wanting to use postgresql? You might like to consider influxdb which is designed for exactly the requirement you describe. There are influx nodes that make it very easy to output to influx (node-red-contrib-influxdb) and grafana has built in support for influx.

How to share code or flow json

To share code samples or flow json in this forum, you need to take care to format it properly so that it is displayed correctly. The easiest way to do that is to click the 'Preformatted Text' button in the toolbar: [image] Then paste in your code or flow json. You should end up with three back-tick characters - ``` - on their own line before and after the code. On standard US English keyboards, this is on the same key as the ~ character. [IMG_20181111_155651] Using the backticks will ens…