: postgres: archiver process failed on 0000000100000F72000000F0

From: Venkat Balaji <venkat(dot)balaji(at)verse(dot)in>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: : postgres: archiver process failed on 0000000100000F72000000F0
Date: 2011-11-11 16:28:56
Message-ID: CAFrxt0ge2r0kSwt+N1mT+agRDcnD87uPReSmkYUS9V_O=Z6AYA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Venkat Balaji 2011-11-11 17:33:02 Re: : postgres: archiver process failed on 0000000100000F72000000F0
Previous Message Andreas 'ads' Scherbaum 2011-11-11 15:14:33 Hotel reservation for FOSDEM 2012 - Deadline: December 31th, 2011