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
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 |