<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Hi Steve<div><br></div><div><br></div><div>Thank you for your reply</div><div><br></div><div>I guess that would be /etc/slony1-94/slon.conf</div><div><br></div><div><br></div><div><br></div><div>But see what confuses me is this. All slonik* perl script reference this</div><div><br></div><div><div>slonik_drop_node:$CONFIG_FILE = '/etc/slony1-94/slon_tools.conf';</div><div><br></div><div><br></div><div>I guess then /etc/slony1-94/slon_tools.conf should be referencing /etc/slony1-94/slon.conf</div><div><br></div><div><br></div><div>Will try that and see how that goes</div><div><br></div><div><br></div><div>Thanks</div><div>Armand</div><div><br></div><div><div>On Nov 16, 2015, at 9:52 PM, Steve Singer <<a href="mailto:ssinger@ca.afilias.info">ssinger@ca.afilias.info</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div style="font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;">On 11/16/2015 10:32 PM, Armand Pirvu (home) wrote:<br><blockquote type="cite">Hi<br><br>Please pardon the length of this email but I felt it is best to give a global view<br><br>I was looking at slonik for a project.<br>All the setup info, tutorials etc etc seems to vary<br><br><a href="http://raghavt.blogspot.com/2012/07/simple-slony-i-replication-setup.html">http://raghavt.blogspot.com/2012/07/simple-slony-i-replication-setup.html</a><br>and<br>http://www.linuxjournal.com/article/7834<br><br></blockquote><br><blockquote type="cite"><br><br>/usr/pgsql-9.4/bin/slon_start -c /etc/slony1-94/slon_tools.conf 1 &<br>fails to start<br><br></blockquote><br>I think the config file should be to slon config file not a slon_tools.conf<br><br>ie the format is<br><br>cluster_name=myrep<br>pid_file='/opt/PostgreSQL/9.1/data/master_slon.pid'<br>conn_info='host=localhost dbname=master user=postgres port=5432'<br><br><a href="http://www.slony.info/documentation/2.2/runtime-config.html">http://www.slony.info/documentation/2.2/runtime-config.html</a><br><br>Or see slon_node.conf.sample which I think is included with the perl tools<br><br><br><br><blockquote type="cite">2015-11-16 20:59:50 CST ERROR syntax error in file "/etc/slony1-94/slon_tools.conf" line 13, near end of line<br>2015-11-16 20:59:50 CST CONFIG main: slon version 2.2.4 starting up<br>usage: /usr/pgsql-9.4/bin/slon [options] clustername conninfo<br><br>Options:<br> -h print usage message and exit<br> -v print version and exit<br> -d <debuglevel> verbosity of logging (1..4)<br> -s <milliseconds> SYNC check interval (default 10000)<br> -t <milliseconds> SYNC interval timeout (default 60000)<br> -o <milliseconds> desired subscriber SYNC processing time<br> -g <num> maximum SYNC group size (default 6)<br> -c <num> how often to vacuum in cleanup cycles<br> -p <filename> slon pid file<br> -f <filename> slon configuration file<br> -a <directory> directory to store SYNC archive files<br> -x <command> program to run after writing archive file<br> -q <num> Terminate when this node reaches # of SYNCs<br> -r <num> # of syncs for -q option<br> -l <interval> this node should lag providers by this interval<br><br><br>So what gives ? How do I debug, fix , move forward ? Aside the doc which maybe I missed , has an example which yes it works but it not going in all these details, any other examples and so on ?<br><br><br>Many thanks<br>Armand<br><br><br><br>_______________________________________________<br>Slony1-general mailing list<br><a href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br><a href="http://lists.slony.info/mailman/listinfo/slony1-general">http://lists.slony.info/mailman/listinfo/slony1-general</a></blockquote></div></blockquote></div><br></div></body></html>