I have a database running on postgres (8.4) and I want regular backups of parts of that data. We have very important data of which we need regular backups in case the hardware catches fire. But the same database contains a huge amount of binary data for each entry that grows really fast (easily more than a GB per day). Now, this data is not as critical. If we lose it, it is of course annoying, but it would be acceptable.
Is there an easy way to backup some of our tables with postgres, or do I have to manually write queries to copy everything somewhere before I can pgdump it?
Bonus: If the big binary table could just backup the last X entries, that would be perfect, but I am pretty sure I will have to do something as complex as this manually anway.