Backup Policy & Disk Space Issues

From: Volkan YAZICI <yazicivo(at)ttmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Backup Policy & Disk Space Issues
Date: 2008-12-22 08:07:21
Message-ID: 87ocz4bpl2.fsf@alamut.mobiliz.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2008-12-22 10:44:15 Re: How are locks managed in PG?
Previous Message Scott Marlowe 2008-12-22 04:41:16 Re: How are locks managed in PG?