Re: [GENERAL] Backup strategies with significant bytea data

2010-01-13 Thread Leigh Dyer
Ivan Voras wrote: > Leigh Dyer wrote: >> Hi, >> >>For years now I've simply backed up my databases by doing a nightly >>pg_dump, but since we added the ability for users to import binary files >>in to our application, which are stored in a bytea fields, the d

[GENERAL] Backup strategies with significant bytea data

2010-01-11 Thread Leigh Dyer
Hi, For years now I've simply backed up my databases by doing a nightly pg_dump, but since we added the ability for users to import binary files in to our application, which are stored in a bytea fields, the dump sizes have gone through the roof — even with gzip compression, they're significantly

[GENERAL] Multiple clusters on one box for PITR

2007-12-11 Thread Leigh Dyer
Hi all, I run a PostgreSQL 8.1 server that hosts two main applications -- both web-based OLTP-type work -- with a few databases for each. I'm currently using pg_dump for backups, but the clients for one of the applications we're hosting as asked to be moved to PITR because they like the idea o