| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_resetxlog bug? |
| Date: | 2009-04-30 21:36:47 |
| Message-ID: | 1241127407.4163.122.camel@ebony.2ndQuadrant |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 2009-05-01 at 00:07 +0900, Fujii Masao wrote:
> Current pg_resetxlog doesn't remove any archive status files. This
> may cause continuous failure of archive command since .ready file
> remains even if a corresponding XLOG segment is removed. And,
> .done file without XLOG segment cannot be removed by checkpoint,
> and would remain forever. These are undesirable behaviors.
Agreed
> I think that pg_resetxlog should remove existing archive status files
> of XLOG segments. Here is the patch to do so.
Seems OK.
--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2009-04-30 21:39:42 | Re: Throw some low-level C scutwork at me |
| Previous Message | Tom Lane | 2009-04-30 21:10:06 | plpgsql's EXIT versus block and loop nesting |