John McCawley <nospam@xxxxxxxxxxxx> writes: > Don't store your images in the database. Store them on the filesystem and > store their path in the database. Anyone that tells you otherwise is a stark > raving madman :) > > My system is very heavily used, and our pg_dump is only a few gigs. Meanwhile > our images/documents storage is well over a hundred gigs. I'd hate to think > that I'd have to dump and restore 100 gigs every time I wanted to dump the > newest data to the development database. How do you plan your backup routine and how do you guarantee that on a failure all needed data is restored? I mean, how do you handle integrity with data outside the database? -- Jorge Godoy <jgodoy@xxxxxxxxx>
