In this guide we'll describe some usefult scripts we added to our repo. We don't explain how create a secure installation of Drupal, because every usercase needs a personal installation. If you need help, please write to our mailing list (gruppo-web at ubuntu-it dot org)
In scripts/ folder there is a script called backup.sh
You can use it to backup your database, if your installation is based on Postgresql
You have to specify the folder where backups have to be saved and the name of the database. The script uses pg_dump. Suggestion: indicate the complete path.
Use as ./backup.sh ~/backupFolder databaseName
If you need to share the dump of your database, remove before private informations with sql_scrub_dump.sh, in the root directory
It's a script to create a scrubbed version of a pgsql 9.x database dump using a temp database as intermediary.
You need a file named 'scrub.sql' with querys to scrub the db. We added one for our needs, check if all private dare are deleted before share your dump
Use as ./sql_scrub_dump.sh dump_file_input.tar.gz dump_file_output.tar.gz
Of course you need to launch it with a user which has a role to create database in Postgresql
Update the installation
We take this installation as update as we can. As soon a new Drupal version is released, we test it and update the repo. You need to run git to update your installation of, if you prefer, you can ask us a git hook (TBD)