Hi All,<br><br>I am trying to implement Slony1-1.2.20 on with PostgreSQL 8.4.1 running on Ret Hat Linx 64bit.<br><br>Getting the following error:<br><br>-bash-3.2$ ./slonik_init_cluster -c etc/slon_tools.conf<br><br># INIT CLUSTER<br>
cluster name = cms_replica;<br> node 1 admin conninfo='host=172.17.16.30 dbname=cms_master user=postgres port=5432 password=2zyo6y58';<br> node 2 admin conninfo='host=172.17.13.35 dbname=cms_slave user=postgres port=5432 password=2zyo6y58';<br>
init cluster (id = 1, comment = 'Node 1 - <a href="mailto:cms_master@172.17.16.30">cms_master@172.17.16.30</a>');<br><br># STORE NODE<br> store node (id = 2, event node = 1, comment = 'Node 2 - <a href="mailto:cms_slave@172.17.13.35">cms_slave@172.17.13.35</a>');<br>
echo 'Set up replication nodes';<br><br># STORE PATH<br> echo 'Next: configure paths for each node/origin';<br> store path (server = 1, client = 2, conninfo = 'host=172.17.16.30 dbname=cms_master user=postgres port=5432 password=2zyo6y58');<br>
store path (server = 2, client = 1, conninfo = 'host=172.17.13.35 dbname=cms_slave user=postgres port=5432 password=2zyo6y58');<br> echo 'Replication nodes prepared';<br> echo 'Please start a slon replication daemon for each node';<br>
-bash-3.2$<br><br>====ERROR:<br><br><b>-bash-3.2$ ./slonik_init_cluster -c etc/slon_tools.conf|./slonik<br><stdin>:6: Possible unsupported PostgreSQL version (80401) 8.4, defaulting to 8.3 support<br><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<br>
LINE 60: set_locked "_cms_replica".xxid,<br> ^<br>ERROR: type "_cms_replica.xxid" does not exist<br>LINE 60: set_locked "_cms_replica".xxid,<br> ^<br>
-bash-3.2$ <br></b><br>Please let me know whats missing.<br clear="all"><br>Thanks<br>Hari Kiran P.<br>