Re: [GENERAL] Almost full pg_xlog/

2011-01-31 Thread Adrian Klaver
On Monday, January 31, 2011 3:32:16 pm Jeff Ross wrote: > Hi, > > I started trying to setup streaming replication here at work the first > of December but I didn't actually succeed until today. Too many other > crises to attend to ;-) > > In the meantime, I now have 242 16MB files in pg_xlog/.

Re: [GENERAL] Almost full pg_xlog/

2011-01-31 Thread Jeff Ross
On 01/31/11 17:13, Tom Lane wrote: Jeff Ross writes: In the meantime, I now have 242 16MB files in pg_xlog/. The archive_status directory in pg_xlog/has a matching .done file for all but the most recent of those pg_xlog files. What have you got checkpoint_segments set to? I had wal_keep_s

Re: [GENERAL] Almost full pg_xlog/

2011-01-31 Thread Tom Lane
Jeff Ross writes: > In the meantime, I now have 242 16MB files in pg_xlog/. The > archive_status directory in pg_xlog/has a matching .done file for all > but the most recent of those pg_xlog files. What have you got checkpoint_segments set to? > Am I correct in thinking that I can delete most