Database is not restoring - Githubissues

xirixiz / dsmr-reader-docker

DSMR Reader in Docker.

https://hub.docker.com/r/xirixiz/dsmr-reader-docker

112 stars 33 forks source link

Database is not restoring #335

Closed alexswart closed 1 year ago

alexswart commented 1 year ago

Support guidelines

[X] I've read the support guidelines

I've found an issue and checked that ...

[x] ... the documentation does not mention anything about my problem
[x] ... there are no open or closed issues that are related to my problem

Description

last week my server is crashed and are not able to repair it luckily i had a backup with the dropbox integration of my database

i have reinstall dsrm-reader in Homeassistant as an addon and it works fine but only the database wont restore

Expected behaviour

get my historical data back to dsmr-readerreader

Actual behaviour

i dont see any historical data in dsmr-reader

Steps to reproduce

i have followed the next steps to repair it

stop de DMSR Addon service
Open pgAdmin4
Create a database dsmrreader in pgAdmin4
goto terminal
goto /usr/share/
upload the sql filt to /usr/share folder
docker exec -it addon_77b2833f_timescaledb bash
su - postgres
psql -d dsmr < /share/test/dsmrreader-postgresql-backup-Tuesday.sql
Start DSMR Addon

i havnt any problems with the steps above but i dont get the history of my old database

Docker info

no aditional info

Version

Docker compose version (type docker-compose --version):
System info (type uname -a):

Docker compose

dsmr-reader 5.10.3

Container logs

no errors

Additional info

No response

alexswart commented 1 year ago

problem solved, the backup itself didnt contain any data....