<div dir="ltr">Hello All, <div><br></div><div>We are in testing of upgrading our system.</div><div>Centos 6.5, PG 9.1.21 Slony 2.0.7. PG and Slony from postgres yum repo</div><div>We wish to upgrade to Slony 2.2.5 installed from source.</div><div><br></div><div>Please note that we upgrad Slony directly from 2.0.7 to 2.2.5 without upgrading to 2.1.4 first.</div><div><br></div><div>The upgrade went well, except it configure the trigger wrong.</div><div><br></div><div>On master, It has triggers : logtrigger, truncatedeny, and truncatetrigger</div><div>disabled trigger : denyaccess</div><div><br></div><div><div>On slave, It has triggers : denyaccess, truncatedeny, and truncatetrigger</div><div>disabled trigger : logtrigger</div></div><div><br></div><div>The slony replica configured based on official doc "replicating your first database".</div><div><br></div><div>How can we get correct triggers when upgrading ?</div><div><br></div><div>More details :</div><div><br></div><div><div>pgbench=# \d pgbench_accounts</div><div> Table "public.pgbench_accounts"</div><div> Column | Type | Modifiers </div><div>----------+---------------+-----------</div><div> aid | integer | not null</div><div> bid | integer | </div><div> abalance | integer | </div><div> filler | character(84) | </div><div>Indexes:</div><div> "pgbench_accounts_pkey" PRIMARY KEY, btree (aid)</div><div>Triggers:</div><div> _slony_example_logtrigger AFTER INSERT OR DELETE OR UPDATE ON pgbench_accounts FOR EACH ROW EXECUTE PROCEDURE _slony_example.logtrigger('_slony_example', '1', 'k')</div><div> _slony_example_truncatedeny BEFORE TRUNCATE ON pgbench_accounts FOR EACH STATEMENT EXECUTE PROCEDURE _slony_example.deny_truncate()</div><div> _slony_example_truncatetrigger BEFORE TRUNCATE ON pgbench_accounts FOR EACH STATEMENT EXECUTE PROCEDURE _slony_example.log_truncate('1')</div><div>Disabled triggers:</div><div> _slony_example_denyaccess BEFORE INSERT OR DELETE OR UPDATE ON pgbench_accounts FOR EACH ROW EXECUTE PROCEDURE _slony_example.denyaccess('_slony_example')</div></div><div><br></div><div><br></div><div>-- <br><div class="gmail_signature"><div dir="ltr"><div>Regards,</div><div><br></div>Soni Maula Harriz</div></div>
</div></div>