bucardo.git
14 years agoRemove the makedelta_triggers option.
Greg Sabino Mullane [Fri, 22 Jul 2011 02:47:24 +0000 (22:47 -0400)]
Remove the makedelta_triggers option.
Lots of cleaning up and rearranging of the bucardo script.

14 years agoMore cleanup and overhaul of bucardo the script.
Greg Sabino Mullane [Thu, 21 Jul 2011 19:39:57 +0000 (15:39 -0400)]
More cleanup and overhaul of bucardo the script.

14 years agoA lot of minor cleanups and simplifications.
Greg Sabino Mullane [Thu, 21 Jul 2011 03:13:57 +0000 (23:13 -0400)]
A lot of minor cleanups and simplifications.

14 years agoMinor things: remove unused vars, better code comments.
Greg Sabino Mullane [Mon, 18 Jul 2011 21:20:17 +0000 (17:20 -0400)]
Minor things: remove unused vars, better code comments.

14 years agoHello, standard_conforming_strings: may as well keep you on now that 9.1 is here.
Greg Sabino Mullane [Sat, 16 Jul 2011 22:50:41 +0000 (18:50 -0400)]
Hello, standard_conforming_strings: may as well keep you on now that 9.1 is here.

14 years agoFix incorrect use of self->{dbh} when it should be s->{db}. Per bug report from Elso...
Greg Sabino Mullane [Sat, 16 Jul 2011 17:00:09 +0000 (13:00 -0400)]
Fix incorrect use of self->{dbh} when it should be s->{db}. Per bug report from Elso on the mailing list.

14 years agoFinish up the bucardo customname interface, with tests.
Greg Sabino Mullane [Sat, 16 Jul 2011 16:45:00 +0000 (12:45 -0400)]
Finish up the bucardo customname interface, with tests.
Clean up the upgrade process a bit.

14 years agoBasic Postgres target test
Greg Sabino Mullane [Sun, 10 Jul 2011 15:46:25 +0000 (11:46 -0400)]
Basic Postgres target test

14 years agoMake sure we have the 'name' column, but don't allow it to be specified
Greg Sabino Mullane [Sun, 10 Jul 2011 15:35:56 +0000 (11:35 -0400)]
Make sure we have the 'name' column, but don't allow it to be specified

14 years agoBegin interface for customname table
Greg Sabino Mullane [Sat, 9 Jul 2011 17:42:30 +0000 (13:42 -0400)]
Begin interface for customname table

14 years agoRemove the confusing --name= option from add database, based on feedback on the list.
Greg Sabino Mullane [Fri, 8 Jul 2011 02:41:03 +0000 (22:41 -0400)]
Remove the confusing --name= option from add database, based on feedback on the list.

14 years agoShow name of the dbgroup on list sync output
Greg Sabino Mullane [Tue, 5 Jul 2011 14:05:45 +0000 (10:05 -0400)]
Show name of the dbgroup on list sync output

14 years agoFix old debug code.
AOlmezov [Mon, 4 Jul 2011 22:03:52 +0000 (18:03 -0400)]
Fix old debug code.

14 years agoAdd in basic Redis support.
Greg Sabino Mullane [Fri, 1 Jul 2011 16:50:43 +0000 (12:50 -0400)]
Add in basic Redis support.
Make sure we add new tables before new columns when upgrading.
Rearrange all the databases, for consistent order of types.

14 years agoAdd 'does' attributes to the database objects.
Greg Sabino Mullane [Fri, 1 Jul 2011 15:22:13 +0000 (11:22 -0400)]
Add 'does' attributes to the database objects.

14 years agoSome cleanups of the fullcopy system.
Greg Sabino Mullane [Fri, 1 Jul 2011 15:00:21 +0000 (11:00 -0400)]
Some cleanups of the fullcopy system.
Not working yet.

14 years agoFinish up some loose ends for the customname feature.
Greg Sabino Mullane [Thu, 30 Jun 2011 13:59:34 +0000 (09:59 -0400)]
Finish up some loose ends for the customname feature.

14 years agoSupport for Drizzle. Untested.
Greg Sabino Mullane [Thu, 30 Jun 2011 13:25:32 +0000 (09:25 -0400)]
Support for Drizzle. Untested.

14 years agoOracle support. Untested!
Greg Sabino Mullane [Thu, 30 Jun 2011 12:12:32 +0000 (08:12 -0400)]
Oracle support. Untested!

14 years agoMild cleanups and some MySQL tweaks.
Greg Sabino Mullane [Thu, 30 Jun 2011 11:29:27 +0000 (07:29 -0400)]
Mild cleanups and some MySQL tweaks.

14 years agoCheck the state for all DBI databases.
Greg Sabino Mullane [Wed, 29 Jun 2011 13:21:54 +0000 (09:21 -0400)]
Check the state for all DBI databases.
Minor cleanups.

14 years agoIntroducing bucardo.customname - change the names of your target tables!
Greg Sabino Mullane [Wed, 29 Jun 2011 12:08:29 +0000 (08:08 -0400)]
Introducing bucardo.customname - change the names of your target tables!

14 years agoRemove the end_syncrun call from the controller, seems to be causing more problems...
Greg Sabino Mullane [Sun, 26 Jun 2011 21:08:07 +0000 (17:08 -0400)]
Remove the end_syncrun call from the controller, seems to be causing more problems than it solves.

14 years agoAdd a second sync for help in debugging.
Greg Sabino Mullane [Sun, 26 Jun 2011 03:24:38 +0000 (23:24 -0400)]
Add a second sync for help in debugging.

14 years agoElevate unknown notifications to warnings, and filter out other syncs' messages.
Greg Sabino Mullane [Sun, 26 Jun 2011 02:30:04 +0000 (22:30 -0400)]
Elevate unknown notifications to warnings, and filter out other syncs' messages.

14 years agoFix up the 'bucardo remove table' action.
Greg Sabino Mullane [Sun, 26 Jun 2011 02:06:23 +0000 (22:06 -0400)]
Fix up the 'bucardo remove table' action.

14 years agoLots of testing work.
Greg Sabino Mullane [Mon, 20 Jun 2011 16:54:22 +0000 (12:54 -0400)]
Lots of testing work.

14 years agoMerge in 4.4 changelist
Greg Sabino Mullane [Sun, 19 Jun 2011 11:10:47 +0000 (07:10 -0400)]
Merge in 4.4 changelist

14 years agoLog total items removed from Mongo collections.
Greg Sabino Mullane [Sun, 12 Jun 2011 00:20:09 +0000 (20:20 -0400)]
Log total items removed from Mongo collections.

14 years agoSet the data type when deleting from MongoDB as primary key.
Greg Sabino Mullane [Sat, 11 Jun 2011 17:28:27 +0000 (13:28 -0400)]
Set the data type when deleting from MongoDB as primary key.

14 years agoHTML docs for new name
Greg Sabino Mullane [Sat, 11 Jun 2011 16:34:41 +0000 (12:34 -0400)]
HTML docs for new name

14 years agoAdjust incoming strings to IV, NV, and boolean as needed for MongoDB inserts.
Greg Sabino Mullane [Sat, 11 Jun 2011 03:46:24 +0000 (23:46 -0400)]
Adjust incoming strings to IV, NV, and boolean as needed for MongoDB inserts.
Update required modules list

14 years agoMild cleanup of TODO
Greg Sabino Mullane [Sat, 11 Jun 2011 03:45:53 +0000 (23:45 -0400)]
Mild cleanup of TODO

14 years agoDo a global chomp of the buffer rather than worrying about mix-n-match chomp requirin...
Greg Sabino Mullane [Sat, 11 Jun 2011 01:56:43 +0000 (21:56 -0400)]
Do a global chomp of the buffer rather than worrying about mix-n-match chomp requiring types.

14 years agoMCP should handle synckill notices smoothly.
Greg Sabino Mullane [Fri, 10 Jun 2011 19:55:26 +0000 (15:55 -0400)]
MCP should handle synckill notices smoothly.

14 years agoBetter error message on failure to add dbgroup mapping.
Greg Sabino Mullane [Fri, 10 Jun 2011 19:21:20 +0000 (15:21 -0400)]
Better error message on failure to add dbgroup mapping.

14 years agoClean up 'bucardo add dbgroup' functionality. Allow --force argument to work.
Greg Sabino Mullane [Fri, 10 Jun 2011 15:52:11 +0000 (11:52 -0400)]
Clean up 'bucardo add dbgroup' functionality. Allow --force argument to work.

14 years agoClean up the delete_sync trigger.
Greg Sabino Mullane [Fri, 10 Jun 2011 15:05:08 +0000 (11:05 -0400)]
Clean up the delete_sync trigger.
May want to add the removed functionality back later, or make it a more explicit function.

14 years agoChange tests for new add database syntax
Greg Sabino Mullane [Fri, 10 Jun 2011 14:16:39 +0000 (10:16 -0400)]
Change tests for new add database syntax

14 years agoEnforce the 'bucardo add db' uses the next word as the internal name, to be consisten...
Greg Sabino Mullane [Fri, 10 Jun 2011 14:09:23 +0000 (10:09 -0400)]
Enforce the 'bucardo add db' uses the next word as the internal name, to be consistent with the other nouns.

14 years agoFix more tabs and version numbers.
Greg Sabino Mullane [Fri, 10 Jun 2011 02:05:14 +0000 (22:05 -0400)]
Fix more tabs and version numbers.

14 years agoI'm had it with these MF tabs in this MF code.
Greg Sabino Mullane [Fri, 10 Jun 2011 01:52:34 +0000 (21:52 -0400)]
I'm had it with these MF tabs in this MF code.

14 years agoRename 'bucardo_ctl' to just 'bucardo'. Yowza!
Greg Sabino Mullane [Mon, 6 Jun 2011 21:55:54 +0000 (17:55 -0400)]
Rename 'bucardo_ctl' to just 'bucardo'. Yowza!

14 years agoReport on the database port
Greg Sabino Mullane [Sun, 5 Jun 2011 22:29:17 +0000 (18:29 -0400)]
Report on the database port

14 years agoAdd this item so I don't forget about it.
Greg Sabino Mullane [Sun, 5 Jun 2011 20:32:45 +0000 (16:32 -0400)]
Add this item so I don't forget about it.

14 years agoRespect syncs' ping=false again.
Greg Sabino Mullane [Sun, 5 Jun 2011 04:22:13 +0000 (00:22 -0400)]
Respect syncs' ping=false again.
Fix whitespace

14 years agoFor the default conflict handler, go through all the dbs one-time only,
Greg Sabino Mullane [Sun, 5 Jun 2011 04:10:06 +0000 (00:10 -0400)]
For the default conflict handler, go through all the dbs one-time only,
then always stick with the "top" database for each row.

14 years agoSpeed up the default conflict handler by making suer we only
Greg Sabino Mullane [Sat, 4 Jun 2011 03:07:45 +0000 (23:07 -0400)]
Speed up the default conflict handler by making suer we only
visit each database once per table, rather than once per key.

14 years agoUse a "semaphore table" to allow a mongo app to somewhat observe atomic behavior.
Greg Sabino Mullane [Fri, 3 Jun 2011 02:55:42 +0000 (22:55 -0400)]
Use a "semaphore table" to allow a mongo app to somewhat observe atomic behavior.

14 years agoAllow odd versions such as "9.1beta1" to work
Greg Sabino Mullane [Fri, 3 Jun 2011 02:25:51 +0000 (22:25 -0400)]
Allow odd versions such as "9.1beta1" to work

14 years agoBetter logging, make sure we combine all conflict counts per sync.
Greg Sabino Mullane [Thu, 2 Jun 2011 21:53:41 +0000 (17:53 -0400)]
Better logging, make sure we combine all conflict counts per sync.

14 years agoRemove debug line
Greg Sabino Mullane [Thu, 2 Jun 2011 21:17:37 +0000 (17:17 -0400)]
Remove debug line

14 years agoCleanup the manifest.
Greg Sabino Mullane [Thu, 2 Jun 2011 15:19:59 +0000 (11:19 -0400)]
Cleanup the manifest.

14 years agoMinor fix for status changes on syncs
Greg Sabino Mullane [Tue, 31 May 2011 22:46:16 +0000 (18:46 -0400)]
Minor fix for status changes on syncs

14 years agoChange debug output to DEBUG
Greg Sabino Mullane [Mon, 30 May 2011 17:52:40 +0000 (13:52 -0400)]
Change debug output to DEBUG

14 years agoRemove some debugging output.
Greg Sabino Mullane [Mon, 30 May 2011 17:46:06 +0000 (13:46 -0400)]
Remove some debugging output.

14 years agoNo unlogged tables for now: Postgres bug is causing FATAL errors on truncate.
Greg Sabino Mullane [Mon, 30 May 2011 17:45:21 +0000 (13:45 -0400)]
No unlogged tables for now: Postgres bug is causing FATAL errors on truncate.

14 years agoFix up log_levels
Greg Sabino Mullane [Sun, 29 May 2011 12:26:09 +0000 (08:26 -0400)]
Fix up log_levels
Change back to exact 'active' status only.

14 years agoPut back in space
Greg Sabino Mullane [Sat, 28 May 2011 17:45:47 +0000 (13:45 -0400)]
Put back in space

