Old charges disappear since psql 13->15 update while database backup and restore done succesfully

[gamonier]

Hello all, pleased to meet you !
I'm new to this forum, while an old teslamate user (conteners, compose on Synology). What a great piece of code !

The problem : old charges have disappeared since database update, everything else is OK.

I've updated Pgsql contener from 13 to 15, modified the composer file, done everything described here ;

https://docs.teslamate.org/docs/maintenance/upgrading_postgres ( including backup of course)
then restored as told here :
https://docs.teslamate.org/docs/maintenance/backup_restore

Everything worked fine excepted than grafana does not show old charges anymore (new charges are displayed), and DC charging curves are lost :-(((
However new charges are visibles.
Charges sessions are still in the database :

Select * from charging_sessions ; show hundreds of lines.

Is there a way/hope to return to normal and showing the previous charges ?

Thx in advance pals !

[gamonier]

I respond to myself : it's now OK ! (At least it seems) ;-)

Reason found : The necessary housekeeping before restore was not perfectly done (schema, extension, etc ...).
=> Pay attention to really do this without errors 👍

docker compose exec -T database psql -U teslamate << .
drop schema public cascade;
create schema public;
create extension cube;
create extension earthdistance;
CREATE OR REPLACE FUNCTION public.ll_to_earth(float8, float8)
RETURNS public.earth
LANGUAGE SQL
IMMUTABLE STRICT
PARALLEL SAFE
AS 'SELECT public.cube(public.cube(public.cube(public.earth()*cos(radians($1))*cos(radians($2))),public.earth()*cos(radians($1))*sin(radians($2))),public.earth()*sin(radians($1)))::public.earth';
.

Now OK restarting from clean backup !