Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 17C1564FCF3
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 27 Aug 2008 17:36:32 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 80869-04 for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 27 Aug 2008 17:36:25 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from outbound.icp-qv1-irony-out1.iinet.net.au
	(outbound.icp-qv1-irony-out1.iinet.net.au [203.59.1.108])
	by postgresql.org (Postfix) with ESMTP id 4BBEA64FCDA
	for <pgsql-admin@postgresql.org>; Wed, 27 Aug 2008 17:36:27 -0300 (ADT)
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: Ak0GAOVXtUjL1lpl/2dsb2JhbACIAINrhUGpGYFo
X-IronPort-AV: E=Sophos;i="4.32,281,1217779200"; d="scan'208";a="375146027"
Received: from unknown (HELO mail.outtalimits.com.au) ([203.214.90.101])
	by outbound.icp-qv1-irony-out1.iinet.net.au with ESMTP;
	28 Aug 2008 04:36:24 +0800
Received: from 10.1.1.150 (localhost [127.0.0.1])
	by mail.outtalimits.com.au (Postfix) with ESMTP id 2022E2B6405C;
	Thu, 28 Aug 2008 06:36:24 +1000 (EST)
MIME-Version: 1.0
Date: Thu, 28 Aug 2008 06:36:24 +1000
From: <steve@outtalimits.com.au>
To: windsurferdrew-pg@yahoo.com
Cc: pgsql-admin@postgresql.org
Subject: Re: WAL files during a backup
In-Reply-To: <749976.10730.qm@web36902.mail.mud.yahoo.com>
References: <749976.10730.qm@web36902.mail.mud.yahoo.com>
Message-ID: <7d15abe81b5970cf29b154bb23ac3ed6@127.0.0.1>
X-Sender: steve@outtalimits.com.au
User-Agent: RoundCube Webmail/0.2a
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200808/207
X-Sequence-Number: 30052

00000001000000000000223387  would usually be the next WAL to be written.
How often are you WALs written out?

On Wed, 27 Aug 2008 07:07:17 -0700 (PDT), windsurferdrew-pg@yahoo.com
wrote:
> I have a question regarding the WAL files that are moved during a backup
to
> the "archive directory".
> 
> I have setup the postgresql.conf file to have the following archive
> command:
> 
> archive_command = 'cp -i %p /var/lib/pgsql/backups/%f </dev/null'
> 
> Environment: 
> PG Version 8.1.4
> OS: Linux 2.6.18-8.el5
> 
> After I have run the pg_hotbackup script, the backups directory contains
> only 2 files:
> 1. The gzipped tar file pg_hotbackup_<timestamp>.tar.gz, and
> 2. a WAL file ".backup" file, (for example
> 00000001000000000000223387.0089ED8C.backup)
> 
> The actual WAL file did not get copied to the backups directory. From the
> example above, I would have expected at least 1  WAL file named
> 00000001000000000000223387 to be in the backups directory.
> 
> My questions are:
> 1. Is this normal behavior? (perhaps no activity in the DB to cause a WAL
> file write during the backup?)
> 2. If I try to restore the DB without this WAL file, will the restore
> fail?
> 
> Thanks in advance
> 
> Drew 
> 
> 
>