Tom Lane wrote:
Kamil Srot <kamil.srot@xxxxxxxxx> 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
grep -i drop your_application_dir
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
