On Fri, Nov 11, 2011 at 09:58:56PM +0530, Venkat Balaji 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 !
If you fix the problem causing the archiver process to fail it will start processing
the logs again.
check your postgres logs and check your archive_command in your postgresql.conf and
make sure that everything is correct there.
Dave