One possible answer to your issues is data partitioning. By partitioning your data by date or primary key or some other field, you can backup individual partitions for incremental backups. I run a stats database that partitions by day daily and we can just backup yesterday's partition each night. Each partition is in the 10 to 20 meg size range.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
