| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Roberto Scattini <roberto(dot)scattini(at)gmail(dot)com> |
| Cc: | Erik Jones <erik(at)myemma(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_xlog and standby |
| Date: | 2008-01-23 21:45:13 |
| Message-ID: | 1201124713.4257.59.camel@ebony.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2008-01-23 at 18:18 -0200, Roberto Scattini wrote:
> the standby server had filled his disk with archives
> received but not proccesed
Sounds like your standby has fallen badly behind. You should always
monitor the lag between primary and standby.
You will need to take steps to ensure the lag is reduced, or you will
continue to have problems with this technique. All asynchronous
replication systems have a potential for falling behind the master.
Fully synchronous replication techniques don't: they force the master to
slow down to a manageable pace.
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Hart | 2008-01-23 22:08:35 | Re: ascii to utf-8 |
| Previous Message | Gregory Stark | 2008-01-23 21:34:31 | Re: Best practices for protect applications agains Sql injection. |