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: [email protected] > [mailto:[email protected]] On Behalf Of Mike James > Sent: Thursday, October 04, 2012 3:13 PM > Cc: [email protected] > 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:[email protected]] > Sent: Thursday, October 04, 2012 3:02 PM > To: Mike James > Cc: [email protected] > 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 >> [email protected] >> http://lists.slony.info/mailman/listinfo/slony1-general >> > > > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > > > _______________________________________________ > Slony1-general mailing list > [email protected] > http://lists.slony.info/mailman/listinfo/slony1-general > _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
