hassbian-scripts

Scripts used in the Hassbian image.


HOME SUITES HASSBIAN-CONFIG (CLI) CONTRIBUTE

PostgreSQL

This script installs PostgreSQL and its dependencies for use with the recorder component in Home Assistant. No database or database user is created during this setup and will need to be created manually.

Installation

sudo hassbian-config install postgresql

Upgrade

No script available. Maybe you could write one?
If so, add a PR here when you are done:
homeassistant/hassbian-scripts

Additional info

Example of how to create the database:

sudo -s -u postgres
createuser homeassistant
createdb -O homeassistant homeassistant

Example configuration

recorder:
  db_url: postgresql://@/homeassistant #Connects to Postgresql via Unix socket, allowed by default

The installation script was originally contributed by @Landrash.