14 years agoRemove debugging aid and allow log_levels to take affect again.
Greg Sabino Mullane [Sat, 28 May 2011 17:35:55 +0000 (13:35 -0400)]
Remove debugging aid and allow log_levels to take affect again.

14 years agoQuick cleanups.
Greg Sabino Mullane [Sat, 28 May 2011 03:25:25 +0000 (23:25 -0400)]
Quick cleanups.

14 years agoAllow alternate ways to say active.
Greg Sabino Mullane [Sat, 28 May 2011 03:25:09 +0000 (23:25 -0400)]
Allow alternate ways to say active.

14 years agoAdd tests for MySQL targets
Greg Sabino Mullane [Sat, 28 May 2011 02:42:47 +0000 (22:42 -0400)]
Add tests for MySQL targets

14 years agoOne-arg version of bucardo_purge_delta
Greg Sabino Mullane [Fri, 27 May 2011 19:47:34 +0000 (15:47 -0400)]
One-arg version of bucardo_purge_delta

14 years agoQuick check so people don't try to upgrade an existing 4 to v 5.
Greg Sabino Mullane [Fri, 27 May 2011 04:34:45 +0000 (00:34 -0400)]
Quick check so people don't try to upgrade an existing 4 to v 5.

14 years agoDo not try and change aliases function args!
Greg Sabino Mullane [Fri, 27 May 2011 04:31:49 +0000 (00:31 -0400)]
Do not try and change aliases function args!

14 years agoGet a new bucardo_purge_delta in place. Arguments are interval and "schema.table".
Greg Sabino Mullane [Fri, 27 May 2011 04:28:49 +0000 (00:28 -0400)]
Get a new bucardo_purge_delta in place. Arguments are interval and "schema.table".

14 years agoFat finger helper
Greg Sabino Mullane [Fri, 27 May 2011 04:28:29 +0000 (00:28 -0400)]
Fat finger helper

14 years agoBetter wording
Greg Sabino Mullane [Thu, 26 May 2011 03:54:42 +0000 (23:54 -0400)]
Better wording

14 years agoMinor MySQL tweaks.
Greg Sabino Mullane [Thu, 26 May 2011 03:54:24 +0000 (23:54 -0400)]
Minor MySQL tweaks.

14 years agoBe more explicit for ENV defaults, to prevent confusion with simple database names...
Greg Sabino Mullane [Thu, 26 May 2011 02:01:17 +0000 (22:01 -0400)]
Be more explicit for ENV defaults, to prevent confusion with simple database names such as "X"

14 years agoShow conflicts in lastgood for 'status'
Greg Sabino Mullane [Wed, 25 May 2011 19:01:32 +0000 (15:01 -0400)]
Show conflicts in lastgood for 'status'

14 years agoInitial attempt at MySQL target support.
Greg Sabino Mullane [Wed, 25 May 2011 18:24:21 +0000 (14:24 -0400)]
Initial attempt at MySQL target support.
More fixes for listen/notify.

14 years agoCleanup listen/notify for 9.0 and up
Greg Sabino Mullane [Tue, 24 May 2011 20:18:18 +0000 (16:18 -0400)]
Cleanup listen/notify for 9.0 and up

14 years agoAutomatically pick a db if none given when adding tables.
Greg Sabino Mullane [Mon, 23 May 2011 21:39:55 +0000 (17:39 -0400)]
Automatically pick a db if none given when adding tables.
Allow herd to be specified again when adding tables.

14 years agoComment out search_path per bucardo user for now.
Greg Sabino Mullane [Mon, 23 May 2011 21:00:11 +0000 (17:00 -0400)]
Comment out search_path per bucardo user for now.

14 years agoAllow for eventual verbose details on each syncrun
Greg Sabino Mullane [Mon, 23 May 2011 03:34:15 +0000 (23:34 -0400)]
Allow for eventual verbose details on each syncrun

14 years agoCleanup and redo some of the synrun system.
Greg Sabino Mullane [Mon, 23 May 2011 03:26:03 +0000 (23:26 -0400)]
Cleanup and redo some of the synrun system.
Get "status" and "status syncname" for bucardo_ctl working again.

14 years agoComplete basic Mongo tests
Greg Sabino Mullane [Thu, 19 May 2011 20:48:02 +0000 (16:48 -0400)]
Complete basic Mongo tests

14 years agoMongo tweaks.
Greg Sabino Mullane [Thu, 19 May 2011 20:47:42 +0000 (16:47 -0400)]
Mongo tweaks.
Fix for case when truncate but no deltas.

14 years agoAdd new test for testing MongoDB.
Greg Sabino Mullane [Thu, 19 May 2011 05:20:26 +0000 (01:20 -0400)]
Add new test for testing MongoDB.
Add some TODO items.

14 years agoTurn escaped nulls back into undef for mongo pushes.
Greg Sabino Mullane [Thu, 19 May 2011 05:18:52 +0000 (01:18 -0400)]
Turn escaped nulls back into undef for mongo pushes.

14 years agoBetter debug on initdb fail for testing.
Greg Sabino Mullane [Thu, 19 May 2011 04:52:25 +0000 (00:52 -0400)]
Better debug on initdb fail for testing.

14 years agoMinor fixes.
Greg Sabino Mullane [Thu, 19 May 2011 04:52:05 +0000 (00:52 -0400)]
Minor fixes.

14 years agoComment cleanups.
Greg Sabino Mullane [Thu, 19 May 2011 04:51:25 +0000 (00:51 -0400)]
Comment cleanups.

14 years agoFixups for bytea primary keys.
Greg Sabino Mullane [Thu, 19 May 2011 04:51:11 +0000 (00:51 -0400)]
Fixups for bytea primary keys.

14 years agoQuick fix for new bucardo_purge_delta function: still incomplete, but should compile.
Greg Sabino Mullane [Wed, 18 May 2011 16:57:27 +0000 (12:57 -0400)]
Quick fix for new bucardo_purge_delta function: still incomplete, but should compile.

14 years agoClean up and redo the sequences.
Greg Sabino Mullane [Wed, 18 May 2011 06:53:08 +0000 (02:53 -0400)]
Clean up and redo the sequences.

14 years agoSimplify the default standard_conflict: we only care which table was last touched...
Greg Sabino Mullane [Wed, 18 May 2011 00:00:33 +0000 (20:00 -0400)]
Simplify the default standard_conflict: we only care which table was last touched, not the details about which pk was changed.

14 years agoRe-establish the truncation system for non fullcopy syncs.
Greg Sabino Mullane [Tue, 17 May 2011 21:30:11 +0000 (17:30 -0400)]
Re-establish the truncation system for non fullcopy syncs.
Redo the mongo: use remove/insert, not update, plus other tweaks.
For flatfiles, only use the schema name if the type is flatpg

14 years agoRename targetdb to more accurate and generic target.
Greg Sabino Mullane [Mon, 16 May 2011 03:13:47 +0000 (23:13 -0400)]
Rename targetdb to more accurate and generic target.
Add some purging to the new truncate trigger.

14 years agoAnother backslash instance
Greg Sabino Mullane [Sun, 15 May 2011 02:20:13 +0000 (22:20 -0400)]
Another backslash instance

14 years agoFix severe backslash bug, per email from Gabriel Weinberg <yegg@alum.mit.edu>
Greg Sabino Mullane [Sun, 15 May 2011 02:13:36 +0000 (22:13 -0400)]
Fix severe backslash bug, per email from Gabriel Weinberg <yegg@alum.mit.edu>

14 years agoMinor cleanups
Greg Sabino Mullane [Sun, 15 May 2011 02:13:30 +0000 (22:13 -0400)]
Minor cleanups

14 years agoTried 2PC, does not really fit, used an alternate "stage" file system instead.
Greg Sabino Mullane [Fri, 13 May 2011 04:09:46 +0000 (00:09 -0400)]
Tried 2PC, does not really fit, used an alternate "stage" file system instead.

14 years agoQuick todo cleanup
Greg Sabino Mullane [Fri, 13 May 2011 04:09:33 +0000 (00:09 -0400)]
Quick todo cleanup

14 years agoBucardo 5 has arrived. Rough, but workable.
Greg Sabino Mullane [Fri, 13 May 2011 03:47:19 +0000 (23:47 -0400)]
Bucardo 5 has arrived. Rough, but workable.

14 years agoReady for 4.4.3 release
Greg Sabino Mullane [Fri, 15 Apr 2011 02:49:04 +0000 (22:49 -0400)]
Ready for 4.4.3 release

14 years agoSpaces, not tabs! 4.4.3
Greg Sabino Mullane [Fri, 15 Apr 2011 02:47:31 +0000 (22:47 -0400)]
Spaces, not tabs!

14 years agoMove the 9.0 SQL checks around a bit.
Greg Sabino Mullane [Thu, 14 Apr 2011 18:21:43 +0000 (14:21 -0400)]
Move the 9.0 SQL checks around a bit.