Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 43B2D2E3A2F for ; Tue, 15 Jan 2008 13:19:54 -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 86768-03 for ; Tue, 15 Jan 2008 13:19:40 -0400 (AST) Received: from mail2.yozons.com (mail2.yozons.com [63.251.168.97]) by postgresql.org (Postfix) with ESMTP id 0C5D72E3041 for ; Tue, 15 Jan 2008 13:19:39 -0400 (AST) Received: from [192.168.1.2] (pool-71-164-18-27.sttlwa.fios.verizon.net [71.164.18.27]) (authenticated bits=0) by mail2.yozons.com (8.12.10/8.12.10) with ESMTP id m0FHJblG016617 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Tue, 15 Jan 2008 09:19:38 -0800 Message-ID: <478CEB2E.4040601@computer.org> Date: Tue, 15 Jan 2008 09:19:42 -0800 From: David Wall Reply-To: d.wall@computer.org User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: WAL copying includes vacuum, reindex, etc? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/161 X-Sequence-Number: 27935 When running WAL backups and warm-standby restores (we're currently on PG 8.2), do the vacuumlo changes, vacuum, analyze and reindex type commands get pushed through WAL files to the backup? Or will the backup database not have these maintenance items done? Thanks, David