Slony wishlist

Posted: November 26, 2010 in postgresql
Tags: , ,

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).

    Advertisements
    Comments
    1. AP says:

      My top 3:

      #1: Replicate DDL automatically
      #2: Improve the performance of replicating Slony over a WAN with high lag
      #3: 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

      🙂

    2. demo says:

      I would really like to specify the different keepalive parameters used by slony. At the moment, we often have to restart slon after a network outage/server down/etc.

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s