On Thu, Jul 18, 2019 at 10:34 AM Cumer Cristiano
<CristianoMaria.Cumer@unibz.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
backupsof 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