agora inbox for pgsql-admin@postgresql.org
help / color / mirror / Atom feedFrom: Steve Crawford <scrawford@pinpointresearch.com>
To: Chatha, Karan (CMG-Atlanta) <Karan.Chatha@coxinc.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Replication Lag
Date: Fri, 21 Mar 2014 17:44:08 -0700
Message-ID: <532CDCD8.30200@pinpointresearch.com> (raw)
In-Reply-To: <378D940FF9AE0145BA853EE92442D64334660CF3@CMGATLPMS2003.cmg.int>
References: <378D940FF9AE0145BA853EE92442D64334660540@CMGATLPMS2003.cmg.int>
<532C8F44.4030301@pinpointresearch.com>
<378D940FF9AE0145BA853EE92442D64334660CF3@CMGATLPMS2003.cmg.int>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 03/21/2014 12:43 PM, Chatha, Karan (CMG-Atlanta) wrote:
>
> 1)It was working until March 8
>
And then what changed? *Anything* that might have happened. Config
change, unclean reboot, out of disk, firewall updates, network changes,
anything at all...
>
> 2)We upgraded Postgres from 9.03 to 9.015 on Feb 19
>
There are a few items that require special handling between 9.03 and
9.0.15. Did you read all the release notes and make sure that the extra
steps were completed or didn't apply to you? (I'm not sure that any
directly impact replication but haven't been running anything earlier
than 9.1 for quite a while.)
>
> 3)Streaming Replication
>
> 4)Right now we have master on 9.015 and 7 slaves on 9.015 and one
> slave on 9.0.16
>
> 5)We have full logging enable to syslog
>
What do the logs tell you? Have you thoroughly examined them both for
current messages and anything unusual around the time that the issue
appeared?
>
> 6)What we see is that there are no loads or io but archives get stuck
> on one archive. We have
>
> 7)max_standby_archive_delay = 60000 # max delay before
> canceling queries
>
> max_standby_streaming_delay = 60000
>
> It is almost like these values are not being honored.
>
Cheers,
Steve
view thread (15+ messages) latest in thread
Message-ID: <532CDCD8.30200@pinpointresearch.com>
Permalink: ../532CDCD8.30200@pinpointresearch.com/
Also on: postgresql.org/message-id/532CDCD8.30200@pinpointresearch.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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scrawford@pinpointresearch.com, Karan.Chatha@coxinc.com
Subject: Re: Replication Lag
In-Reply-To: <532CDCD8.30200@pinpointresearch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox