Postgres Pro
Downloads
Home   >   mailing lists

Re: PITR backup - estimating size - Mailing list pgsql-general

From Fabrízio de Royes Mello
Subject Re: PITR backup - estimating size
Date
Msg-id CAFcNs+qO+DACy8JOwfPwShNrrXLT_tw8-3OqJfUw55OJ3roHtw@mail.gmail.com
Whole thread Raw
In response to PITR backup - estimating size  (Mike Blackwell <mike.blackwell@rrd.com>)
List pgsql-general
Tree view


2012/3/23 Mike Blackwell <mike.blackwell@rrd.com>
I'd like to switch to PITR backups, but have limited disk space.  Is there a way to get a ballpark estimate by monitoring a running system, without actually creating the WAL files and risking filling a filesystem?


Usually each wal segment size is 16MB (16777216 bytes), so you can save this information using "archive_command". Ex:

archive_command = 'du -b %p >> /tmp/xlogsize_history.txt'

Regards,

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Blog sobre TI: http://fabriziomello.blogspot.com

pgsql-general by date:

Previous
From: Mike Blackwell
Date:
Subject: PITR backup - estimating size
Next
From: John R Pierce
Date:
Subject: Re: PostgreSQL 64 Bit XIDs - Transaction IDs