Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id B3D3A2E005B
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 21 Feb 2008 19:23:37 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 51353-06 for <pgsql-admin-postgresql.org@postgresql.org>;
	Thu, 21 Feb 2008 19:23:24 -0400 (AST)
Received: from mail.internode.com.au (mail.internode.com.au [192.83.231.27])
	by postgresql.org (Postfix) with ESMTP id 44FF12E00BD
	for <pgsql-admin@postgresql.org>; Thu, 21 Feb 2008 19:23:28 -0400 (AST)
Received: from [172.16.0.221] (staffnet.internode.com.au [203.26.95.65])
	by mail.internode.com.au (8.13.7/8.12.1) with ESMTP id m1LNNPlx017699
	for <pgsql-admin@postgresql.org>; Fri, 22 Feb 2008 09:53:26 +1030 (CST)
Message-ID: <47BE07ED.1070802@internode.com.au>
Date: Fri, 22 Feb 2008 09:53:25 +1030
From: Shilpa Sudhakar <ssudhakar@internode.com.au>
User-Agent: Thunderbird 1.5.0.14 (Windows/20071210)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: WAL archiving
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: ClamAV version 0.91.2, clamav-milter version 0.91.2 on mail
X-Virus-Status: Clean
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/256
X-Sequence-Number: 28330

Hi All,

I am new to postgres and have been slowly learning the concepts.

Regarding WAL archiving, we first take a base backup and then save all 
the wal logs for PITR.

Both the base backup and wal logs are stored in another disk.

Since the wal logs keep increasing, do we take the base backup every now 
and then so that we can delete the old log files?
How often do we take a base filesystem backup keeping in mind that our 
systems are 24 x 7.

Any suggestions are appreciated.

Thanks and Regards,
Shilpa