On Dec 7, 7:37 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > why 1 over 2?
The simple answer is that csv files are only about saving data, and may involve conversions at that; [1] - by using a native database backup, do not risk conversion effects, and perhaps more to the point will include backup of things that web2py cannot backup, e.g. meta-data for the db (e.g. permissions, logins, etc.) Whenever backing up, use the closest to the "original" source to backup as possible. It's the same reason a disk image is more likely to work like the original than a file-system based backup of an operating system environment. - Yarko > > -Thadeus > > > > On Mon, Dec 7, 2009 at 6:47 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > > I suggest > > > 1) Use the backend database built-in backup utilities (such as > > postgres > > pg-dump), using cron to tar.gz the files and put them in their > > respective locations. > > > if available else: > > > 2) Use web2py cron, using export_to_csv file, and then tarfile to > > compress and then save the file in its correct location, all from > > within web2py > > > On Dec 7, 3:52 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > >> What would the preferred method of data backup be? > > >> * Use web2py cron, using export_to_csv file, and then tarfile to > >> compress and then save the file in its correct location, all from > >> within web2py? > >> * Use the backend database built-in backup utilities (such as postgres > >> pg-dump), using cron to tar.gz the files and put them in their > >> respective locations. > >> * Use a filesystem level backup, backing up the actual database files on > >> disk. > >> * Use online backup with PITR (as noted in the postgres > >> manual:http://www.postgresql.org/docs/8.1/static/backup-online.html) > > >> -Thadeus > > > -- > > > You received this message because you are subscribed to the Google Groups > > "web2py-users" group. > > To post to this group, send email to web...@googlegroups.com. > > To unsubscribe from this group, send email to > > web2py+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/web2py?hl=en. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.