Re: archive_command does not execute - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: archive_command does not execute
Date
Msg-id 4677CBB3.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: archive_command does not execute  (Tom Arthurs <tarthurs@jobflash.com>)
List pgsql-admin
>>> On Tue, Jun 19, 2007 at 11:16 AM, in message <46780175.3040207@jobflash.com>,
Tom Arthurs <tarthurs@jobflash.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




pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Export/import issue/question
Next
From: "Bill Willits"
Date:
Subject: reindex in v8.2