From: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
---|---|
To: | Cumer Cristiano <CristianoMaria(dot)Cumer(at)unibz(dot)it> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgers 9.3 - ubuntu 16.04 - Are clogs entires automatically deleted? |
Date: | 2019-07-18 10:12:48 |
Message-ID: | CAKoxK+4Z+M6Ke8RH9-UqKwhpXrX41QoSwo7c2e44GO=kJmPCAA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Jul 18, 2019 at 10:34 AM Cumer Cristiano
<CristianoMaria(dot)Cumer(at)unibz(dot)it> wrote:
> Today I wanted to dump a database but pg_dump is complaining about missing clog files.
> I’m quite sure that nobody has deleted the files and that my filesystem is consistent.
>
> If I look in my clog directory I can see the files starting from 0013. The first ones are missing. I have checked the backups of a month ago and there I can see previous clog files, 0010,0011. I don’t have older backups.
Uhm.. 9.3 is in end of life, ubuntu 16.04 refers to three years ago
and is approaching the extends security releases only, that is it
looks a little ancient combination.
I suspect pg_dump will provide you with an hint about which particular
object is causing it to fail, in the case I suggest to backup
everything except such object. At least you will have something backed
up.
Any chance your disk was full and something nasty happened?
Luca
From | Date | Subject | |
---|---|---|---|
Next Message | Matthew Pounsett | 2019-07-18 13:44:04 | Rearchitecting for storage |
Previous Message | Cumer Cristiano | 2019-07-18 08:34:24 | Postgers 9.3 - ubuntu 16.04 - Are clogs entires automatically deleted? |