Hari Kiran hari.kiran at enterprisedb.com
Thu Jul 22 19:09:51 PDT 2010
Hi All,

I am trying to implement Slony1-1.2.20 on with PostgreSQL 8.4.1 running on
Ret Hat Linx 64bit.

Getting the following error:

-bash-3.2$ ./slonik_init_cluster -c etc/slon_tools.conf

# INIT CLUSTER
cluster name = cms_replica;
 node 1 admin conninfo='host=172.17.16.30 dbname=cms_master user=postgres
port=5432 password=2zyo6y58';
 node 2 admin conninfo='host=172.17.13.35 dbname=cms_slave user=postgres
port=5432 password=2zyo6y58';
  init cluster (id = 1, comment = 'Node 1 - cms_master at 172.17.16.30');

# STORE NODE
  store node (id = 2, event node = 1, comment = 'Node 2 -
cms_slave at 172.17.13.35');
  echo 'Set up replication nodes';

# STORE PATH
  echo 'Next: configure paths for each node/origin';
  store path (server = 1, client = 2, conninfo = 'host=172.17.16.30
dbname=cms_master user=postgres port=5432 password=2zyo6y58');
  store path (server = 2, client = 1, conninfo = 'host=172.17.13.35
dbname=cms_slave user=postgres port=5432 password=2zyo6y58');
  echo 'Replication nodes prepared';
  echo 'Please start a slon replication daemon for each node';
-bash-3.2$

====ERROR:

*-bash-3.2$ ./slonik_init_cluster -c etc/slon_tools.conf|./slonik
<stdin>:6: Possible unsupported PostgreSQL version (80401) 8.4, defaulting
to 8.3 support
<stdin>:6: loading of file
/opt/PostgresPlus/8.4SS/share/postgresql/slony1_base.sql: PGRES_FATAL_ERROR
ERROR:  type "_cms_replica.xxid" does not exist
LINE 60:  set_locked   "_cms_replica".xxid,
                       ^
ERROR:  type "_cms_replica.xxid" does not exist
LINE 60:  set_locked   "_cms_replica".xxid,
                       ^
-bash-3.2$
*
Please let me know whats missing.

Thanks
Hari Kiran P.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20100723/cc856dde/attachment.htm 


More information about the Slony1-general mailing list