On Aug 30, 2004, at 12:33 PM, Jan Wieck wrote:

>
> I am pretty sure that you have some open connection. Are you for  
> example connected to the DB with some other admin tool, like  
> phppgadmin or the like? Is there any chance that some OTHER database  
> under the same postmaster has connections that use bogus autocommit  
> functionality?
>
>

Say...DBVisualizer? Great tool otherwise, but causes no end of grief  
with leaving a connection idle in transaction.


> Jan
>
>> On Aug 30, 2004, at 4:48 AM, Jan Wieck wrote:
>>> On 8/30/2004 12:49 AM, Ben wrote:
>>>
>>>> Both master and slave databases are brand new.... maybe 25 seconds  
>>>> old by the time I start slon. :) So no stale transactions laying  
>>>> around. In fact, they haven't seen any connections at all, save  
>>>> from the slony scripts.
>>>> Might this be because my postgres version is a little behind the  
>>>> times?
>>>
>>> After all it is a warning, not an error. Wait for 15 seconds, don't  
>>> slam on the red panic button, and the subscriber slon will try it  
>>> again. If there are no others that slonik's and slon's causing open  
>>> transactions as you say, that'll do just fine.
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at gborg.postgresql.org
>> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>
>
> --  
> #====================================================================== 
> #
> # It's easier to get forgiveness for being wrong than for being right.  
> #
> # Let's break this rule - forgive me.                                   
> #
> #================================================== JanWieck at Yahoo.com  
> #
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>
--------------------

Andrew Rawnsley
President
The Ravensfield Digital Resource Group, Ltd.
(740) 587-0114
www.ravensfield.com