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 ...
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
