PostgreSQL #2916
PostgreSQL
#2916
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
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
Login using Postgres system account
Now, change the Admin database password
psql -c "ALTER USER postgres WITH PASSWORD 'your-password';"
Create a new user.
Create a new database:
Grant all rights or privileges on created database to the user
To exit psql
\\q
Then type exit to get back to root
Change the recorder:
db_url:
in your HA configuration.yamlExample:
recorder: db_url: postgresql://admin:your-password@192.168.100.20:5432/homeassistant?client_encoding=utf8
Beta Was this translation helpful? Give feedback.
All reactions