On Wed, May 12, 2010 at 11:09 AM, Alban Hertroys <dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote: > On 12 May 2010, at 12:01, Glyn Astill wrote: > >> Did you not mention that this server was a slony slave at some point though? >> >> Just because you have removed slony, and the error comes from postgresql itself does not mean the corruption was not caused by misuse of slony. > > Indeed. I wonder if "when we ere adding/removing slony to the system for Nth time (due to it sometimes going out of sync)" may be caused by that as well. > ok, so either upgrade to newer version of slony, or drop all tables, and recreate them every time slony is removed and readded to the database. And I guess the only reason postgresql doesn't like it, is due to slony's behavior. thanks guys. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
