Feature Request: Importing and exporting backup data.

[cuicui-V5]

Describe the feature

Provide an option to export backup files of Maybe, and import them into another instance of Maybe for restoring all data.

Why is this feature important?

This is a very important feature for a financial software, as directly backing up the database might be more challenging.

Additional context, screenshots, and relevant links

No response

[orelvis15]

It would help us transfer data from one system to another, for example I have a local docker and I want to transfer my data to the cloud, what occurs to me is to upload all the CSVs again.

[mikr13]

For now you can export psql dump & import it there on cloud if self hosted

[followingell]

@mikr13 What would be the command to do the above using the default values provided in the repo?

docker exec -t maybe-postgres-1 pg_dump -U DEFAULT_USERNAME DEFAULT_DATABASE_NAME > /path/to/local/backup.sql?

[mikr13]

Yes, just need to add one more flag: --format=custom this creates a binary that can be imported using pg_restore @followingell

[pkress]

Just wanted to add my perspective to this feature request in the hosted version. I want to build my own dashboard to budget by analyzing the data that maybe so helpfully aggregates from all my financial sources, so being able to export from the hosted (or hit an api) would be a great feature to allow better digging into my financial health.