Replies: 6 comments 4 replies
-
|
Hey, thanks for starting this discussion. This is very cool! I'll link to it from the documentation for sure. What you could do, is put the scripts up at https://gist.github.com/. This will allow people to reply to them, and you can edit them too. Cheers, |
Beta Was this translation helpful? Give feedback.
-
|
I run Firefly III using a postgresql database. How easy would it be to create a postgresql version of this backup script? Or to add the steps into the current script with some conditional checks? |
Beta Was this translation helpful? Give feedback.
-
|
I don't use postgreSQL, so I can't test it. Anyway I asked ChatGPT to answer your question. Here is what it gives. Let me know it works or not. |
Beta Was this translation helpful? Give feedback.
-
|
For postgres, I'd recommend to use docker-postgres-backup-local: backups:
image: prodrigestivill/postgres-backup-local:18
restart: always
user: postgres:postgres
depends_on:
- db
env_file:
- db.env
environment:
- POSTGRES_HOST=db
- POSTGRES_PORT=5432
- POSTGRES_EXTRA_OPTS=-Z1 --schema=public --blobs
- SCHEDULE=@daily
- BACKUP_DIR=/backups
- BACKUP_ON_START=TRUE
- BACKUP_KEEP_DAYS=7
- BACKUP_KEEP_WEEKS=4
- BACKUP_KEEP_MONTHS=6
- HEALTHCHECK_PORT=8080
networks:
- firefly_iii
volumes:
- ./backups:/backupsFor mysql, there is a similar project called docker-mysql-cron-backup. |
Beta Was this translation helpful? Give feedback.
-
|
Backup-Firefly-PostgreSQL.sh |
Beta Was this translation helpful? Give feedback.
-
|
Thanks for the scripts! I added a clean step in the restore script in order to drop whatever initial tables firefly created after container creation. Without that restoring failed with multiple errors. These are my final scripts (for PostgreSQL): |
Beta Was this translation helpful? Give feedback.
Uh oh!
There was an error while loading. Please reload this page.
Uh oh!
There was an error while loading. Please reload this page.
-
Support guidelines
Description
Solution
https://gist.github.com/ddyykk/84bc588d6de1d346fbf473af49c34cf0
What are alternatives?
No response
Additional context
No response
Beta Was this translation helpful? Give feedback.
All reactions