Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id E1E30B5DBE2
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  6 Jul 2011 11:47:49 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 50635-09 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  6 Jul 2011 14:47:43 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14])
	by mail.postgresql.org (Postfix) with ESMTP id C38B1B5D944
	for <pgsql-admin@postgresql.org>; Wed,  6 Jul 2011 11:47:43 -0300 (ADT)
Received: by locust.cns.vt.edu (Postfix, from userid 986)
	id CA02E118E16; Wed,  6 Jul 2011 10:47:43 -0400 (EDT)
Date: Wed, 6 Jul 2011 10:47:43 -0400
From: Ray Stell <stellr@cns.vt.edu>
To: Jahnavi Chintakunta <Jahnavi.Chintakunta@infotech-enterprises.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Need help in Postgres log shipping replication
Message-ID: <20110706144743.GC17571@cns.vt.edu>
References: 
 <6E38555CD4BF19498F17AE18FEBE59654683799A@INFHYDEXMB.corp.infotech-enterprises.com>
	<20110706135510.GB17571@cns.vt.edu>
	<6E38555CD4BF19498F17AE18FEBE596546837DB0@INFHYDEXMB.corp.infotech-enterprises.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <6E38555CD4BF19498F17AE18FEBE596546837DB0@INFHYDEXMB.corp.infotech-enterprises.com>
User-Agent: Mutt/1.5.17 (2007-11-01)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.409 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: **
X-Archive-Number: 201107/37
X-Sequence-Number: 37816

On Wed, Jul 06, 2011 at 07:34:11PM +0530, Jahnavi Chintakunta wrote:
> 
> 
> When the standy server is stopped, then the pg_xlog's in the master server are stagnant.


Sorry, I've never seen this before.

What is archive_timeout set to?
template1=# show archive_timeout;
 archive_timeout
-----------------
 15min
(1 row)

Also, this may be completely bogus, but I remember asking myself
if this was valid:
 archive_command = <scp %p $STANDBYNODE:$PGARCHIVE/%f>

I've always seen it inside single quotes.