Postgress/TimescaleDB issue

[cyberjunky]

I'm running version: 0.7.0 of DSMR reader for years now, very good add-on.

Is there a way to use Hass.io DMSR reader with a 'normal/other' Postgress package? Or another SQL database?

I have issue updating to latest Timescale version, it doesn't start I think because it misses a default homeassistant or admin user with known password.

Also, is there a way to recover the password for the Postgress/TImescal database so I can make a dump/reload?

[sanderdw]

Hi! Thanks for your compliments :).

Yes you can change these settings, just put in the correct external postgres db settings:

Regarding support on the timescale addon, you can go to this thread: https://community.home-assistant.io/t/home-assistant-add-on-postgresql-timescaledb/198176

Let me know if this helps or you need additional help.

[cyberjunky]

I fixed the timescale update issue. Now onto the dsmr_reader add-on update, but I read that you need to manually enter all settings again, so I need my admin password to see them, before running the update. I lost the password, trying to reset it I get this error, any pointers?

I logged into homeassistant and run

docker ps |grep dsmr
docker -it {{container_id}} /bin/bash
./manage.py dsmr_superuser

Which results in:

Where to change/set dsmrdb ip?

[cyberjunky]

Arrgg it's just a config item in add-on!

[cyberjunky]

When trying to upgrade DSMRreader from 0.7.0 (it's old i know) I get this, is this because it's too old? Any tips?

[sanderdw]

https://github.com/sanderdw/hassio-addons/issues/60#issuecomment-1192376374

[cyberjunky]

Will removing the add-on remove the Postgres dsmr database, or does it stay and will be upgraded when I start the new add-on version? I don't want to loose years of data

[sanderdw]

No it will not touch any data :)

[cyberjunky]

It worked, sorry for all the questions, those pesky open-source users, I know all about them! ;-)

[sanderdw]

No worries 👍