Re: Postgers 9.3 - ubuntu 16.04 - Are clogs entires automatically deleted?

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Cumer Cristiano <CristianoMaria(dot)Cumer(at)unibz(dot)it>, "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 14:36:36
Message-ID: a83c7cf6-eb42-e0b0-190f-b63f8c109820@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7/18/19 1:34 AM, Cumer Cristiano wrote:
> Hi List,
>
> 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.

What is the exact message you get?

What is the full version of Postgres, for example 9.3.x?

>
> 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.
>
> So…. Is there a bug that delete clogs files even when they are still in use?
>
> Cristiano
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2019-07-18 14:49:41 Re: PostgreSQL as a Service
Previous Message Dirk Riehle 2019-07-18 14:23:26 PostgreSQL as a Service