----- Original Message ----- > From: "Amos Shapira" <[email protected]> > How do you backup databases with that (I'm specifically interested to > hear about PostgresQL)? Snapshot the filesystem every day? > > We have a 300Gb postgres database and growing rapidly, and I'm looking > for better ways to back it up with point in time recovery other than > backing up the transaction logs and periodic full backups.
Filesystem snapshots for databases have an inherent warning that you need to flush the database to disk first of course. backupninja has a pgdump shell frontend that we use for this and it works fine for most people. I don't have a specific recommendation for your large postgres database, as I think what you are doing is the only option. Interested to hear if anyone else has better suggestions. Dave -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
