bucardo.git
13 years agoClean up recent subs
Greg Sabino Mullane [Sat, 12 Nov 2011 16:26:20 +0000 (11:26 -0500)]
Clean up recent subs

13 years agoTry to use appropriate database-specific commands for VACUUM and ANALYZE.
Wim Lewis [Wed, 2 Nov 2011 23:39:47 +0000 (16:39 -0700)]
Try to use appropriate database-specific commands for VACUUM and ANALYZE.

13 years agoQuote column names according to target db's quoting rules.
Wim Lewis [Mon, 31 Oct 2011 23:30:02 +0000 (16:30 -0700)]
Quote column names according to target db's quoting rules.

13 years agoNote long socket dir bug
Greg Sabino Mullane [Fri, 11 Nov 2011 03:59:21 +0000 (22:59 -0500)]
Note long socket dir bug

13 years agoDon't rely on $@ to catch eval
Greg Sabino Mullane [Tue, 8 Nov 2011 23:10:52 +0000 (18:10 -0500)]
Don't rely on $@ to catch eval

14 years agoShow error on truncation failure.
Greg Sabino Mullane [Mon, 7 Nov 2011 15:43:44 +0000 (10:43 -0500)]
Show error on truncation failure.

14 years agoFix typos, add explicit cperl indentation.
Wim Lewis [Thu, 3 Nov 2011 02:12:15 +0000 (22:12 -0400)]
Fix typos, add explicit cperl indentation.

14 years agoSet ANSI mode for MySQL databases.
Greg Sabino Mullane [Tue, 1 Nov 2011 00:53:22 +0000 (20:53 -0400)]
Set ANSI mode for MySQL databases.

14 years agoFirst version of update_table
Greg Sabino Mullane [Sun, 30 Oct 2011 01:03:52 +0000 (21:03 -0400)]
First version of update_table

14 years agoMake get_goat_ids() work in the hasadot case.
Wim Lewis [Wed, 26 Oct 2011 16:21:50 +0000 (12:21 -0400)]
Make get_goat_ids() work in the hasadot case.

14 years agoConsistent calling convention for get_goat_ids.
Wim Lewis [Wed, 26 Oct 2011 16:21:00 +0000 (12:21 -0400)]
Consistent calling convention for get_goat_ids.
Some callers were passing values, some were passing a hashref of key-value pairs.
Compromised on passing the key-value pairs directly.

14 years agoDon't print an undef when listing an empty herd.
Wim Lewis [Wed, 26 Oct 2011 16:20:02 +0000 (12:20 -0400)]
Don't print an undef when listing an empty herd.

14 years agoMinor testing tweak.
Greg Sabino Mullane [Wed, 26 Oct 2011 15:35:58 +0000 (11:35 -0400)]
Minor testing tweak.

14 years agoChange trigger name
Greg Sabino Mullane [Fri, 14 Oct 2011 18:49:33 +0000 (14:49 -0400)]
Change trigger name

14 years agoDisplay syncs and roles when doing list db -vv
Greg Sabino Mullane [Tue, 11 Oct 2011 02:53:10 +0000 (22:53 -0400)]
Display syncs and roles when doing list db -vv

14 years agoDo not show the gang (deprecated)
Greg Sabino Mullane [Tue, 11 Oct 2011 02:43:03 +0000 (22:43 -0400)]
Do not show the gang (deprecated)

14 years agoMake sure all dbtypes can be forced in.
Greg Sabino Mullane [Tue, 11 Oct 2011 02:42:36 +0000 (22:42 -0400)]
Make sure all dbtypes can be forced in.

14 years agoLittle less wordy in the install
Greg Sabino Mullane [Sat, 8 Oct 2011 03:46:56 +0000 (23:46 -0400)]
Little less wordy in the install

14 years agoFix typo in SQL generation bit
Greg Sabino Mullane [Wed, 5 Oct 2011 23:22:27 +0000 (19:22 -0400)]
Fix typo in SQL generation bit

14 years agoIn the install, reloop if we get a user or connection error to allow quick adjustment.
Greg Sabino Mullane [Sat, 1 Oct 2011 02:48:30 +0000 (22:48 -0400)]
In the install, reloop if we get a user or connection error to allow quick adjustment.

14 years agoTake out "batch" cheat for debugging.
Greg Sabino Mullane [Sat, 1 Oct 2011 02:38:41 +0000 (22:38 -0400)]
Take out "batch" cheat for debugging.
Allow alternate spellings of install

