Scheduled server backup

Dear Mikael,
It would be better and faster to schedule backups of the PostgreSQL database.
You should create a user on the DB that has only read rights on the collect schema, run pg_dump in a cron task to take scheduled backups (if you are running Collect on a Linux machine).
You could write something like this in the crontab to take daily backups:

0 0 * * * pg_dump -U db_user_name collect > /bck/collect/collect_$(date +\%Y\%m\%d\%H\%M\%S).dump

(Replace db_user_name with the name of the user with read rights on the collect DB).
In this example, every day at midnight a dump of the database will be generated.
Also, don't forget that the uploaded pictures are stored by Collect in a folder of the file system (in Linux they will be under ~/OpenForis/Collect/data/collect_upload/, so take care of backing up even them.

I hope it could be useful, let us know, many thanks.
Open Foris Team