Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 7E64D64FCBA for ; Wed, 27 Aug 2008 11:07:26 -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 99191-07 for ; Wed, 27 Aug 2008 11:07:14 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web36902.mail.mud.yahoo.com (web36902.mail.mud.yahoo.com [209.191.85.70]) by postgresql.org (Postfix) with SMTP id D3F77650014 for ; Wed, 27 Aug 2008 11:07:19 -0300 (ADT) Received: (qmail 10762 invoked by uid 60001); 27 Aug 2008 14:07:17 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=K0s4iNUMVG3GqZr3rMLGuIgXaSdq5b1DJSUKc9YQfYIcO/nQXlF1Nsz8DmP1EP6k4+rou8kzw6Z/2DMgotLRU7Ku9GYaXVpfwg2Z8kHG6yRYbOdPmf6vphYJ4mBBhdYNn+Mbr9KA43CDvfTZOqmnGpKwX49kU9CcymQVMwQBOrA=; X-YMail-OSG: STT5hM0VM1l4sG.xs70ngTpJIbGoSaWwTeynMDau6DoUyRLkpLLIq.i29slmzZnfOwzcD9A3SdF7hTryh8YeVLy6MnQKzM_PRlF1e_22sbjTarwwUZa6WqdvaENf8Ll2Fw-- Received: from [64.17.232.66] by web36902.mail.mud.yahoo.com via HTTP; Wed, 27 Aug 2008 07:07:17 PDT X-Mailer: YahooMailRC/1042.48 YahooMailWebService/0.7.218.2 Date: Wed, 27 Aug 2008 07:07:17 -0700 (PDT) From: windsurferdrew-pg@yahoo.com Subject: WAL files during a backup To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <749976.10730.qm@web36902.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200808/202 X-Sequence-Number: 30047 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 .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