14 years agoVersion 4.99.2 (second public beta) 4.99.2
Greg Sabino Mullane [Thu, 29 Sep 2011 23:23:58 +0000 (19:23 -0400)]
Version 4.99.2 (second public beta)

14 years agoPerl::Critic tweaks
Greg Sabino Mullane [Thu, 29 Sep 2011 22:45:21 +0000 (18:45 -0400)]
Perl::Critic tweaks

14 years agoWhitespace
Greg Sabino Mullane [Thu, 29 Sep 2011 16:41:17 +0000 (12:41 -0400)]
Whitespace

14 years agoTesting tweaks
Greg Sabino Mullane [Thu, 29 Sep 2011 16:16:03 +0000 (12:16 -0400)]
Testing tweaks

14 years agoFilter out notices from "ourselves"
Greg Sabino Mullane [Thu, 29 Sep 2011 02:50:54 +0000 (22:50 -0400)]
Filter out notices from "ourselves"

14 years agoCTL should issue kid_stop_sync, not kid_stop
Greg Sabino Mullane [Thu, 29 Sep 2011 02:33:17 +0000 (22:33 -0400)]
CTL should issue kid_stop_sync, not kid_stop

14 years agoIn onetimecopy, check source before targets.
Greg Sabino Mullane [Thu, 29 Sep 2011 02:31:06 +0000 (22:31 -0400)]
In onetimecopy, check source before targets.
Make sure we do not continue if we have no valid targets for this goat.

14 years agoRemove 15-star.t
Greg Sabino Mullane [Wed, 28 Sep 2011 23:29:08 +0000 (19:29 -0400)]
Remove 15-star.t

14 years agoSpelling cleanups, other maintenance
Greg Sabino Mullane [Wed, 28 Sep 2011 23:28:32 +0000 (19:28 -0400)]
Spelling cleanups, other maintenance

14 years agoCleanup TODO list.
Greg Sabino Mullane [Wed, 28 Sep 2011 03:19:57 +0000 (23:19 -0400)]
Cleanup TODO list.

14 years agoTweak herd tests: still incomplete
Greg Sabino Mullane [Tue, 27 Sep 2011 23:37:26 +0000 (19:37 -0400)]
Tweak herd tests: still incomplete

14 years agoRemove double declaration: no need to export these here.
Greg Sabino Mullane [Tue, 27 Sep 2011 23:17:24 +0000 (19:17 -0400)]
Remove double declaration: no need to export these here.

14 years agoNote recent VAC
Greg Sabino Mullane [Tue, 27 Sep 2011 20:48:58 +0000 (16:48 -0400)]
Note recent VAC

14 years agoNew VAC daemon for automatically running bucardo_purge_delta
Greg Sabino Mullane [Tue, 27 Sep 2011 20:47:45 +0000 (16:47 -0400)]
New VAC daemon for automatically running bucardo_purge_delta

14 years agoAlways try USR1 first when signalling kids.
Greg Sabino Mullane [Tue, 27 Sep 2011 14:14:23 +0000 (10:14 -0400)]
Always try USR1 first when signalling kids.

14 years agoSwitch to explicit repeatable read. In 9.1, this is a separate level than serializabl...
Greg Sabino Mullane [Sun, 25 Sep 2011 15:51:33 +0000 (11:51 -0400)]
Switch to explicit repeatable read. In 9.1, this is a separate level than serializable, but we want what used to be serializable, as we don't need the overhead of ensuring specific ordering of commits. Before 9.1, repeatable read really acts like seriazliable anyway, so it's safe to say it there as well.

14 years agoMore updates.
Greg Sabino Mullane [Sun, 25 Sep 2011 03:37:42 +0000 (23:37 -0400)]
More updates.

14 years agoGet fullcopy working again, as well as onetimecopy.
Greg Sabino Mullane [Sun, 25 Sep 2011 03:34:11 +0000 (23:34 -0400)]
Get fullcopy working again, as well as onetimecopy.
Lots of changes and improvements over the originals.

14 years agoRename main trigger to bucardo_delta. Not only shorter, but may allow for concurrent...
Greg Sabino Mullane [Sun, 25 Sep 2011 02:41:11 +0000 (22:41 -0400)]
Rename main trigger to bucardo_delta. Not only shorter, but may allow for concurrent running with Bucardo 4.

14 years agoTesting tweak.
Greg Sabino Mullane [Thu, 22 Sep 2011 02:43:53 +0000 (22:43 -0400)]
Testing tweak.

14 years agoNote about race condition in testing.
Greg Sabino Mullane [Thu, 22 Sep 2011 02:42:04 +0000 (22:42 -0400)]
Note about race condition in testing.

14 years agoRecreate quick version of the update_sync function.
Greg Sabino Mullane [Sun, 18 Sep 2011 03:11:47 +0000 (23:11 -0400)]
Recreate quick version of the update_sync function.
Rearrange some subs

14 years agoAllow dbname:type as well as dbname=type
Greg Sabino Mullane [Sun, 18 Sep 2011 02:47:17 +0000 (22:47 -0400)]
Allow dbname:type as well as dbname=type

14 years agoChunking done
Greg Sabino Mullane [Sat, 17 Sep 2011 20:28:27 +0000 (16:28 -0400)]
Chunking done

14 years agoAdd statement_chunk_size logic to the COPY section
Greg Sabino Mullane [Sat, 17 Sep 2011 20:21:17 +0000 (16:21 -0400)]
Add statement_chunk_size logic to the COPY section

14 years agoBetter test wording.
Greg Sabino Mullane [Fri, 16 Sep 2011 17:05:41 +0000 (13:05 -0400)]
Better test wording.

14 years agoShow current chunk progress in SQL comments if > 1.
Greg Sabino Mullane [Fri, 16 Sep 2011 17:03:04 +0000 (13:03 -0400)]
Show current chunk progress in SQL comments if > 1.
Set statement_chunk_size to 2 for testing.

14 years agoNew var: statement_chunk_size
Greg Sabino Mullane [Fri, 16 Sep 2011 16:45:14 +0000 (12:45 -0400)]
New var: statement_chunk_size

14 years agoAllow deletion to proceed in chunks if needed.
Greg Sabino Mullane [Fri, 16 Sep 2011 03:05:19 +0000 (23:05 -0400)]
Allow deletion to proceed in chunks if needed.
Works, but needs refactoring.
COPY chunking still to come.

14 years agoUpdate TODO
Greg Sabino Mullane [Tue, 13 Sep 2011 23:32:40 +0000 (19:32 -0400)]
Update TODO

14 years agoOkay to use payloads on source databases for the kick signal; important thing is...
Greg Sabino Mullane [Tue, 13 Sep 2011 23:31:19 +0000 (19:31 -0400)]
Okay to use payloads on source databases for the kick signal; important thing is that the master database still uses old-school listen/notify.

14 years agoNotes some more TODOs
Greg Sabino Mullane [Tue, 13 Sep 2011 22:21:31 +0000 (18:21 -0400)]
Notes some more TODOs

14 years agoUnlogged is go...
Greg Sabino Mullane [Tue, 13 Sep 2011 17:37:30 +0000 (13:37 -0400)]
Unlogged is go...

14 years agoAdd SQLite support (as a target)
Greg Sabino Mullane [Sun, 11 Sep 2011 20:27:41 +0000 (16:27 -0400)]
Add SQLite support (as a target)

14 years agoAdd quick notes for what is left on version 5. Incomplete, but a start.
Greg Sabino Mullane [Sat, 10 Sep 2011 21:07:41 +0000 (17:07 -0400)]
Add quick notes for what is left on version 5. Incomplete, but a start.

14 years agoRemove deprecated options, and cleanup the 'bcuardo status' docs.
Greg Sabino Mullane [Sat, 10 Sep 2011 21:02:17 +0000 (17:02 -0400)]
Remove deprecated options, and cleanup the 'bcuardo status' docs.

14 years agoAllow 'status all' to show detailed information for all syncs
Greg Sabino Mullane [Sat, 10 Sep 2011 20:53:48 +0000 (16:53 -0400)]
Allow 'status all' to show detailed information for all syncs

14 years agoBump version in html files.
Greg Sabino Mullane [Sat, 10 Sep 2011 20:45:16 +0000 (16:45 -0400)]
Bump version in html files.

14 years agoGet 'status' and 'status <syncname>' working again.
Greg Sabino Mullane [Sat, 10 Sep 2011 20:45:02 +0000 (16:45 -0400)]
Get 'status' and 'status <syncname>' working again.

14 years agoTweaks for DBD::Oracle
Greg Sabino Mullane [Fri, 9 Sep 2011 19:43:22 +0000 (15:43 -0400)]
Tweaks for DBD::Oracle

14 years agocatfile not always exported in old versions!
Greg Sabino Mullane [Fri, 9 Sep 2011 03:20:02 +0000 (23:20 -0400)]
catfile not always exported in old versions!

14 years agoClean up 'bucardo database' tests
Greg Sabino Mullane [Tue, 6 Sep 2011 02:32:22 +0000 (22:32 -0400)]
Clean up 'bucardo database' tests

14 years agoYegods, the cloud is slow.
Greg Sabino Mullane [Mon, 5 Sep 2011 23:36:04 +0000 (19:36 -0400)]
Yegods, the cloud is slow.

14 years agoMake sure we pass @nouns as first arg to first call of recursive update_* routines.
Greg Sabino Mullane [Mon, 5 Sep 2011 22:17:22 +0000 (18:17 -0400)]
Make sure we pass @nouns as first arg to first call of recursive update_* routines.

14 years agoFix sync tests
Greg Sabino Mullane [Mon, 5 Sep 2011 14:01:56 +0000 (10:01 -0400)]
Fix sync tests

14 years agoWe don't need a second eval/alarm: the inner ctl() sub already does that now.
Greg Sabino Mullane [Mon, 5 Sep 2011 03:30:16 +0000 (23:30 -0400)]
We don't need a second eval/alarm: the inner ctl() sub already does that now.

14 years agoSlower alarm for slower boxes (hi EC2)
Greg Sabino Mullane [Mon, 5 Sep 2011 03:28:54 +0000 (23:28 -0400)]
Slower alarm for slower boxes (hi EC2)

14 years agoMake sure we repopulate the list of databases so we can immediately call add_all_tables.
Greg Sabino Mullane [Mon, 5 Sep 2011 03:27:48 +0000 (23:27 -0400)]
Make sure we repopulate the list of databases so we can immediately call add_all_tables.

14 years agoFixed bug with unlistening after a reload.
Greg Sabino Mullane [Sun, 4 Sep 2011 02:21:54 +0000 (22:21 -0400)]
Fixed bug with unlistening after a reload.
Don't freak out if minor schema differences occur when using customname.
Make sure we only unlisten to source databases for kicks.

14 years agoHandle properly the case where we have multiple targets but a customname on only...
Greg Sabino Mullane [Sun, 4 Sep 2011 01:29:10 +0000 (21:29 -0400)]
Handle properly the case where we have multiple targets but a customname on only some subset.

14 years agoWhen adding all tables, go ahead and find the best database automagically.
Greg Sabino Mullane [Sat, 3 Sep 2011 20:16:12 +0000 (16:16 -0400)]
When adding all tables, go ahead and find the best database automagically.

14 years agoDon't show already added tables if the number is zero.
Greg Sabino Mullane [Sat, 3 Sep 2011 13:17:07 +0000 (09:17 -0400)]
Don't show already added tables if the number is zero.

14 years agoAdd a level to the hash, now that the name can change between targets, and the |...
Greg Sabino Mullane [Sat, 3 Sep 2011 02:50:09 +0000 (22:50 -0400)]
Add a level to the hash, now that the name can change between targets, and the ||= is not sufficient.

14 years agoMake sure we always unlisten completely for non-payload messages.
Greg Sabino Mullane [Sat, 3 Sep 2011 02:43:56 +0000 (22:43 -0400)]
Make sure we always unlisten completely for non-payload messages.

14 years agoNewline after reload complete.
Greg Sabino Mullane [Sat, 3 Sep 2011 02:28:44 +0000 (22:28 -0400)]
Newline after reload complete.

14 years agoWho thought up that confusing s->{db} vs self->{sdb} stuff? Fixed problem preventing...
Greg Sabino Mullane [Sat, 3 Sep 2011 02:24:54 +0000 (22:24 -0400)]
Who thought up that confusing s->{db} vs self->{sdb} stuff? Fixed problem preventing bucardo reload syncname from working.

14 years agoChange version to 4.99.1
Greg Sabino Mullane [Sat, 3 Sep 2011 01:39:36 +0000 (21:39 -0400)]
Change version to 4.99.1

14 years agoAllow 'all' back in as a 'thing'
Greg Sabino Mullane [Fri, 2 Sep 2011 22:41:44 +0000 (18:41 -0400)]
Allow 'all' back in as a 'thing'

14 years agoNo more default password here.
Greg Sabino Mullane [Fri, 2 Sep 2011 20:16:28 +0000 (16:16 -0400)]
No more default password here.

14 years agoCreate the bucardo user before we call bucardo.schema
Greg Sabino Mullane [Fri, 2 Sep 2011 02:25:24 +0000 (22:25 -0400)]
Create the bucardo user before we call bucardo.schema
Store the password in the .pgpass file if we can.
Remove some password chars that cause problems in the shell.

14 years agoAdd DBIx::Safe to the required module list in the README.
Greg Sabino Mullane [Fri, 2 Sep 2011 01:42:55 +0000 (21:42 -0400)]
Add DBIx::Safe to the required module list in the README.

14 years agoSignature for 4.99.0 4.99.0
Greg Sabino Mullane [Wed, 31 Aug 2011 20:58:07 +0000 (16:58 -0400)]
Signature for 4.99.0

14 years agoChange to version 4.99.0 in preparation for first beta.
Greg Sabino Mullane [Wed, 31 Aug 2011 20:57:02 +0000 (16:57 -0400)]
Change to version 4.99.0 in preparation for first beta.

14 years agoRemove tabs
Greg Sabino Mullane [Wed, 31 Aug 2011 20:56:15 +0000 (16:56 -0400)]
Remove tabs

14 years agoFor deletion summary, show the customname if available.
Greg Sabino Mullane [Tue, 30 Aug 2011 03:33:48 +0000 (23:33 -0400)]
For deletion summary, show the customname if available.

14 years agoDon't show totals if all zeroes and we are in NORMAL logs or less.
Greg Sabino Mullane [Tue, 30 Aug 2011 03:26:52 +0000 (23:26 -0400)]
Don't show totals if all zeroes and we are in NORMAL logs or less.

14 years agoBetter message when trying to add a customname that already exists.
Greg Sabino Mullane [Tue, 30 Aug 2011 03:13:30 +0000 (23:13 -0400)]
Better message when trying to add a customname that already exists.

14 years agoClean up some of the customname interface.
Greg Sabino Mullane [Tue, 30 Aug 2011 03:00:34 +0000 (23:00 -0400)]
Clean up some of the customname interface.

14 years agoUse the proper customname for all validation checks.
Greg Sabino Mullane [Fri, 26 Aug 2011 19:27:55 +0000 (15:27 -0400)]
Use the proper customname for all validation checks.

14 years agoCommand-line interface to bucardo_purge, as well as a test for it.
Greg Sabino Mullane [Thu, 25 Aug 2011 03:35:31 +0000 (23:35 -0400)]
Command-line interface to bucardo_purge, as well as a test for it.

14 years agoMinor testing tweaks.
Greg Sabino Mullane [Sat, 20 Aug 2011 03:36:08 +0000 (23:36 -0400)]
Minor testing tweaks.

14 years agoShow file name when we cannot start due to previous process running.
Greg Sabino Mullane [Fri, 19 Aug 2011 21:31:37 +0000 (17:31 -0400)]
Show file name when we cannot start due to previous process running.

14 years agoIf no syncs found, go through the whole cleanup anyway - mostly to remove the MCP...
Greg Sabino Mullane [Fri, 19 Aug 2011 20:38:01 +0000 (16:38 -0400)]
If no syncs found, go through the whole cleanup anyway - mostly to remove the MCP PID file.

14 years agoCommit mostly done work in progress for the new customcols feature.
Greg Sabino Mullane [Thu, 11 Aug 2011 03:11:52 +0000 (23:11 -0400)]
Commit mostly done work in progress for the new customcols feature.
Basically, this allows your targets to have any table structure at all!

14 years agoQuick script to keep me honest
Greg Sabino Mullane [Sat, 23 Jul 2011 20:33:11 +0000 (16:33 -0400)]
Quick script to keep me honest

14 years agoBig chunk of bucardo script cleanups
Greg Sabino Mullane [Sat, 23 Jul 2011 20:32:34 +0000 (16:32 -0400)]
Big chunk of bucardo script cleanups

14 years agoMore escape tweaking.
Greg Sabino Mullane [Sat, 23 Jul 2011 20:26:42 +0000 (16:26 -0400)]
More escape tweaking.

14 years agoMore cleanups of the bucardo script
Greg Sabino Mullane [Fri, 22 Jul 2011 15:45:08 +0000 (11:45 -0400)]
More cleanups of the bucardo script

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.