bucardo.git
13 years agoMinor testing tweak.
Greg Sabino Mullane [Mon, 5 Dec 2011 00:06:35 +0000 (19:06 -0500)]
Minor testing tweak.

13 years agoNote which source database we end up choosing for a fullcopy.
Greg Sabino Mullane [Mon, 5 Dec 2011 00:06:16 +0000 (19:06 -0500)]
Note which source database we end up choosing for a fullcopy.

13 years agoBytea fixes: use the database encode rather than the script one, and put it in both...
Greg Sabino Mullane [Sun, 4 Dec 2011 22:17:15 +0000 (17:17 -0500)]
Bytea fixes: use the database encode rather than the script one, and put it in both the initial delta select and the matching delta select.

13 years agoBetter test output.
Greg Sabino Mullane [Sat, 3 Dec 2011 04:32:27 +0000 (23:32 -0500)]
Better test output.

13 years agoTypo
Greg Sabino Mullane [Fri, 2 Dec 2011 22:02:53 +0000 (17:02 -0500)]
Typo

13 years agoMore ideas
Greg Sabino Mullane [Thu, 1 Dec 2011 03:35:29 +0000 (22:35 -0500)]
More ideas

13 years agoAutomated cleanups are done
Greg Sabino Mullane [Thu, 1 Dec 2011 03:32:36 +0000 (22:32 -0500)]
Automated cleanups are done

13 years agoAdd new todo item
Greg Sabino Mullane [Thu, 1 Dec 2011 03:26:28 +0000 (22:26 -0500)]
Add new todo item

13 years agoDo not send email if a kid dies due to a ctl request.
Greg Sabino Mullane [Thu, 1 Dec 2011 00:23:11 +0000 (19:23 -0500)]
Do not send email if a kid dies due to a ctl request.

13 years agoBetter 'list tables' display, tweak the tests.
Greg Sabino Mullane [Wed, 30 Nov 2011 15:50:40 +0000 (10:50 -0500)]
Better 'list tables' display, tweak the tests.

13 years agoTry harder to slurp in matching tables when doing 'bucardo add table ...'
Greg Sabino Mullane [Wed, 30 Nov 2011 04:11:14 +0000 (23:11 -0500)]
Try harder to slurp in matching tables when doing 'bucardo add table ...'

13 years agoWhitespace and typo
Greg Sabino Mullane [Wed, 30 Nov 2011 03:32:53 +0000 (22:32 -0500)]
Whitespace and typo

13 years agoQuick script to setup things for command-line testing.
Greg Sabino Mullane [Sun, 27 Nov 2011 03:20:03 +0000 (22:20 -0500)]
Quick script to setup things for command-line testing.

13 years agoNewlines on certain error messages.
Greg Sabino Mullane [Sun, 27 Nov 2011 00:18:10 +0000 (19:18 -0500)]
Newlines on certain error messages.

13 years agoAdd -vv to list_tables
Greg Sabino Mullane [Sun, 27 Nov 2011 00:16:40 +0000 (19:16 -0500)]
Add -vv to list_tables

13 years agoShow syncs in 'list tables' output
Greg Sabino Mullane [Sat, 26 Nov 2011 01:19:47 +0000 (20:19 -0500)]
Show syncs in 'list tables' output

13 years agoTake out commented-out line regarding search_path
Greg Sabino Mullane [Sat, 26 Nov 2011 01:05:49 +0000 (20:05 -0500)]
Take out commented-out line regarding search_path

13 years agoMake batch install a little less verbose.
Greg Sabino Mullane [Fri, 25 Nov 2011 16:13:27 +0000 (11:13 -0500)]
Make batch install a little less verbose.

13 years agoWork in progress on list tables
Greg Sabino Mullane [Fri, 25 Nov 2011 16:09:37 +0000 (11:09 -0500)]
Work in progress on list tables

13 years agoUpdates to TODO
Greg Sabino Mullane [Wed, 23 Nov 2011 15:51:05 +0000 (10:51 -0500)]
Updates to TODO

13 years agoBetter handling of kid "auto-kick"
Greg Sabino Mullane [Wed, 23 Nov 2011 15:49:24 +0000 (10:49 -0500)]
Better handling of kid "auto-kick"

13 years agoRemove unused argument.
Greg Sabino Mullane [Wed, 23 Nov 2011 15:35:21 +0000 (10:35 -0500)]
Remove unused argument.

13 years agoTranslate boolean syntax for non-PGSQL backends.
Wim Lewis [Wed, 23 Nov 2011 00:48:09 +0000 (16:48 -0800)]
Translate boolean syntax for non-PGSQL backends.

Signed-off-by: Greg Sabino Mullane <greg@endpoint.com>
13 years agoAdding tests for BOOLEAN types. Every database treats booleans slightly differently...
Wim Lewis [Wed, 23 Nov 2011 00:45:59 +0000 (16:45 -0800)]
Adding tests for BOOLEAN types. Every database treats booleans slightly differently. This just tests the PostgreSQL, MySQL, and SQLite backends.

Signed-off-by: Greg Sabino Mullane <greg@endpoint.com>
13 years agoSafety check was reversed.
Greg Sabino Mullane [Mon, 21 Nov 2011 03:30:42 +0000 (22:30 -0500)]
Safety check was reversed.

13 years agoBump version in html files
Greg Sabino Mullane [Sat, 19 Nov 2011 22:08:01 +0000 (17:08 -0500)]
Bump version in html files

13 years agoNote recent change
Greg Sabino Mullane [Sat, 19 Nov 2011 03:27:48 +0000 (22:27 -0500)]
Note recent change

13 years agoChange pgpid field from SMALLINT to INTEGER.
Wim Lewis [Sat, 19 Nov 2011 03:27:36 +0000 (22:27 -0500)]
Change pgpid field from SMALLINT to INTEGER.

13 years agoNote about the gotos
Greg Sabino Mullane [Fri, 18 Nov 2011 19:48:46 +0000 (14:48 -0500)]
Note about the gotos

13 years agoBugzilla!
Greg Sabino Mullane [Tue, 15 Nov 2011 02:28:23 +0000 (21:28 -0500)]
Bugzilla!

13 years agoRemove unused subroutines
Greg Sabino Mullane [Sat, 12 Nov 2011 20:56:50 +0000 (15:56 -0500)]
Remove unused subroutines

13 years agoVersion bump
Greg Sabino Mullane [Sat, 12 Nov 2011 16:37:08 +0000 (11:37 -0500)]
Version bump

13 years agolist_tables work: incomplete
Greg Sabino Mullane [Sat, 12 Nov 2011 16:35:18 +0000 (11:35 -0500)]
list_tables work: incomplete

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

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