Message-ID: <50B68BA1.9020706@pinpointresearch.com>
Date: Wed, 28 Nov 2012 14:09:37 -0800
From: Steve Crawford <scrawford@pinpointresearch.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:16.0) Gecko/20121028 Thunderbird/16.0.2
MIME-Version: 1.0
To: Shams Khan <shams.khan22@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Fwd: Monitoring Replication on Master/Slave Postgres(9.1)
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>
In-Reply-To: 
 <CAM42booKO9EXdArtwUuL6L+5CbvE33PTX8Dioo-nf2xFUk+TXw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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