Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 77CE52E00C4
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 22 Feb 2008 03:35:09 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 07229-08 for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 22 Feb 2008 03:35:06 -0400 (AST)
Received: from el-out-1112.google.com (el-out-1112.google.com
 [209.85.162.178])
	by postgresql.org (Postfix) with ESMTP id 368932E00E8
	for <pgsql-admin@postgresql.org>; Fri, 22 Feb 2008 03:35:06 -0400 (AST)
Received: by el-out-1112.google.com with SMTP id r27so342269ele.5
	for <pgsql-admin@postgresql.org>; Thu, 21 Feb 2008 23:35:05 -0800 (PST)
Received: by 10.150.146.14 with SMTP id t14mr3536467ybd.122.1203665705230;
	Thu, 21 Feb 2008 23:35:05 -0800 (PST)
Received: by 10.70.95.13 with HTTP; Thu, 21 Feb 2008 23:35:05 -0800 (PST)
Message-ID: <f6fdfb550802212335q2579120ah5f521d12d49ae36b@mail.gmail.com>
Date: Fri, 22 Feb 2008 10:35:05 +0300
From: "Vladimir Rusinov" <vladimir@greenmice.info>
To: "Shilpa Sudhakar" <ssudhakar@internode.com.au>
Subject: Re: WAL archiving
Cc: pgsql-admin@postgresql.org
In-Reply-To: <47BE07ED.1070802@internode.com.au>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_5977_11465465.1203665705171"
References: <47BE07ED.1070802@internode.com.au>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200802/267
X-Sequence-Number: 28341

------=_Part_5977_11465465.1203665705171
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 2/22/08, Shilpa Sudhakar <ssudhakar@internode.com.au> wrote:
>
> 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.


Not exactly.
1. adjust acrhive_command to save wal's to backup dir
2. execute SELECT pg_start_backup('lable')
3. copy database files
4. execute SELECT pg_stop_backup()

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?


Yes, but do not delete old files until the new backup was successfully
finished.

How often do we take a base filesystem backup keeping in mind that our
> systems are 24 x 7.


It depends on your diskspace & load.

Any suggestions are appreciated.


Read the manual. It's pretty good & explains almost everything.

-- 
Vladimir Rusinov
Voronezh, Russia
UNIX Admin @ Murano Software

------=_Part_5977_11465465.1203665705171
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br><br><div><span class="gmail_quote">On 2/22/08, <b class="gmail_sendername">Shilpa Sudhakar</b> &lt;<a href="mailto:ssudhakar@internode.com.au">ssudhakar@internode.com.au</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I am new to postgres and have been slowly learning the concepts.<br> <br> Regarding WAL archiving, we first take a base backup and then save all<br> the wal logs for PITR.</blockquote><div><br>Not exactly.<br>1. adjust acrhive_command to save wal&#39;s to backup dir<br>
2. execute SELECT pg_start_backup(&#39;lable&#39;)<br>3. copy database files<br>4. execute SELECT pg_stop_backup()<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
 Both the base backup and wal logs are stored in another disk.<br> <br> Since the wal logs keep increasing, do we take the base backup every now<br> and then so that we can delete the old log files?</blockquote><div><br>Yes, but do not delete old files until the new backup was successfully finished.<br>
</div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> How often do we take a base filesystem backup keeping in mind that our<br> systems are 24 x 7.</blockquote>
<div><br>It depends on your diskspace &amp; load.<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Any suggestions are appreciated.</blockquote>
<div><br>Read the manual. It&#39;s pretty good &amp; explains almost everything.<br></div></div><br>-- <br>Vladimir Rusinov<br>Voronezh, Russia<br>UNIX Admin @ Murano Software

------=_Part_5977_11465465.1203665705171--