pg.ddx.io  pgsql-testers@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-testers@postgresql.org
Subject: Re: Problem with standby
Date: Wed, 08 Sep 2010 10:14:09 -0700
Message-ID: <4C87C461.2010108@agliodbs.com> (raw)
In-Reply-To: <684197.22674.qm@web1207.biz.mail.gq1.yahoo.com>
References: <684197.22674.qm@web1207.biz.mail.gq1.yahoo.com>

On 09/08/2010 05:28 AM, Jai Soni wrote:
>
> Dear pgsql-testers
>
> i have installed postgresql 9.0 beta1 and testing its streaming
> replication feature
> when i set up the replication env (i.e. primary and standby servers)
> everything was fine and the replication goes successful but last
> three-four days the standby server does not doing replication i have
> appended the log messages that i received in standby server

There have been a lot of fixes to Standby since Beta1.  Please do try a 
more recent version, like RC1.

The message you are getting indicates that for some reason the standby 
stopped replicating for a long enough period for the transaction records 
to be deleted on the Master.  If you are not using WAL archiving as a 
backup for falling behind, then your only choice is to re-clone the standby.

-- 
                                   -- Josh Berkus
                                      PostgreSQL Experts Inc.
                                      http://www.pgexperts.com



view thread (2+ messages)

Message-ID: <4C87C461.2010108@agliodbs.com>
Permalink:  ../4C87C461.2010108@agliodbs.com/
Also on:    postgresql.org/message-id/4C87C461.2010108@agliodbs.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-testers@postgresql.org
  Cc: josh@agliodbs.com
  Subject: Re: Problem with standby
  In-Reply-To: <4C87C461.2010108@agliodbs.com>
  References: <684197.22674.qm@web1207.biz.mail.gq1.yahoo.com> <4C87C461.2010108@agliodbs.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