Re: Disappearing table - suggestions on possible causes appreciated. - Mailing list pgsql-general

On Fri, Jun 08, 2007 at 07:39:26AM -0700, Andrew Edson wrote:
>   Recently, there have been incidents across a few of the offices
>   where the region table in their local copy of the database has
>   mysteriously lost all of its data.

Well, a couple possibilities:

1.    Are you vacuuming correctly?  If you had xid wraparound, your
data could disappear.

2.    Malice or pilot error: are you sure nobody has issued
TRUNCATE on the table?

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of code underneath."
        --Damien Katz