Re: Archive files growth!!! - Mailing list pgsql-general

From Craig Ringer
Subject Re: Archive files growth!!!
Date
Msg-id 491D43F7.9020504@postnewspapers.com.au
Whole thread Raw
In response to Archive files growth!!!  (paulo matadr <saddoness@yahoo.com.br>)
List 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

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Granting read-only access to an existing database?
Next
From: Craig Ringer
Date:
Subject: Re: vacuum output question