[GENERAL] Best practice for file storage?

2010-01-31 Thread Joe Kramer
Hi, I need to store a lot of large files (thousands of 10-100 MB files) uploaded through my web application and I find that storing them in database as bytea field is not practical for backup purposes. My database has full backup performed every 12 hours and backup is encrypted and copied to

Re: [GENERAL] Best practice for file storage?

2010-01-31 Thread Mark Morgan Lloyd
Joe Kramer wrote: Hi, I need to store a lot of large files (thousands of 10-100 MB files) uploaded through my web application and I find that storing them in database as bytea field is not practical for backup purposes. My database has full backup performed every 12 hours and backup is

Re: [GENERAL] Best practice for file storage?

2010-01-31 Thread Craig Ringer
On 31/01/2010 6:46 PM, Joe Kramer wrote: Hi, I need to store a lot of large files (thousands of 10-100 MB files) uploaded through my web application and I find that storing them in database as bytea field is not practical for backup purposes. My database has full backup performed every 12

Re: [GENERAL] Best practice for file storage?

2010-01-31 Thread Andy Colson
On 01/31/2010 04:46 AM, Joe Kramer wrote: Hi, I need to store a lot of large files (thousands of 10-100 MB files) uploaded through my web application and I find that storing them in database as bytea field is not practical for backup purposes. My database has full backup performed every 12

Re: [GENERAL] Best practice for file storage?

2010-01-31 Thread Steve Atkins
On Jan 31, 2010, at 2:46 AM, Joe Kramer wrote: Hi, I need to store a lot of large files (thousands of 10-100 MB files) uploaded through my web application and I find that storing them in database as bytea field is not practical for backup purposes. My database has full backup performed