On 11/22/2004 9:31 AM, Grant Collins wrote:
> 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.

Looks to me as if you didn't setup the schema (tables and sequences of 
your application, for example that "books" table) on the subscriber 
side. Slony does not attempt to duplicate your schema - only data.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #