Hi, In the company, we're facing with serious disk space problems which is not caused by PostgreSQL, but the nature of our data. Database sizes are around 200-300GB, which is relatively not that much, but databases require strict backup policies: - Incremental backup for each day. (250GB) - Full backup for each week of the last month. (4 x 250GB) - Full backup for each month of the last year. (12 x 250GB) As a result, we require a space of size (roughly) 250 + 4x250 + 12x250 = 17x250 = 4250GB = 4.15TB for each server per year. Considering we have ~15 servers, 15x4250 = 63750 = 62.25TB as can be seen, growth of the backed up data sizes have almost no relations with the actual data sizes. At the moment, we're using tape drive cartridges for weekly and monthly backups. But the incremental backups, plus the database itself requires a constant space of size ~500GB. To summarize, as a DBA most of my time is wasting with validating if the backup policies performed right, cartridges captioned correctly, etc. What are your experiences with similar sizes of data? How do you cope with backups? Do you recommend any other hardware/software solutions? Regards. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
