Message-ID: <59237.192.168.207.54.1432042174.squirrel@webmail.etecsa.cu>
In-Reply-To: 
 <A737B7A37273E048B164557ADEF4A58B36612994@ntex2010i.host.magwien.gv.at
 >
References: <5FB35597-0F52-4832-973D-908F5B01BE9B@bekk.no>
 <A737B7A37273E048B164557ADEF4A58B36612994@ntex2010i.host.magwien.gv.at>
Date: Tue, 19 May 2015 08:29:34 -0500 (GMT+5)
Subject: Re: Deleting old WAL-files
From: "Gilberto Castillo" <gilberto.castillo@etecsa.cu>
To: "Albe Laurenz" <laurenz.albe@wien.gv.at>
Cc: "'Gustav Karlsson  *EXTERN*'" <gustav.karlsson@bekk.no>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Reply-To: gilberto.castillo@etecsa.cu
User-Agent: SquirrelMail/1.4.8-5.el5_4.10
MIME-Version: 1.0
Importance: Normal
Content-Type: multipart/mixed; boundary="=t8T7eSCm58841=imx3.etecsa.cu="
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is a multi-part message in MIME format.

--=t8T7eSCm58841=imx3.etecsa.cu=
Content-Disposition: inline
Content-Type: text/plain;charset=utf-8
Content-Transfer-Encoding: 8bit


> Gustav Karlsson wrote:
>> I am looking for a good method of determining what WAL-segments can be
>> deleted from our backup-
>> archive.
>>
>> We are using Postgresql 9.3 and do nightly basebackups along with
>> archiving of WAL-segments.
>>
>> We would like to prevent our backup-archive from growing forever, and
>> thus delete basebackups and WAL-
>> segments older than say 1 year.
>>
>> Is there a good way of finding the oldest WAL-segment needed for a given
>> basebackup? (If not, what is
>> the typical method for deleting old WAL-segments?)
>
> The backup contains a file "backup_label" which contains a line like
>
> START WAL LOCATION: 0/83000028 (file 000000010000000000000083)
>
> That is the oldest file needed for recovery.
>
> But a simple solution would be to keep WAL archives for one day more than
> your oldest
> base backup, that way you can never miss a WAL archive that you need.

See you:

http://www.postgresql.org/docs/current/static/pgarchivecleanup.html


Saludos,
Gilberto Castillo
ETECSA, La Habana, Cuba

--=t8T7eSCm58841=imx3.etecsa.cu=
Content-Type: text/plain
Content-Disposition: inline

--- 
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>

--=t8T7eSCm58841=imx3.etecsa.cu=
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--=t8T7eSCm58841=imx3.etecsa.cu=--