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

From Andrew Sullivan
Subject Re: Disappearing table - suggestions on possible causes appreciated.
Date
Msg-id 20070608151452.GI17144@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Disappearing table - suggestions on possible causes appreciated.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Fri, Jun 08, 2007 at 11:11:05AM -0400, Tom Lane wrote:
>
> I wonder if Slony is doing it to you --- somehow deciding it needs to
> "replicate" that table from somewhere else.  Might be worth inquiring
> on the slony lists if anyone's seen such a thing.

The only way Slony would do that is in the event that the table were
added to a set.  In that case, it will indeed truncate the table and
try to load the data from the origin.  So that is a possibility I
didn't list in my other mail.  If the table is large, the load could
take some time, during which you'd not be able to see anything in the
table.  When you went to insert to the table, though, you'd get
errors, so unless you're dropping the table and rebuilding from
scratch, I'd expect you to get an error when you reloaded the data.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
Everything that happens in the world happens at some place.
        --Jane Jacobs

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Disappearing table - suggestions on possible causes appreciated.
Next
From: "phillip "
Date:
Subject: Re: failing to start posgresql.