Re: : postgres: archiver process failed on 0000000100000F72000000F0

[Venkat Balaji <venkat.balaji@xxxxxxxx>]

This problem has been resolved !!

Thanks

VB

On Fri, Nov 11, 2011 at 9:58 PM, Venkat Balaji <venkat.balaji@xxxxxxxx> 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