On Mon, 19 Dec 2005, Christopher Browne wrote:

> Marc G. Fournier wrote:
>
>>
>> Thought I had it all setup right, but when I ran my script, it tells
>> me that I can't setup the 8.0 node, with the 8.0 node having the
>> following error in the logs:
>>
>>
>> Dec 19 15:49:57 saturn pgsql[13813]: [24-1] ERROR:  could not find
>> function "_Slony_I_killBackend" in file
>> "/usr/local/lib/postgresql/slony1_funcs.so"
>> Dec 19 15:49:57 saturn pgsql[13813]: [25-1] ERROR:  current
>> transaction is aborted, commands ignored until end of transaction block
>> Dec 19 15:49:57 saturn pgsql[13813]: [26-1] LOG:  unexpected EOF on
>> client connection
>>
>> I build slony on the 8.0.x server, I didn't copy them from the 8.1.0
>> server ...
>>
>> bug, or did I miss something?
>> _______________________________________________
>
> _Slony_I_killBackend() was introduced between 1.1.2 and now; is it
> possible that you have an installation of 1.1.2 binaries (or possibly
> something earlier) lingering around?

You are right, cleaned it all out, did another make install, and all is 
well ...

Now, I tried using the slony_setup.pl script, and its generating some odd 
code:

         echo 'Creating store paths';
                 store path (server = 1, client = 2, conninfo = 'dbname=ams host=ams.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 1, client = 4, conninfo = 'dbname=ams host=ams.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 1, client = 3, conninfo = 'dbname=ams host=ams.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 2, client = 1, conninfo = 'dbname=ams host=mx1.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 2, client = 4, conninfo = 'dbname=DATABASE_NAME_HOLDER host=mx1.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 2, client = 3, conninfo = 'dbname=DATABASE_NAME_HOLDER host=mx1.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 4, client = 1, conninfo = 'dbname=ams host=saturn.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 4, client = 2, conninfo = 'dbname=DATABASE_NAME_HOLDER host=saturn.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 4, client = 3, conninfo = 'dbname=DATABASE_NAME_HOLDER host=saturn.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 3, client = 1, conninfo = 'dbname=ams host=mx2.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 3, client = 2, conninfo = 'dbname=DATABASE_NAME_HOLDER host=mx2.hub.org port=5432 user=pgsql password=pass');
                 store path (server = 3, client = 4, conninfo = 'dbname=DATABASE_NAME_HOLDER host=mx2.hub.org port=5432 user=pgsql password=pass');
         }

Easy to fix manually, just not sure why the setup_slony.pl script is 
generating it ...