First time user: Can't connect to Postgres database

[tgulikers]

Hi all,

I'm attempting to set-up TeslaMate in HAOS. It's all add-ons; TeslaMate itself, Postgres, MQTT and Grafana.

The instructions seem pretty straight-forward: Set-up at least Postgres and go ahead with TeslaMate after entering the details.
However, it seems the Postgres database is not reachable.

When I start TeslaMate the following is shown in the logs:

[16:10:25] INFO: Starting NGINX...
[15:10:29] ERROR: PostgreSQL at 'db21ed7f-postgres' is not ready or unreachable
[16:10:30] ERROR: TeslaMate encountered an error, halting add-on

Meanwhile, Postgres has started successfully but seems to be still waiting for port 5432 to open.

POSTGRES_DB='teslamate'
POSTGRES_PASSWORD=******
POSTGRES_USER='postgres'
Timezone set from Etc/UTC to Europe/Amsterdam
/etc/cont-init.d/01-config_yaml.sh: executing
Setting permissions for the config.yaml directory
Load environment variables from /config/config.yaml if existing
If accessing the file with filebrowser it should be mapped to /addon_configs/db21ed7f_postgres/config.yaml
... no config file, creating one from template. Please customize the file in /config/config.yaml before restarting.
---------------------------------------------------------
Wiki here on how to use : github.com/alexbelgium/hassio-addons/wiki/Add‐ons-feature-:-add-env-variables
... no env variables found, exiting
/etc/cont-init.d/01-custom_script.sh: executing
Execute /addon_configs/db21ed7f_postgres/postgres.sh if existing
Wiki here : github.com/alexbelgium/hassio-addons/wiki/Add-ons-feature-:-customisation
/etc/cont-init.d/20-folders.sh: executing
/etc/cont-init.d/99-run.sh: executing
[14:31:33] WARNING: A default config.env file was copied in /config. Please customize according to https://hub.docker.com/_/postgres and restart the add-on
[14:31:33] INFO: Starting the app
Everything started!
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
Data page checksums are disabled.
fixing permissions on existing directory /config/database ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Europe/Amsterdam
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok
initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
    pg_ctl -D /config/database -l logfile start
waiting for server to start....2025-01-05 14:32:00.739 CET [252] LOG:  redirecting log output to logging collector process
2025-01-05 14:32:00.739 CET [252] HINT:  Future log output will appear in directory "log".
. done
server started
CREATE DATABASE
/usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/10-vector.sh
[14:32:05] INFO: Waiting for port 5432 to open...
[14:47:05] INFO: Enabling vector.rs
/docker-entrypoint-initdb.d/10-vector.sh: line 24: setup_postgres.sql: Permission denied

I've searched for hours now trying to figure how to resolve the issue, even starting with a completely fresh HA instance, but no luck :(
If anyone has any experience to set up an exclusive add-on installation on HAOS, I'd love to hear your thoughts and guidance.

Thanks in advance!