Bucardo version 4.0.0 released

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-announce(at)postgresql(dot)org
Subject: Bucardo version 4.0.0 released
Date: 2009-09-08 14:17:21
Message-ID: 7573d953778f64765de7f13937cda75e@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)turnstep(dot)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-----

Browse pgsql-announce by date

  From Date Subject
Next Message Joshua D. Drake 2009-09-08 18:13:28 PostgreSQL Conference West (10/16-10/18) registration now open
Previous Message David Fetter 2009-09-07 02:04:56 == PostgreSQL Weekly News - September 06 2009 ==