Hi Grant,

This script is probably deprecated now in favor of the altperl setup
scripts in the tools directory. While this script worked during slony
alpha and beta, I haven't, nor has anyone else, maintained it now that
slony has been released.

I suggest you try the scripts in the altperl and post any further
mailings to the slony mailing list.

Daniel

Grant Collins wrote:

>Daniel,
>
>I retrieved this email address from your slony_setup.pl script to help
>setup replication on the slony.  At the moment I am having difficulties
>configuring replication on a simple one table database.  I run the
>slony_setup.pl script with no errors and execute the
>slony_master_setup.sh that is generated.
>
>When running slony_master_setup script, the script fails with problems
>with the setAddSequence sequence.  Here is the contents of the
>slony_setup.log;
>
>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!
>
>
>Any help on the matter would be appreciated.
>
>Regards,
>
>Grant Collins
>slox.dev at spectrum-eit.co.uk
>
>  
>