Author: e2jk-guest Date: 2013-07-28 08:38:47 +0000 (Sun, 28 Jul 2013) New Revision: 14250
Modified: trunk/packages/gnuhealth/trunk/debian/database-scripts/upgrade/pgsql trunk/packages/gnuhealth/trunk/debian/gnuhealth-server.install Log: Make a backup of the database prior to upgrading and run the pre script provided by upstream Modified: trunk/packages/gnuhealth/trunk/debian/database-scripts/upgrade/pgsql =================================================================== --- trunk/packages/gnuhealth/trunk/debian/database-scripts/upgrade/pgsql 2013-07-27 10:13:41 UTC (rev 14249) +++ trunk/packages/gnuhealth/trunk/debian/database-scripts/upgrade/pgsql 2013-07-28 08:38:47 UTC (rev 14250) @@ -6,16 +6,18 @@ # Source the config file from dbconfig-common . /etc/dbconfig-common/gnuhealth-server.conf -GNUHEALTH_USER="gnuhealth" GNUHEALTH_CONFFILE="/etc/gnuhealth/gnuhealth-server.conf" +BACKUP_FILE="/var/lib/gnuhealth/backups/backup_${dbc_dbname}_`date +\%F_\%H-\%M-\%S`.sql" # Start printing output on a new line echo -#TODO: this has not yet been tested. Will be done when packaging the version -# after 1.8.1 +# Make a backup of the database prior to upgrading +sudo -u ${dbc_dbuser} pg_dump gnuhealth > ${BACKUP_FILE} +# Run the pre script provided by upstream +sudo -u ${dbc_dbuser} python /usr/share/gnuhealth/scripts/upgrade/2.0/pre.py --pg="dbname=${dbc_dbname}" # Upgrade the gnuhealth database -sudo -u ${GNUHEALTH_USER} trytond --database=gnuhealth --update=all --config=${GNUHEALTH_CONFFILE} +sudo -u ${dbc_dbuser} trytond --database=${dbc_dbname} --update=all --config=${GNUHEALTH_CONFFILE} exit 0 Modified: trunk/packages/gnuhealth/trunk/debian/gnuhealth-server.install =================================================================== --- trunk/packages/gnuhealth/trunk/debian/gnuhealth-server.install 2013-07-27 10:13:41 UTC (rev 14249) +++ trunk/packages/gnuhealth/trunk/debian/gnuhealth-server.install 2013-07-28 08:38:47 UTC (rev 14250) @@ -1,4 +1,5 @@ debian/gnuhealth-server.conf etc/gnuhealth debian/database-scripts/install usr/share/dbconfig-common/scripts/gnuhealth-server debian/database-scripts/upgrade usr/share/dbconfig-common/scripts/gnuhealth-server +scripts/upgrade/2.0/pre.py usr/share/gnuhealth/scripts/upgrade/2.0 _______________________________________________ debian-med-commit mailing list debian-med-commit@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/debian-med-commit