On Mon, 2003-11-03 at 06:44, Andrew Ho wrote: > LiveOIO-1.0.6 provides OIO-1.0.6 with 22 pre-built forms, an example > schedule, and several workflows (patient screening and schizophrenia > study). > > Thanks to Tim Churches and Adrian Midgley's strong advocacy, we now have > single-click, database backup and restore of OIO metadata and data via > icons on the Desktop: > > 1) backup (creates /home/knoppix/publicdb.zip) > 2) restore (converts /home/knoppix/publicdb.zip back into publicdb in > PostgreSQL)
Are you just zipping the PG data directories? If so, presumably you are shutting down the database first? Or are you dumping the database to a separate file and zipping that? The latter is much better, because the dump can be imported on a different system. > 3) saveToUSB (copies publicdb.zip to USB storage device) > 4) readFromUSB (copies publicdb.zip from USB to /home/knoppix). > > This means we can create custom demo data and save them to USB storage > device (USB memory sticks are plug-and-play via Knoppix). Forms, > workflows, patient, and other OIO data can be saved and reload back into > PostgreSQL for the next demo session. The same mechanism can also be used > to simplify backup/restore of PostgreSQL database in production > environment (running Knoppix/Debian from hard drive). Only if you shut down the database first. Or if you use the dump command. > An interesting implication is that it is now possible to build OIO > production servers that run entirely from CD-ROM and RAM - with periodic > auto-backup to networked storage or solid state memory, like USB connected > flash drives. You would need to use dump to do this, which allows online backup while the database is still running. PG dump is very fast, so it would be feasible to backup a RAM database every minute or so, provided teh database was not too large. -- Tim C PGP/GnuPG Key 1024D/EAF993D0 available from keyservers everywhere or at http://members.optushome.com.au/tchur/pubkey.asc Key fingerprint = 8C22 BF76 33BA B3B5 1D5B EB37 7891 46A9 EAF9 93D0
signature.asc
Description: This is a digitally signed message part
