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 12:13:08 -0700
Message-ID: <532C8F44.4030301@pinpointresearch.com> (raw)
In-Reply-To: <378D940FF9AE0145BA853EE92442D64334660540@CMGATLPMS2003.cmg.int>
References: <378D940FF9AE0145BA853EE92442D64334660540@CMGATLPMS2003.cmg.int>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 03/20/2014 07:42 PM, Chatha, Karan (CMG-Atlanta) wrote:
>
> We are having replication lag issues in our production environment.
> We are on postgres 9.015.
>
Er. 9.0.15?
>
> We have one master and 8 slaves. We don't see any loads or io on the
> slaves. All we see is replication lag which we measure in megs. We
> can reproduce
>
> this by doing transactions on the master and we see that transactions
> are not coming over to slave.
>
Are you seeing a *lag* in replication or no replication at all?
>
> Is there any way we are hitting a bug?
>
Possibly but I'm going to guess that the most likely location of the bug
is somewhere in your configuration. You need to provide more
information. This page is a good guide:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
In particular, I'd like to know for starters:
0. What form of replication are you using? Bucardo? Slony? Pgpool?
Londiste? Mammoth? Hot-standby? Warm-standby? ...
1. Did it ever work?
2. If so, what changed? (configuration, upgrades, network, ???)
3. Are all machines on the same version?
4. Have you done any upgrades? If so, did you follow all the special
notes regarding each upgrade? Occasionally minor upgrades require steps
beyond simply replacing the binary and at times those have involved
replication issues.
5. Anything of interest in the logs on the master or any of the
standbys? Be sure sufficient logging is enabled.
Cheers,
Steve
view thread (15+ messages) latest in thread
Message-ID: <532C8F44.4030301@pinpointresearch.com>
Permalink: ../532C8F44.4030301@pinpointresearch.com/
Also on: postgresql.org/message-id/532C8F44.4030301@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: <532C8F44.4030301@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