Hi list,

I am having problems setting up slony 1.0.5 with postgresql 7.4.6 on a
Fedora Core 1 machine.? I run all the scripts that are found in the the
TOOLS directory of the source.? It can connect to the slave machine with
no problems when setting up the slony_master_setup.sh.

However when running slony_master_setup.sh I get errors with the
script.? slony_setup.log contains the following;

CREATE DATABASE
SET
SET
SET
SET
DEBUG:? AbortCurrentTransaction
ERROR:? function "plpgsql_call_handler" already exists with same
argument types
SET
DEBUG:? AbortCurrentTransaction
ERROR:? language "plpgsql" already exists
SET
REVOKE
GRANT
SET
CREATE TABLE
NOTICE:? ALTER TABLE / ADD PRIMARY KEY will create implicit index
"books_pkey" for table "books"
ALTER TABLE
COMMENT
<stdin>:60: PGRES_FATAL_ERROR select "_T1".setAddSequence(1, 1, '',
'Sequence ');? - ERROR:? Slony-I: setAddSequence_int(): sequence? not
found
CONTEXT:? PL/pgSQL function "setaddsequence" line 36 at perform
<stdin>:4: Initializing the cluster
<stdin>:12: Database cluster initialized as Node 1
<stdin>:13: Storing node 2
<stdin>:21: Node 2 created
<stdin>:22: Creating store paths
<stdin>:31: Store paths created
<stdin>:32: Storing listen network
<stdin>:41: listen network stored
<stdin>:49: Subscription set created
<stdin>:50: Adding tables to the subscription set
<stdin>:53:?? Adding table public.books...
<stdin>:55:???? done
<stdin>:57: Adding sequences to the subscription set
<stdin>:59:?? Adding sequence ...
<stdin>:64: Could not add tables and sequences!


The database isn't that complex at the moment just to test replication I
have one database with one table called books in it, which has one row
of data.? Both template1 and the database that is to be replicated have
plpgsql language installed on them.

If anyone could help that would be much appreciated.

Regards,

Grant Collins
slox.dev at spectrum-eit.co.uk