Upgrade TeslaMate from Version 1.33.0 to 2.0.0 on Synology NAS

[Amourgo]

TeslaMate Project GitHub Release v2.0.0

PostgreSQL 14 --->17 .

Note

Environment Info
Device Model: Synology DS218+
DSM Version: DSM 7.2.1-69057 Update 7
TeslaMate Version: 1.33.0
Database Version: PostgreSQL 14

Tip

Upgrade Steps:
1. Backup data → 2. Upgrade PostgreSQL → 3. Upgrade TeslaMate → 4. Verify services

1. Backup Data

Important

Backup procedures can be found in the official TeslaMate backup guide.

1.1 Backup PostgreSQL Data

• Navigate to teslamate directory

cd /volume1/docker/teslamate/

• Export backup in .bck format

docker-compose exec -T database pg_dump -U teslamate teslamate > /volume1/docker/teslamate/teslamate.bck

• Export backup in .sql format

docker exec teslamate-database-1 pg_dump -U teslamate -W teslamate > /volume1/docker/teslamate/backup/teslamate_$(date +%Y%m%d).sql

1.2 Save Backup Data to Local

Ensure the backup files are saved offline. Data is invaluable.

2. Upgrade PostgreSQL

Caution

Proceed with caution – data is invaluable
Make sure your backup can be restored before continuing.

2.1 Stop All TeslaMate Containers

docker-compose down

2.2 Delete PostgreSQL Volume

Warning

WARNING: This will delete all previously recorded data! Ensure backups can be restored.

docker volume rm "$(basename "$PWD")_teslamate-db"

2.3 Upgrade PostgreSQL Version

• Edit docker-compose.yml to change the PostgreSQL image

database:
  image: postgres:17
  restart: always
  environment:
    - POSTGRES_USER=teslamate
    - POSTGRES_PASSWORD=XXXXXXXXX
    - POSTGRES_DB=teslamate
    - TZ=Asia/Shanghai
  volumes:
    - teslamate-db:/var/lib/postgresql/data

• Start PostgreSQL container

docker-compose up -d database

2.4 Restore PostgreSQL Backup Data

• Stop TeslaMate container

docker-compose stop teslamate

• Initialize the PostgreSQL database

docker-compose exec -T database psql -U teslamate teslamate << .
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;
CREATE EXTENSION cube WITH SCHEMA public;
CREATE EXTENSION earthdistance WITH SCHEMA public;
.

• Restore backup

docker-compose exec -T database psql -U teslamate -d teslamate < /volume1/docker/teslamate/teslamate.bck

2.5 Restart PostgreSQL Container

docker-compose up -d database

3. Upgrade TeslaMate

3.1 Pull Latest TeslaMate Image

docker-compose pull

3.2 Restart TeslaMate Container

docker-compose up -d

4. Verify Services

Check if TeslaMate containers are running and if the TeslaMate web portal is accessible.

Update Log Example

Using terminal commands to modify system configs, execute external binary
files, add files, or install unauthorized third-party apps may lead to system
damages or unexpected behavior, or cause data loss. Make sure you are aware of
the consequences of each command and proceed at your own risk.

Warning: Data should only be stored in shared folders. Data stored elsewhere
may be deleted when the system is updated/restarted.

amour@DS218:~$ sudo -i
Password:
root@DS218:~# cd /volume1/docker/teslamate/
root@DS218:/volume1/docker/teslamate# docker exec teslamate-database-1 pg_dump -U teslamate -W teslamate > /volume1/docker/teslamate/backup/teslamate_$(date +%Y%m%d).sql
Password:
JHGJa2sNbAkGXn
root@DS218:/volume1/docker/teslamate# JHGJa2sNbAkGXn
-ash: JHGJa2sNbAkGXn: command not found
root@DS218:/volume1/docker/teslamate# docker-compose exec -T database pg_dump -U teslamate teslamate > /volume1/docker/teslamate/backup/`date +%Y%m%d%H%M%S`_teslamate.bck
root@DS218:/volume1/docker/teslamate# docker-compose exec -T database pg_dump -U teslamate teslamate > /volume1/docker/teslamate/teslamate.bck
root@DS218:/volume1/docker/teslamate# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
502d17b36f1c teslamate/teslamate:latest "tini -- /bin/sh /en…" 8 weeks ago Up 8 weeks 0.0.0.0:4000->4000/tcp, :::4000->4000/tcp teslamate-teslamate-1
c94880ba3a22 teslamate/grafana:latest "/run.sh" 8 weeks ago Up 8 weeks 0.0.0.0:3000->3000/tcp, :::3000->3000/tcp teslamate-grafana-1
5dedd7068282 eclipse-mosquitto:2 "/docker-entrypoint.…" 8 weeks ago Up 8 weeks 0.0.0.0:1883->1883/tcp, :::1883->1883/tcp teslamate-mosquitto-1
8e4687523b8f postgres:14 "docker-entrypoint.s…" 8 weeks ago Up 8 weeks 5432/tcp teslamate-database-1
root@DS218:/volume1/docker/teslamate# docker-compose down
[+] Running 5/5
⠿ Container teslamate-grafana-1 Removed
⠿ Container teslamate-mosquitto-1 Removed
⠿ Container teslamate-teslamate-1 Removed
⠿ Container teslamate-database-1 Removed
⠿ Network teslamate_default Removed
root@DS218:/volume1/docker/teslamate# docker volume rm "$(basename "$PWD")_teslamate-db"
teslamate_teslamate-db
root@DS218:/volume1/docker/teslamate# docker-compose up -d database
[+] Running 15/15
⠿ database Pulled 57.2s
⠿ 61320b01ae5e Pull complete 35.7s
⠿ 3db9b37be7c3 Pull complete 36.8s
⠿ e9a82aed48d7 Pull complete 37.6s
⠿ 7c852ebdd63e Pull complete 38.1s
⠿ 28708ff4e046 Pull complete 39.3s
⠿ 6ce13d85dabe Pull complete 39.9s
⠿ bd1fa28722bb Pull complete 40.2s
⠿ 410cd7ec9a40 Pull complete 40.5s
⠿ 475b0e32b814 Pull complete 52.0s
⠿ e7aba16d6a5e Pull complete 53.7s
⠿ 89ba8b615fa9 Pull complete 54.0s
⠿ 82697a7976df Pull complete 54.3s
⠿ 7e11eb1421f3 Pull complete 54.6s
⠿ 2bb588ce4e67 Pull complete 54.8s
[+] Running 3/3
⠿ Network teslamate_default Created 0.7s
⠿ Volume "teslamate_teslamate-db" Created 0.1s
⠿ Container teslamate-database-1 Started 2.1s
root@DS218:/volume1/docker/teslamate# docker-compose stop teslamate
root@DS218:/volume1/docker/teslamate# docker-compose exec -T database psql -U teslamate teslamate << .
> DROP SCHEMA public CASCADE;
> CREATE SCHEMA public;
> CREATE EXTENSION cube WITH SCHEMA public;
> CREATE EXTENSION earthdistance WITH SCHEMA public;
> .

