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