expaso / hassos-addons

Home Assistant Add-ons
Apache License 2.0
52 stars 14 forks source link

I would like to use the database without a recorder #38

Closed 111lisu closed 9 months ago

111lisu commented 9 months ago

I would like to use only the database itself, but how to set a password/pg_hba.conf in it, under normal conditions I would use cli interface

111lisu commented 9 months ago

Sorry im find https://github.com/Expaso/hassos-addon-timescaledb

Securiy Notice!

The default username is postgres with password homeassistant. Make sure you change this immediately after activating the add-on:

ALTER USER user_name WITH PASSWORD 'strongpassword'; A default pg_hba.conf is created in the data directory with the following content, which allows local peer users and network users with passwords.:

TYPE DATABASE USER ADDRESS METHOD

host all all 0.0.0.0/0 md5" local all all 0.0.0.0/0 md5" local all all 0.0.0.0/0 peer"