Slony1 PostgreSQL Replication - DDL statements and slon exec command

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DDL statements and slon exec command

Adam Haberlach

2005-06-13, 7:24 am

We just rolled out slony 1.05 for our production cluster today, and it
seems to be working like a charm. Now I need to determine a path for
upgrades of our application and its databases. For now, I am advocating
the method of breaking the mirror, upgrading the master, and then
recreating a mirror, since at the moment this takes only about 20
minutes. We would like to explore the option of using the 'execute'
statement to syncronize changes to both machines.

If we alter tables to add/remove columns, will slony's triggers be
properly updated?
If we alter the database to add/remove tables, will we need to manually
update the mirror set, or does this happen automagically as well?

Thanks,

--
Adam Haberlach
Database Administrator
adam- luex2ndOlgNN8Ch2cx6n
ig@public.gmane.org

Sponsored Links