On 12-10-04 04:11 PM, Mike James wrote:
> OK, I was mistaken. The slon on the subscriber that ships the logs was restarted with the -a option. The slon on the Master was not started with the -a option.

Then I'm a bit confused about steps were done that resulted in log 
shipping getting out of sync.

1. If setup log shipping and started slon with -a on the slave
2. Added some tables to replication

I would expect log shipping to continue to work.




>
> Mike
>
> -----Original Message-----
> From: slony1-general-bounces at lists.slony.info [mailto:slony1-general-bounces at lists.slony.info] On Behalf Of Mike James
> Sent: Thursday, October 04, 2012 3:13 PM
> Cc: slony1-general at lists.slony.info
> Subject: Re: [Slony1-general] offline log shipping errors
>
> Well, if I had to guess, that's what I would think. The previous sysadmin created some scripts to manage slony, but I'm not sure that they're working effectively.
>
> Mike
>
> -----Original Message-----
> From: Steve Singer [mailto:ssinger at ca.afilias.info]
> Sent: Thursday, October 04, 2012 3:02 PM
> To: Mike James
> Cc: slony1-general at lists.slony.info
> Subject: Re: [Slony1-general] offline log shipping errors
>
> On 12-10-04 02:52 PM, Mike James wrote:
>> Hi, our DBA stopped log shipping to create a new replication set. When
>> he resumed log shipping, the next sequence number on the offline node
>> is not consistent with the new log sequence numbers coming from the
>> cluster. This is my 1^st experience using Postgres/Slony and I don't
>> know how to resolve this. I have not found a straightforward
>> resolution of this in Google searches - probably I'm using the wrong keywords.
>>
>
> What exactly do you mean by 'stopped log shipping' ?
>
> Do you mean that he shutdown the slon then restarted it without the -a option?
>
> If so I think you will need to rebuild the offline node from scratch with slony1_dump.sh because there is no longer a record of the changes that the slon had processed when it was running without the -a option.
>
>
>
>
>> Please point me in the right direction. Thanks, Mike
>>
>>
>>
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general
>>
>
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>