Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 2BEF59FB902 for ; Tue, 19 Jun 2007 14:27:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 06228-01-2 for ; Tue, 19 Jun 2007 14:27:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by postgresql.org (Postfix) with ESMTP id 16D619FB65C for ; Tue, 19 Jun 2007 14:27:48 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Tue, 19 Jun 2007 12:27:48 -0500 Message-Id: <4677CBB3.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.2 Date: Tue, 19 Jun 2007 12:27:32 -0500 From: "Kevin Grittner" To: "George Wilk" , "Tom Arthurs" Cc: Subject: Re: archive_command does not execute References: <002c01c7b26b$d0085400$0d7ba8c0@ellacoya.com> <46780175.3040207@jobflash.com> In-Reply-To: <46780175.3040207@jobflash.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/184 X-Sequence-Number: 25852 >>> On Tue, Jun 19, 2007 at 11:16 AM, in message <46780175.3040207@jobflash= .com>, Tom Arthurs wrote:=20 >=20 > Looks like you are expecting the archive command to run when you shut=20 > down the data base. It won't. It only runs when the xlog gets full = and=20 > the system needs to recycle to a new logfile. =20 If you need to force a WAL file to test your backup process, try running something like: =20 select pg_switch_xlog(); =20 http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIO= NS-ADMIN-BACKUP-TABLE =20 -Kevin =20