On January 18, 2005 01:35 pm, yves.trudeau at revolutionlinux.com wrote:
> Title: slonik crashes when configuring cluster
> Bug Type: Software bug
> Severity: Critical
> Software Version: Other
> Environment: Mandrake 10.1
> postgresql-server-7.4.3-2mdk
> kernel 2.6.8
> Created By: yves.trudeau at revolutionlinux.com
> Description: Hi,
> When running a script to setup the cluster I received the error:

The error is self evedent when you look at the log:

"Jan 18 16:29:35 millePG postgres[32689]: [4-1] ERROR:  permission denied for 
language c"

The user you are connecting as (slony) is not a database superuser, and cannot 
install c language functions.
Please check to make sure that the slony user exists on both nodes and is a 
superuser on both nodes.


>
> [root at vserver:millePG pgsql]sh ./create-cluster.sh
> <stdin>:20: loading of file /usr/share/pgsql/xxid.v74.sql:
> PGRES_FATAL_ERROR ERROR:  current transaction is aborted, commands ignored
> until end of transaction block ERROR:  current transaction is aborted,
> commands ignored until end of transaction block
>
> The create-cluster.sh script looks like this:
> #!/bin/sh
>
> CLUSTER=testpgmille
> DBNAME1=bdoriginale
> DBNAME2=bdreplica
> HOST1=192.168.43.8
> HOST2=192.168.43.9
> SLONY_USER=slony
>
>
> slonik <<_EOF_
>     # ----
>     # This defines which namespace the replication system uses
>     # ----
>     cluster name = $CLUSTER;
>
>     # ----
>     # Admin conninfo's are used by the slonik program to connect
>     # to the node databases.  So these are the PQconnectdb arguments
>     # that connect from the administrators workstation (where
>     # slonik is executed).
>     # ----
>     node 1 admin conninfo = 'dbname=$DBNAME1 host=$HOST1 user=$SLONY_USER';
>     node 2 admin conninfo = 'dbname=$DBNAME2 host=$HOST2 user=$SLONY_USER';
>
>     # ----
>     # Initialize the first node.  The id must be 1.
>     # This creates the schema "_test1" containing all replication
>     # system specific database objects.
>     # ----
>     init cluster ( id = 1, comment = 'Node 1' );
>
>     # ----
>     # The Slony replication system organizes tables in sets.  The
>     # smallest unit another node can subscribe is a set.  Usually the
>     # tables contained in one set would be all tables that have
>     # relationships to each other.  The following commands create
>     # one set containing all 4 pgbench tables.  The "master" or origin
>     # of the set is node 1.
>     # ----
>     create set ( id = 1, origin = 1, comment = 'Tables a repliquer' );
>     set add table ( set id = 1, origin = 1,
>         id = 1, fully qualified name = 'public.testtable',comment = 'Table
> de test');
>
>     # ----
>     # Create the second node, tell the two nodes how to connect to
>     # each other and that they should listen for events on each
>     # other.  Note that these conninfo arguments are used by the
>     # slon daemon on node 1 to connect to the database of node 2
>     # and vice versa.  So if the replication system is supposed to
>     # use a separate backbone network between the database servers,
>     # this is the place to tell it.
>     # ----
>     store node ( id = 2, comment = 'Node 2' );
>     store path ( server = 1, client = 2,
>         conninfo = 'dbname=$DBNAME1 host=$HOST1 user=$SLONY_USER');
>     store path ( server = 2, client = 1,
>         conninfo = 'dbname=$DBNAME2 host=$HOST2 user=$SLONY_USER');
>     store listen ( origin = 1, provider = 1, receiver = 2 );
>     store listen ( origin = 2, provider = 2, receiver = 1 );
> _EOF_
>
> In syslog, I noticed the following error:
> Jan 18 16:29:35 millePG postgres[32689]: [4-1] ERROR:  permission denied
> for language c Jan 18 16:29:35 millePG postgres[32689]: [4-2] STATEMENT: 
> -- ---------- Jan 18 16:29:35 millePG postgres[32689]: [4-3] ^I--
> xxid.v73.sql.in
>
> PostGreSQL and slony has been built on the host.
>
> Yves
> Status: Submitted
>
>
>
> http://gborg.postgresql.org/project/slony1/bugs/bugupdate.php?1123

-- 
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com