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: (view raw or whole 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();

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-2015 The PostgreSQL Global Development Group