Re: Tables dissapearing

From: brian <brian(at)zijn-digital(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Tables dissapearing
Date: 2007-08-27 15:37:12
Message-ID: 46D2EFA8.6000602@zijn-digital.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> 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
>

grep -i drop your_application_dir

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-27 15:37:44 Re: Out of Memory - 8.2.4
Previous Message Tom Lane 2007-08-27 15:35:06 Re: [ERROR] syntax error at end of input