Search Postgresql Archives

Re: pg_xlog and standby

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux