> 2006-08-07 13:20:27 LOG: autovacuum: processing database "template1"
> 2006-08-07 13:20:47 ERROR: could not open relation with OID 311438
> 2006-08-07 13:21:52 LOG: autovacuum: processing database "postgres"
The easiest explanation is that someone dropped a table just as
autovacuum was trying to open it.
I am not quite sure that "autovacuum" was trying to open, as some user reported the same error on his system ( and he is definitely not mr. Autovacuum :)
>The above trace suggests that
you're actively changing template1, which is probably not good
practice ...
Not even in my wildest dreams would I dare to actively change template1. Amd the database users in question do not have permissions on template1; so I am quite confident no wrongrunning software does it.
What indeed happens alot in this database is the creation and the dropping of temp tables (the later automagically at the end of a connection, I assume)
Is there a way to learn to which dropped table OIDs belong, or is all gone after dropping and autovacuum ?
Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Reinsburgstraße 202b
70197 Stuttgart
0173/9409607
-
Let's set so double the killer delete select all.