DROP SCHEMA
CREATE SCHEMA
CREATE EXTENSION
CREATE EXTENSION
root@DS218:/volume1/docker/teslamate# docker-compose exec -T database psql -U teslamate -d teslamate < /volume1/docker/teslamate/teslamate.bck

SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
CREATE EXTENSION
COMMENT
CREATE EXTENSION
COMMENT
CREATE TYPE
ALTER TYPE
CREATE TYPE
ALTER TYPE
CREATE TYPE
ALTER TYPE
CREATE TYPE
ALTER TYPE
CREATE TYPE
ALTER TYPE
CREATE TYPE
ALTER TYPE
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
CREATE FUNCTION
ALTER FUNCTION
SET
SET
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
COPY 826
COPY 1
COPY 1
COPY 109128
COPY 299
COPY 5637
COPY 171
COPY 13616089
COPY 94
COPY 1
COPY 6971
COPY 1
COPY 21
setval
--------
826
(1 row)
setval
--------
1
(1 row)
setval
--------
1
(1 row)
setval
--------
109128
(1 row)
setval
--------
299
(1 row)
setval
--------
182
(1 row)
setval
----------
13616121
(1 row)
setval
--------
1
(1 row)
setval
--------
11406
(1 row)
setval
--------
1
(1 row)
setval
--------
6362
(1 row)
setval
--------
21
(1 row)
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
root@DS218:/volume1/docker/teslamate# docker-compose pull
[+] Running 28/28
⠿ teslamate Pulled 73.6s
⠿ 8a628cdd7ccc Pull complete 49.4s
⠿ ed2076f20d03 Pull complete 50.6s
⠿ 8c8ca1151c4c Pull complete 51.5s
⠿ ce216533c7a2 Pull complete 52.0s
⠿ 3be5db24255e Pull complete 67.6s
⠿ fe44939c2ce4 Pull complete 69.1s
⠿ database Pulled 4.2s
⠿ grafana Pulled 74.5s
⠿ f18232174bc9 Already exists 0.0s
⠿ dd95f48fea40 Pull complete 5.2s
⠿ d8720f512857 Pull complete 10.8s
⠿ 1726751e7b2a Pull complete 26.1s
⠿ ef69f5a407da Pull complete 26.6s
⠿ 48a0b989eb4b Pull complete 27.0s
⠿ 5292e3126d0d Pull complete 49.8s
⠿ 1e545566de31 Pull complete 60.7s
⠿ 51b5579032bc Pull complete 63.6s
⠿ 55e463089067 Pull complete 64.0s
⠿ 6704e5f4b681 Pull complete 64.5s
⠿ b224a2d5e79d Pull complete 65.0s
⠿ d355a9fdf596 Pull complete 65.4s
⠿ 3e91fc86516e Pull complete 65.9s
⠿ 6f680a227fe8 Pull complete 67.0s
⠿ 495928fed2e7 Pull complete 68.2s
⠿ bf99d1f7e253 Pull complete 68.9s
⠿ 201936771044 Pull complete 70.0s
⠿ mosquitto Pulled 4.0s
root@DS218:/volume1/docker/teslamate# docker-compose up -d
[+] Running 4/4
⠿ Container teslamate-grafana-1 Started
⠿ Container teslamate-mosquitto-1 Started
⠿ Container teslamate-teslamate-1 Started
⠿ Container teslamate-database-1 Running
root@DS218:/volume1/docker/teslamate#

[Amourgo]

✅The upgrade has been successfully tested.

[SpikeXp]

Worked perfectly PostgreSQL 15 --->17.
Thank you !

[JakobLichterfeld]

docker-compose is deprecated since years and confimred not working with TeslaMAte. You must use docker compose