matt-FFFFFF / hassio-addon-teslamate

Teslamate addon for Home Assistant
MIT License
68 stars 22 forks source link

Feature Request - Instruction for manually fixing data #82

Open Chimpepe opened 1 year ago

Chimpepe commented 1 year ago

Hey Guys, is it possible to get instructions on how to fix data manually on this add-on?

This is the original TeslaMate Instruction: (https://docs.teslamate.org/docs/maintenance/manually_fixing_data)

In my case the Geofence data from TeslaMate is not transferred to Grafana when adding the charge point while it is charging.

Thank you and keep up the gorgeous work!

matt-FFFFFF commented 1 year ago

You can install pgAdmin and connect to the database using the credentials supplied in the addon.

To do this map the port in the postgres addon so that you can connect to it on your home assistant IP address.

Chimpepe commented 1 year ago

Hi Matt, thank you very much for the answer!

One more question.

Could you give me a step by step guide on how to export the data to import it into a standalone Teslamate version?

I know that's not really your problem. I'm sorry that I'm annoying you with this.

But I don't really have experience with it and a step by step guide would be really great!

Thank you!

matt-FFFFFF commented 1 year ago

Hi,

In brief:

Install pgAdmin on your device (not Home Assistant), your PC/laptop.

In Home Assistant, modify the Postgres addon's configuration to expose TCP port 5432:

image

Save, then restart the Postgres addon.

Now from pgAdmin, connect to the database by specifying the IP address of your home assistant instance, the port number 5432, and the username and password in the postgres addon's configuration.

See this for more information on how to backup a database using pgAdmin. You should be able to cross reference this with the TeslaMate guide https://www.pgadmin.org/docs/pgadmin4/development/backup_dialog.html