Missing Database

[gcortes]

I followed the excellent post of the Home Assistant forum on the installation of Postgres, Timescale, and LTSS

In the post it says:

Assuming TimescaleDB was installed via the add-on installer and the necessary databases were created, those databases are accessible to any role that can authenticate.

When I restart Home Assistant, I get the error:

Error during connection setup: (psycopg2.OperationalError) connection to server at (10.0.0.128), port 5432 failed: FATAL: database "ha_ltss" does not exist

It's a valid error since the DB doesn't exist. I take it I need to create the database ha_ltss. Do I log in as postgres and just do

CREATE DATABASE ha_ltss WITH OWNER=app_ltss;

Above, it says necessary database. Is there more than one? If so, what others?

If there is documentation on this that I missed.

I installed timescaledb in a Promox LXC using the instructions from timescale.com

[gcortes]

I went ahead and created the database with CREATE DATABASE ha_ltss WITH OWNER=app_ltss;

After restarting Home Assistant, I got an error on missing extensions. The instructions said nothing about applying them to the ha_ltss database. I had applied them to the postgres database. After adding them to the ha_ltss database, Home Assistant came up clean and the ltss table appeared when I did \dt.

If there no other database to be created, you can close this issue.