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