PostgreSQL

[tteck]

To make sure our PostgreSQL is secured with a strong password, set a password for its system user and then change the default database admin user account

Change user password

passwd postgres

Login using Postgres system account

su - postgres

Now, change the Admin database password

psql -c "ALTER USER postgres WITH PASSWORD 'your-password';"

Create a new user.

psql

CREATE USER admin WITH PASSWORD 'your-password';

Create a new database:

CREATE DATABASE homeassistant;

Grant all rights or privileges on created database to the user

GRANT ALL ON DATABASE homeassistant TO admin;

To exit psql

\\q

Then type exit to get back to root

Change the recorder: db_url: in your HA configuration.yaml

Example:

recorder:
  db_url: postgresql://admin:[email protected]:5432/homeassistant?client_encoding=utf8