| From: | Bernd Helmle <mailings(at)oopsware(dot)de> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: How can we tell how far behind the standby is? |
| Date: | 2010-11-08 18:55:38 |
| Message-ID: | 318FF7CC8303031664551D05@amenophis |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
--On 5. November 2010 11:46:08 -0700 Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> I'll work on some tools to make this a bit more palatable, but I
> disagree with earlier assertions that we have the replication monitoring
> "done". There's still a *lot* of work to do.
While getting familiar with our SR/HS infrastructure i scripted this
<https://github.com/psoo/pg_standby_status/blob/master/pg_standby_status.pl>
Not sure if it does all things right, but it helped me a lot while load
testing SR. AFAIK Magnus has a monitoring script, too, i think this one is
it:
<https://github.com/mhagander/munin-plugins/blob/master/postgres/postgres_streaming_.in>
Maybe that helps, too.
--
Thanks
Bernd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2010-11-08 19:29:45 | Re: proposal: plpgsql - iteration over fields of rec or row variable |
| Previous Message | Tom Lane | 2010-11-08 18:52:11 | Re: proposal: plpgsql - iteration over fields of rec or row variable |