Re: Significant backup routine bug found in 1.3.x

["David A. Bandel" <..hidden..>]

On Fri, Nov 25, 2011 at 05:19, Chris Travers <..hidden..> wrote:
> Hi all;
>
> For all of you using LedgerSMB 1.3 in production, please note that the
> backup routines that come as part of LedgerSMB were apparently broken
> by a number of framework changes between 1.2 and 1.3.  They currently
> do not produce valid backups.  Backups with standard PostgreSQL tools
> (pg_dump and pg_dumpall) work properly, so while significant,
> workarounds exist.
>

For those of you running Debian or derivatives (Ubuntu, et. al.), I
personally recommend (and use) autopostgresqlbackup (apt-get install
autopostgresqlbackup).

> The problems include, among other things, the fact that users of the
> software typically do not have sufficient permissions to create
> backups.  Given this and other changes I have decided to rewrite the
> database backup routines rather than try to get the existing
> functionality working.
>
> We expect to have a fix in place for 1.3.7, which will be due to be
> released this next week.  In the mean time, if you want to backup your
> database, please use the above-mentioned tools.
>
> The new backup routines will be included in the database
> administration utility (setup.pl) and will be run from there.  You
> will need to run one backup of roles for all db's plus a backup of
> each individual db you want to back up.  This can be done by database
> administrators who have no valid LedgerSMB login.
>
> Best Wishes,
> Chris Travers
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>


David A. Bandel
-- 
Two things are infinite: the universe and human stupidity; and I'm not
sure about the the universe. -- Albert Einstein
Visit my web page at: http://david.bandel.us/