Re: strange disappearence of postgres file

Alvaro,

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
vanish.

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 postgresql.org provices access to them
again :)

Harald

--
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstra=DFe 202b
70197 Stuttgart
0173/9409607