Slony wishlist

There has been some recent discussion on the slony -general mailing list about what changes should be made in the next major version of slony.

The slony team would like to get a sense of what aspects of slony are causing people issues or what features need to be added. The idea list is being tracked in a wiki page.

Some of the ideas being floated around include:

Improve the performance of replicating Slony over a WAN with high lag

Allow you to specify multilple tables to replicate in from a single slonik command. (ie set add table(tables=’public.*’)

Allow you to specify which tables EXECUTE SCRIPT should lock on the command line

Make it easier to see what each slon is currently working on and how many statements need to be replicated to a particular host without having to scan log files

Make slonik automatically ‘WAIT FOR’ commands that execute asynchronously

Replicate DDL automatically (yes, this requires DDL trigger triggers to be added to PostgreSQL

If your using slony and see a need for these (or any other changes) I’d appreciate it if you let me know what your top 3 requests are (leave a comment, drop a note to the slony mailing list or email me).