pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kris Kiger <kris@musicrebellion.com>
To: pgsql-admin@postgresql.org
Subject: archive_command
Date: Wed, 28 Sep 2005 11:10:01 -0500
Message-ID: <433AC059.1050300@musicrebellion.com> (raw)
In-Reply-To: <20031115132118.V74587@holywar.net>
References: <20031115132118.V74587@holywar.net>

    I've been playing around with recovery and am a bit confused as to 
when this method gets invoked. 
    At the moment, I have two servers set up, both of them with postgres 
installed.  Lets call them server A and server B.  Server A is running 
postgres and processing transactions.  Server B has postgres installed, 
but the postmaster is not running.  My archive_command is set to use 
rsync copy the wal log from server A to server B.  When i'm watching the 
number of wal files on server A I notice sometimes there are 3 files 
that have not been archived, sometimes there are 4, and sometimes there 
are more. 
    So, my question is, when is archive_command invoked?

Thanks in advance!
Kris



view thread (17+ messages)  latest in thread

Message-ID: <433AC059.1050300@musicrebellion.com>
Permalink:  ../433AC059.1050300@musicrebellion.com/
Also on:    postgresql.org/message-id/433AC059.1050300@musicrebellion.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: kris@musicrebellion.com
  Subject: Re: archive_command
  In-Reply-To: <433AC059.1050300@musicrebellion.com>
  References: <20031115132118.V74587@holywar.net> <433AC059.1050300@musicrebellion.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox