Old pg_xlog files

From: "Tass Chapman" <tasseh(dot)postgres(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Old pg_xlog files
Date: 2006-03-22 18:37:54
Message-ID: ec9575e80603221037j192696f1y7cad85404bc42568@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am running postgres 7.4.9 on an LFS system , and had a long outstanding
pg_checkpoint that seemed to prevent the DB from being cleanly shutdown.
The box was power cycled (not my choice...) and when it came up Postgres did
it's recovery and seemed to be fine.

Checkpoints appear to be up to date (via pg_controldata), but the pg_xlog
directory has 95 files, of which 90 are dated before midnight yesterday or
earlier.

Can I just delete them safely? Or is there some recovery method I can do?

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vivek Khera 2006-03-22 19:03:13 Re: Old pg_xlog files
Previous Message Joshua D. Drake 2006-03-22 18:34:52 Re: Advantages of PostgreSQL over MySQL 5.0