[ADMIN] Monitoring database for changes - backup purposes

k any one schema up if it has changed since it was last backed up. Is there any way to do this? Is there a checksum function or something that I could use? Thanks, Chris -- Chris Jewell, BSc(Hons), BVSc, MRCVS Dept of Maths and Statistics Fylde College Lancaster University Lancaster Lancs LA

Re: [ADMIN] Monitoring database for changes - backup purposes

Hi, Yes, diff would work and is my current plan, but it requires me to perform the backup first. What I needed really was a system by which a backup would only be run if there was something that needed backing up. Thanks anyway, Chris -- Chris Jewell, BSc(Hons), BVSc, MRCVS Dept of Maths

[ADMIN] Migrating tables to schemas

't want to erase all my users' views. Thus, my question is: can I migrate the views such that they point to the new tables in the users' schemata, and/or how do I drop the public schema tables without dropping the users' views? Thanks, Chris -- -- Chris Jewell, BSc(Hons),

[ADMIN] Backup - filesystem snapshots

it finishes its current transaction and queues any other transactions while the snapshot is taking place? Any other ideas of how I can create such snapshots? Thanks, Chris -- Chris Jewell Dept of Maths and Statistics Fylde College Lancaster University Lancaster Lancs LA1 4YF ---

Re: [ADMIN] Backup - filesystem snapshots

ne to protect users from themselves since we're running a RAID mirroring system - hence the PITR for a given user (as opposed to for the whole database). Chris Jewell wrote: > Hi, > > I'm trying to implement a backup strategy for a research database in > order to preve

[ADMIN] WAL log archive frequency

whether or not it is a full 16MB? Our database changes so infrequently at the moment that I'm worried that these small changes may not be backed up regularly by the PITR system. Thanks, Chris -- Chris Jewell, BSc(Hons), BVSc, MRCVS Dept of Maths and Statistics Fylde College Lancaster Unive