Bucardo version 4.0.0 released - Mailing list pgsql-announce

-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160


I'm happy to announce that version 4.0.0 of Bucardo has been released.
This is a major version change and incorporates many improvements
since the last released version. Bucardo can be downloaded here:

http://bucardo.org/wiki/Bucardo/Download

The list of Changes can be found here:

http://bucardo.org/wiki/Bucardo/Changes

The development version can be pulled via:

git clone git://bucardo.org/bucardo.git

Complete changes for 4.0.0 (GSM is Greg Sabino Mullane)

New features:

  - Add support for multi-column primary keys. Thanks to Backcountry.com. [GSM]

  - Add new 'onetimecopy' attribute to sync table, to allow recreation on
    demand of pushdelta tables on slaves via COPY. [GSM]

  - Support for replication after TRUNCATE. This will only work on
    Postgres version 8.4 and higher, and only for pushdelta syncs. [GSM]

  - Add log_conflict_details to allow logging of conflict information
    to a separate file. [Adam Wendt]

  - Add 'maxkicks' and 'lifetime' to syncs to force restart of controller
    and kids after a certain number of kicks or time. [Josh Tolley]
    Thanks to Backcountry.com.

  - Allow replication of sequences. [GSM]

  - Add the bucardo_custom_trigger table, which allows tight control of exactly
    what items in a table will be replicated. [Ben Allen]

  - Add the bucardo_rate table to track exactly how long replication takes
    on a per-sync and per-table basis. [GSM]

  - Add more bucardo_ctl actions: install, reload, validate, restart, update [GSM]

  - Allow adding of all tables and sequences in a database at once via bucardo_ctl [GSM]

  - Add in bucardo_compress_delta function, to remove duplicate rows from
    the bucardo_delta table. [GSM]

  - Allow the injection of custom messages into the Bucardo logs, and make
    an interface for same in bucardo_ctl. [GSM]

  - Add the "warning_file" config parameter to log all 'Warning' messages. [GSM]

  - Add validate_all_syncs() function, and allow an argument to both that
    and validate_sync() to force recreation of supporting objects. [GSM]

Enhancements:

  - Remove 'Moose' dependency. [GSM]

  - Remove disable_triggers and disable_rules from the sync table.
    We simply choose pg_class or replica based on the version of the
    database in question. [GSM]

  - Rewrite the pushdelta sync method to be more efficient and safer. [GSM]

  - Change from Mail::Sendmail to Net::SMTP [Ben Allen]

  - Allow wildcards in the 'bucardo_ctl kick' [Josh Tolley]

  - Improve the FreeBSD scripts/bucardo_ctl.rc file [Ben Allen]

  - Add "sendmail" option to the customcode input. [Ben Allen]

  - Add 'bucardo_ctl upgrade' to make intra-version upgrades easy
    and automatic. [Selena Deckelmann and GSM]

  - Add more tests and improve existing ones. [Josh Tolley]

  - Force READ WRITE mode so Bucardo works on read only databases. [GSM]

  - Make the audit_pid table more useful. Use sequences instead of
    PIDs to find children. Allow for the audit_pid table to be toggled off. [GSM]

  - Remove the debugstderr and debugstdout options, as they never worked
    correctly anyway. [GSM]

  - When truncating during fullcopy, fallback to delete if it fails. [GSM]

  - On startup, all syncs that may have trigger-based notifies are
    initially kicked. [GSM]

  - MCP listens for pings during table validations. [GSM]

  - Have master_q use a trigger, not multiple rules. Remove the need
    for a separate create_child_q() function. [GSM]

  - Default for log_showtime is now 'scalar localtime' rather than
    epoch seconds. [GSM]

  - No longer require a reason for the "stop" action. [GSM]

  - Add INSTALL_BUCARDODIR for quick and dirty 'make install' [GSM]

Bug fixes:

  - Fix failure to disable/enable triggers when using pg_class and table
    and schema are words changed by quote_ident. [Ben Allen]

  - Tolerate incompatibility in DEFAULT of negative numbers between
    Postgres 8.2 and 8.3. [Jon Jensen]

  - Do better checking of bucardo_ctl executable when MCP is restarting. [Ben Allen]

  - Change timestamp to timestamptz where needed inside Bucardo.pm [Yan Farmawan]

  - Put schema in db_getconn calls [Alex Bahlai]

  - Record the proper PID for the MCP in the pid file [Goran Gugic]

  - Set the tcp_* defaults in bucardo_config to zero (system default). [GSM]

  - Allow for dead columns when checking attnums. [GSM]

  - Do not attempt respawn of MCP if mcp_dbproblem_sleep is 0. [GSM]

- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200909081016
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAkqmZ1sACgkQvJuQZxSWSsgX6gCg85jtBrAgFJWKNXmsu+1kD4Yj
j48AnR8uRytMkAFU7G/8qynuIQ85eYPl
=6zsA
-----END PGP SIGNATURE-----