This tutorial assumes:
- a single computer (like a Raspberry Pi)
- MQTT broker (like Mosquitto) running
- the
mosquitto_pubandmosquitto_subcommands are available.
| # best practice: linux | |
| nano ~/.pgpass | |
| *:5432:*:username:password | |
| chmod 0600 ~/.pgpass | |
| # best practice: windows | |
| edit %APPDATA%\postgresql\pgpass.conf | |
| *:5432:*:username:password | |
| # linux |