Re: Need help in Postgres log shipping replication

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: Jahnavi Chintakunta <Jahnavi(dot)Chintakunta(at)infotech-enterprises(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Need help in Postgres log shipping replication
Date: 2011-07-06 14:47:43
Message-ID: 20110706144743.GC17571@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message francescoboccacci@libero.it 2011-07-06 17:52:21 R: Re: adminpack installation problem
Previous Message Jahnavi Chintakunta 2011-07-06 14:04:11 Re: Need help in Postgres log shipping replication