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
