Replies: 1 comment 1 reply
-
Only supported way is described here https://docs.teslamate.org/docs/maintenance/upgrading_postgres |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
I saw the other thread on this topic, but posting a separate one here since the upgrade process is different on unRAID from my understanding and I would like some help from those that are familiar.
i upgraded postgresql from 15 to 17 using the commands below, referencing this process for immich and this video by the same author.
(on pqsql 15 container console)
pg_dump -U DBUSERNAME -h IPADDRESS -p PORT -fc -f /var/lib/postgresql/data/teslamate.dump DBNAME
(on pqsql 17 container console)
pg_restore -U DBUSERNAME -h IPADDRESS -p PORT -d DBNAME /var/lib/postgresql/data/teslamate.dump
I also have integration via MQTT on home assistant, and can see certain data that way, and teslamate webgui also seems to be loading fine. However, when trying to access any dashboards via grafana, several errors show up in the postgres logs around "invalid input syntax for type json" and also "syntax error at or near "AND"" errors"
Here's what the log of the postgres 17 container looks like when accessing grafana dashboards (uploading as text to avoid posting extremely long comment)
postgres17_log.txt
Beta Was this translation helpful? Give feedback.
All reactions