Re: failure with pg_dump

From: Mija Lee <mija(at)scharp(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: failure with pg_dump
Date: 2007-12-11 17:34:37
Message-ID: 475ECA2D.5090100@scharp.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

We are not using slony - we are replicating from sql server using perl.

Tom Lane wrote:
> Mija Lee <mija(at)scharp(dot)org> writes:
>> We've had a number of odd things that have been going on that I can't
>> really explain, and that don't seem to result in log entries. Here's
>> some info:
>
>> - this is running 8.2.4 on a solaris 10 machine
>> - I reran the dump after posting and these problems did not reoccur
>> - We have a number of replicated schemas and tables on this server.
>> There were other problems with the replication that happened earlier in
>> the evening.
>
> Hmm, are you using Slony? If so, you ought to take this to the Slony
> mailing lists. There are various restrictions in Slony on what it
> assumes can be done to a replicated table, and I believe that things
> like what you are seeing are one of the possible consequences of
> breaking Slony's expectations. That's about as far as my knowledge
> goes though.
>
> regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message roody senecal 2007-12-12 02:02:58 Data Replication
Previous Message Tom Lane 2007-12-11 17:03:36 Re: failure with pg_dump