From: Steve Crawford <scrawford@pinpointresearch.com>
To: Shams Khan <shams.khan22@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Fwd: Monitoring Replication on Master/Slave Postgres(9.1)
Date: Wed, 28 Nov 2012 14:09:37 -0800
Message-ID: <50B68BA1.9020706@pinpointresearch.com> (raw)
In-Reply-To: <CAM42booKO9EXdArtwUuL6L+5CbvE33PTX8Dioo-nf2xFUk+TXw@mail.gmail.com>
References: <CAM42boou8pj2qsGkBqpDY0X3pCkyUnujqMGuiC-L-zwW3Qjuwg@mail.gmail.com>
<CAM42boq7v8NeNVgvJ5NKQH3DV8hvoepBy1acG-mypS=LRhcW_w@mail.gmail.com>
<50B65FC2.3030508@pinpointresearch.com>
<CAM42booKO9EXdArtwUuL6L+5CbvE33PTX8Dioo-nf2xFUk+TXw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 11/28/2012 11:24 AM, Shams Khan wrote:
> Thanks for the response Steve...It was really helpful:
>
> Below are some doubts I wanted to clarify..please read and suggest.
> Can we also check if replication was broken earlier...somehow due to
> power failure of some other reasons in past...The reason I am asking
> is I am getting some discrepancies in data between master and
> slave...? I want to know the reason of it...
>
What sort of discrepancies? I am unaware of situations in a properly
configured and functioning system where the standby could be anything
other than lagging the master but I didn't dig through release notes to
see if there were any related bugs.
Cheers,
Steve
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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, shams.khan22@gmail.com
Subject: Re: Fwd: Monitoring Replication on Master/Slave Postgres(9.1)
In-Reply-To: <50B68BA1.9020706@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 DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox