On 02/05/2014 11:30 AM, Soha wrote:
Please help me fix this issue as it is a major issue for us now. I think
there is no way to retrieve the deleted report.
Sure there is - you restore it from the nightly DB snapshot you made
either by copying the sqlite DB, or using pg_dump. Here is an example
postgres backup script:
#!/bin/bash
if [ `whoami` != 'postgres' ]; then
echo "Please run this as user postgres";
exit 255;
fi
FILE=$(mktemp /opt/trac/eng/db/postgres.bak.`date +%F`.XXXXXXXXXX)
if [ "$?" -eq "0" ]; then
pg_dump trac > $FILE && lzma $FILE;
fi
cron that bad Larry, and you're good to go.
(And, if you're not doing this, you must enjoy living dangerously.)
--
Matthew Caron, Software Build Engineer
Red Lion Controls | www.redlion.net
+1 (518) 877-5173 x138 office
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/trac-users.
For more options, visit https://groups.google.com/groups/opt_out.
