Re: Fwd: Monitoring Replication on Master/Slave Postgres(9.1)

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Shams Khan <shams(dot)khan22(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Fwd: Monitoring Replication on Master/Slave Postgres(9.1)
Date: 2012-11-28 22:09:37
Message-ID: 50B68BA1.9020706@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew W. Gibbs 2012-11-29 01:52:17 base backup requirements for PITR
Previous Message Scott Marlowe 2012-11-28 21:16:51 Re: DBA user in Postgres