On 8/10/13, hamann.w@xxxxxxxxxxx <hamann.w@xxxxxxxxxxx> wrote: > currently the source uses some 20 GB in a database partition and about 700 > GB > in a general data partition. For the database, a diff -e grows to about 10% > of the size > of a full dump in a week > The remote site is a raid box at a hosting center, with paid backup > > Regards > Wolfgang It sounds like you have catastrophic failure covered, but what about data integrity and data security? You may need to 'roll your own' solution, possibly using something like Slony. Having a timestamp field that indicates when the row was inserted or last updated may help. A true incremental backup would IMHO be a very useful tool for database administrators, but there are a number of technical challenges involved, especially dealing with deleted records. -- Mike Nolan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
