Re: [GENERAL] pg_xlog and standby - SOLVED

2008-01-24 Thread Roberto Scattini
On Jan 24, 2008 4:30 PM, Greg Smith <[EMAIL PROTECTED]> wrote: > On Thu, 24 Jan 2008, Erik Jones wrote: > > > To disable archiving, set archive_command="", commenting it out won't > > change it...However, commenting a config is not necessarily equivalent > > to disabling something. > > This is actu

Re: [GENERAL] pg_xlog and standby - SOLVED

2008-01-24 Thread Greg Smith
On Thu, 24 Jan 2008, Erik Jones wrote: To disable archiving, set archive_command="", commenting it out won't change it...However, commenting a config is not necessarily equivalent to disabling something. This is actually a problem that is corrected in the upcoming 8.3 release. From those re

Re: [GENERAL] pg_xlog and standby - SOLVED

2008-01-24 Thread Erik Jones
On Jan 24, 2008, at 6:09 AM, Roberto Scattini wrote: On Jan 23, 2008 11:07 PM, Greg Smith <[EMAIL PROTECTED]> wrote: On Wed, 23 Jan 2008, Roberto Scattini wrote: the problem that im having is that i have A LOT of archive files on pg_xlog dir, and thats because the archive_command keeps faili

Re: [GENERAL] pg_xlog and standby - SOLVED

2008-01-24 Thread Roberto Scattini
On Jan 23, 2008 11:07 PM, Greg Smith <[EMAIL PROTECTED]> wrote: > On Wed, 23 Jan 2008, Roberto Scattini wrote: > > > the problem that im having is that i have A LOT of > > archive files on pg_xlog dir, and thats because the archive_command > > keeps failing (the standby server had filled his disk w

Re: [GENERAL] pg_xlog and standby

2008-01-23 Thread Greg Smith
On Wed, 23 Jan 2008, Roberto Scattini wrote: the problem that im having is that i have A LOT of archive files on pg_xlog dir, and thats because the archive_command keeps failing (the standby server had filled his disk with archives received but not proccesed), so now, i dont know how i can remov

Re: [GENERAL] pg_xlog and standby

2008-01-23 Thread Simon Riggs
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 th

Re: [GENERAL] pg_xlog and standby

2008-01-23 Thread Roberto Scattini
On Jan 23, 2008 2:28 PM, Erik Jones <[EMAIL PROTECTED]> wrote: > > You don't. The main server should not be keeping archived WAL files > directly in pg_xlog/. As it queues WAL files to be archived it puts > them in pg_xlog/archive_status/ with file names suffixed with .ready, > once they are arch

Re: [GENERAL] pg_xlog and standby

2008-01-23 Thread Erik Jones
On Jan 23, 2008, at 2:18 PM, Roberto Scattini wrote: On Jan 23, 2008 2:28 PM, Erik Jones <[EMAIL PROTECTED]> wrote: You don't. The main server should not be keeping archived WAL files directly in pg_xlog/. As it queues WAL files to be archived it puts them in pg_xlog/archive_status/ with fi

Re: [GENERAL] pg_xlog and standby

2008-01-23 Thread Erik Jones
On Jan 23, 2008, at 9:28 AM, Roberto Scattini wrote: hello everybody: im trying to reconfigure a warm-standby server. the problem is that for some reason, one day the standby server stopped recovering the archives. this leaded to a full disk on that server, so i turned off (commented) the arch

[GENERAL] pg_xlog and standby

2008-01-23 Thread Roberto Scattini
hello everybody: im trying to reconfigure a warm-standby server. the problem is that for some reason, one day the standby server stopped recovering the archives. this leaded to a full disk on that server, so i turned off (commented) the archive_command on the main server. i want to restart the pr