Re: : postgres: archiver process failed on 0000000100000F72000000F0

This problem has been resolved !!

Thanks
VB

On Fri, Nov 11, 2011 at 9:58 PM, Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>wrote:

> Hello,
>
> WAL Archive process in our production is not working.
>
> [postgres(at)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
>