Kamil Srot <kamil.srot@nlogy.com> writes:
> One more thing:
> The project runs proprietal CMS system and there are more instances of
> it with the same database layout in different databases. Every time the
> "lost" table is the same one - the bussiest one (mostly read)... and
> everytime the "lost" table is gone from more projects at once... today
> it was 2 projects affected out of 7 in the same pgsql server... it looks
> also like the problem happens everytime short after midnight - scarry -
> ha ha :-)
Tables don't just "disappear" like that. Check your application code
to see if it's not dropping the table someplace.
regards, tom lane