Re: Archive files growth!!!

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: paulo matadr <saddoness(at)yahoo(dot)com(dot)br>
Cc: GENERAL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Archive files growth!!!
Date: 2008-11-14 09:25:11
Message-ID: 491D43F7.9020504@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

paulo matadr wrote:
> How the best way to controling fast growth in my Database.

I'm going to assume, based on the config info you quoted and the subject
line, that you mean controlling the size of the archived WAL files on
the warm standby server. If that assumption is incorrect, you might want
to reply with a bit more detail about your problem.

If so, one option may be to use pg_clearxlogtail to zero the unused
portions of the backup copies of your WAL files then compress them with
(eg) gzip. Make sure to TEST YOUR BACKUPS.

--
Craig Ringer

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-11-14 09:33:57 Re: vacuum output question
Previous Message Richard Huxton 2008-11-14 09:17:05 Re: Granting read-only access to an existing database?