Re: [GENERAL] pg_xlog size growing untill it fills the partition

2013-10-03 Thread Ken Brush
Try setting the following in your postgresql.conf: wal_keep_segments = 0 On Thu, Oct 3, 2013 at 2:56 PM, Michal TOMA wrote: > Hello, > > I have a problem on my pg 9.2.4 setup (OpenSuse 12.2, kernel 3.2.13). > My pg_xlog directory is growing uncontrolably untill it fills the > partition. The da

[GENERAL] Multiple Slave Failover with PITR

2012-03-27 Thread Ken Brush
Hello everyone, I notice that the documentation at: http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial Doesn't contain steps in a Multiple Slave setup for re-establishing them after a slave has become the new master. Based on the documentation, here are the most fail-proof steps I came

Re: [GENERAL] Multiple Slave Failover with PITR

2012-04-11 Thread Ken Brush
On Wed, Apr 11, 2012 at 9:03 AM, Sergey Konoplev wrote: > On Wed, Mar 28, 2012 at 11:35 AM, Albe Laurenz > wrote: >>> 1. Master dies :( >>> 2. Touch the trigger file on the most caught up slave > > If the master was stopped properly will the slaves be in sync to each other? I don't think you ca

Re: [GENERAL] Multiple Slave Failover with PITR

2012-04-11 Thread Ken Brush
On Wed, Apr 11, 2012 at 9:50 AM, Sergey Konoplev wrote: > On Wed, Apr 11, 2012 at 8:12 PM, Ken Brush wrote: >>>>> 8. Copy the history file from the new master to the slave (it's the >>>>> most recent #.history file in the xlog directory) >>>