Skip site navigation (1) Skip section navigation (2)

Re: archive_command does not execute

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "George Wilk" <gwilk(at)ellacoya(dot)com>,"Tom Arthurs" <tarthurs(at)jobflash(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: archive_command does not execute
Date: 2007-06-19 17:27:32
Message-ID: 4677CBB3.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
>>> On Tue, Jun 19, 2007 at 11:16 AM, in message <46780175(dot)3040207(at)jobflash(dot)com>,
Tom Arthurs <tarthurs(at)jobflash(dot)com> wrote: 
> 
> Looks like you are expecting the archive command to run when you shut 
> down the data base. It won't.  It only runs when the xlog gets full and 
> the system needs to recycle to a new logfile.
 
If you need to force a WAL file to test your backup process, try running
something like:
 
select pg_switch_xlog();
 
http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-BACKUP-TABLE
 
-Kevin
 



In response to

pgsql-admin by date

Next:From: Bill WillitsDate: 2007-06-19 17:43:07
Subject: reindex in v8.2
Previous:From: Tom LaneDate: 2007-06-19 17:12:10
Subject: Re: Export/import issue/question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group