Re: Tables dissapearing

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kamil Srot <kamil(dot)srot(at)nlogy(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Tables dissapearing
Date: 2007-08-27 15:25:53
Message-ID: 732.1188228353@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kamil Srot <kamil(dot)srot(at)nlogy(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonah H. Harris 2007-08-27 15:26:40 Re: [HACKERS] Undetected corruption of table files
Previous Message Tom Lane 2007-08-27 15:16:55 Re: Undetected corruption of table files