Re: Corrupt database? 8.1/FreeBSD6.0

Alvaro Herrera <alvherre@commandprompt.com> writes:
> Hmm, as far as I can tell, the database entry would not be created
> merely by a vacuum.  The only way to create a database entry in pgstat
> is by calling pgstat_recv_tabstat(); and pgstat_report_tabstat is only
> called in postgres.c (not invoked via autovacuum) and in
> pgstat_beshutdown_hook (not sure if this one is).

The shutdown hook surely is called, and the scenario for sending stats
seems pretty obvious: stats_block_level = ON.

> Maybe we could forcibly activate the freeze mode on a template database?

Might not be a bad idea.  And even more to the point, forcibly disable
analyze.

            regards, tom lane