This problem has been resolved !! Thanks VB
On Fri, Nov 11, 2011 at 9:58 PM, Venkat Balaji <venkat.bal...@verse.in>wrote: > Hello, > > WAL Archive process in our production is not working. > > [postgres@hostname]$ ps -ef | grep archive > postgres 12077 16015 0 10:19 pts/4 00:00:00 grep archive > postgres 31126 27607 0 Nov10 ? 00:01:18 postgres: archiver process > failed on 0000000100000F72000000F0 > > I see WAL files getting accumulated in pg_xlog location and the status in > "archive_status" is shown as ".ready". > > Is there anyway we can only restart archiving process without disturbing > the actual cluster ? > > Actually, we had killed a process using "kill -9 " and the db went into > recovery mode and was back up and running. > > We have no issues with the application as well. > > postgres=# select pg_is_in_recovery(); > > pg_is_in_recovery > ------------------- > f > (1 row) > > Please help to resolve this ! > > Thanks > VB >