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 trac-users+unsubscr...@googlegroups.com.
To post to this group, send email to trac-users@googlegroups.com.
Visit this group at http://groups.google.com/group/trac-users.
For more options, visit https://groups.google.com/groups/opt_out.
