Tue Oct 4 18:11:17 PDT 2005
- Previous message: [Slony1-general] error in cleanup_thread
- Next message: [Slony1-general] After upgrade to slony1-1.1.1 - UPDATE FUNCTIONS fails
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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_
- Previous message: [Slony1-general] error in cleanup_thread
- Next message: [Slony1-general] After upgrade to slony1-1.1.1 - UPDATE FUNCTIONS fails
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list