Search Postgresql Archives

Re: Disappearing table - suggestions on possible causes appreciated.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx
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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux