Melvin Davidson mdavidson
Tue Oct 4 18:11:17 PDT 2005
I have just upgraded to slony1-1.1.1 on both master and slave.

I am trying to execute the UPDATE FUNCTIONS which is required,
however, when I attempt to do so on either master or slave, I get the
following error:

<stdin>:17: loading of file /usr/local/pgsql/share//slony1_funcs.v73.sql:
PGRES_FATAL_ERROR ERROR:  current transaction is aborted, queries 
ignored until end of transaction block
ERROR:  current transaction is aborted, queries ignored until end of 
transaction block

postgres has been recycled and slon is not running.

Any ideas?

Contents of script:
============================================================================
#!/bin/sh
    slonik <<_EOF_
         # ----
         # This defines which namespace the replication system uses
         # ----
         cluster name = $CLUSTERNAME;

         # ----
         # 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=$MASTERDBNAME host=$MASTERHOST 
user=$REPLICATIONUSER';
 node 2 admin conninfo = 'dbname=$SLAVEDBNAME host=$SLAVEHOST 
user=$REPLICATIONUSER';

UPDATE FUNCTIONS ( ID = 1);
UPDATE FUNCTIONS ( ID = 2);

_EOF_




More information about the Slony1-general mailing list