Skip site navigation (1) Skip section navigation (2)

Re: strange disappearence of postgres file

From: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>
To: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>, Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: strange disappearence of postgres file
Date: 2005-11-23 13:11:36
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs

How many database-wide vacuums did you run during these 9 months?  I'm
> smelling transaction Id wraparound in pg_class or some other system
> catalog.
> This has been known to happen.  Please see the archives.

"database wide" vacuums have been very very seldom; I fear the only one was
at initial db bulk load. at the moment I am on a way to upgrade to 8.1, with
autovacuum enabled ... so in the long run THAT possible reason should

And I understand correctly that your suspicion is: file gets killed because
of transaction id wraparound in system table?

I will scan teh archives (as soon as provices access to them
again :)


GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstra├če 202b
70197 Stuttgart

In response to


pgsql-bugs by date

Next:From: Tatsuo IshiiDate: 2005-11-23 13:24:00
Subject: Re: [PATCHES] Patch to allow contrib/pgbench files to have blank
Previous:From: Alvaro HerreraDate: 2005-11-23 12:15:16
Subject: Re: strange disappearence of postgres file

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group