Re: Tables dissapearing - Mailing list pgsql-general

From Tom Lane
Subject Re: Tables dissapearing
Date
Msg-id 732.1188228353@sss.pgh.pa.us
Whole thread Raw
In response to Tables dissapearing  (Kamil Srot <kamil.srot@nlogy.com>)
Responses Re: Tables dissapearing
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Undetected corruption of table files
Next
From: "Jonah H. Harris"
Date:
Subject: Re: [HACKERS] Undetected corruption of table files