bucardo.git
13 years agoThere are some other related issues, but might as well fix this up in a commit.
Greg Sabino Mullane [Wed, 14 Mar 2012 12:58:00 +0000 (08:58 -0400)]
There are some other related issues, but might as well fix this up in a commit.

13 years agoAllow timestamp columns to not match on startup.
Greg Sabino Mullane [Thu, 8 Mar 2012 20:44:46 +0000 (15:44 -0500)]
Allow timestamp columns to not match on startup.

13 years agoFix up quoting of tablenames.
Greg Sabino Mullane [Thu, 8 Mar 2012 20:41:09 +0000 (15:41 -0500)]
Fix up quoting of tablenames.
Redo the truncate support.
Test with mixed-case tablenames.

13 years agoTest counting tweaks.
Greg Sabino Mullane [Fri, 2 Mar 2012 19:35:54 +0000 (14:35 -0500)]
Test counting tweaks.

13 years agoSequence testing.
Greg Sabino Mullane [Fri, 2 Mar 2012 04:47:41 +0000 (23:47 -0500)]
Sequence testing.

13 years agoFixes for sequences
Greg Sabino Mullane [Fri, 2 Mar 2012 04:47:13 +0000 (23:47 -0500)]
Fixes for sequences

13 years agoAdd tests for sequences.
Greg Sabino Mullane [Tue, 28 Feb 2012 15:27:27 +0000 (10:27 -0500)]
Add tests for sequences.

13 years agoDo not show "old" sequence information if this is a fullcopy, as we are simply blowin...
Greg Sabino Mullane [Tue, 28 Feb 2012 15:09:00 +0000 (10:09 -0500)]
Do not show "old" sequence information if this is a fullcopy, as we are simply blowing it away.

13 years agoMake it easier to add sequences to a herd
Greg Sabino Mullane [Tue, 28 Feb 2012 14:56:07 +0000 (09:56 -0500)]
Make it easier to add sequences to a herd

13 years agoTesting infra: detect sequence diffs.
Greg Sabino Mullane [Tue, 28 Feb 2012 13:39:38 +0000 (08:39 -0500)]
Testing infra: detect sequence diffs.

13 years agoMore support for my horrible typing skills.
Greg Sabino Mullane [Mon, 27 Feb 2012 21:31:36 +0000 (16:31 -0500)]
More support for my horrible typing skills.

13 years agoRemove debug message.
Greg Sabino Mullane [Mon, 27 Feb 2012 21:15:46 +0000 (16:15 -0500)]
Remove debug message.

13 years agoTesting cleanups.
Greg Sabino Mullane [Mon, 27 Feb 2012 21:15:15 +0000 (16:15 -0500)]
Testing cleanups.

13 years agoBetter summary output.
Greg Sabino Mullane [Mon, 27 Feb 2012 12:47:25 +0000 (07:47 -0500)]
Better summary output.

13 years agoMore support for non-standard table names.h
Greg Sabino Mullane [Mon, 27 Feb 2012 12:37:01 +0000 (07:37 -0500)]
More support for non-standard table names.h

13 years agoAdd table with a space to the tests, small adjustments so such tables work.
Greg Sabino Mullane [Sun, 26 Feb 2012 13:11:22 +0000 (08:11 -0500)]
Add table with a space to the tests, small adjustments so such tables work.

13 years agoCleanup the fullcopy test, and refactor things into BucardoTesting.pm
Greg Sabino Mullane [Sun, 26 Feb 2012 00:36:11 +0000 (19:36 -0500)]
Cleanup the fullcopy test, and refactor things into BucardoTesting.pm

13 years agoMore fullcopy/onetimecopy changes.
Greg Sabino Mullane [Sat, 25 Feb 2012 05:31:01 +0000 (00:31 -0500)]
More fullcopy/onetimecopy changes.

13 years agoMessages cleaning
Greg Sabino Mullane [Sat, 25 Feb 2012 05:30:33 +0000 (00:30 -0500)]
Messages cleaning

13 years agoMore cleanup of the fullcopy/onetimecopy system.
Greg Sabino Mullane [Sat, 25 Feb 2012 04:48:02 +0000 (23:48 -0500)]
More cleanup of the fullcopy/onetimecopy system.

13 years agoStill on the fence about repeatable read vs serializable, but let's aim for less...
Greg Sabino Mullane [Fri, 24 Feb 2012 19:15:52 +0000 (14:15 -0500)]
Still on the fence about repeatable read vs serializable, but let's aim for less deadlocks with some slight overhead for the true serializability. See my blog post for more :)

13 years agoShow if a sync is fullcopy or not
Greg Sabino Mullane [Fri, 24 Feb 2012 17:45:29 +0000 (12:45 -0500)]
Show if a sync is fullcopy or not

13 years agoOnly run the VAC daemon if we have eligible databases.
Greg Sabino Mullane [Fri, 24 Feb 2012 17:42:39 +0000 (12:42 -0500)]
Only run the VAC daemon if we have eligible databases.

13 years agoFix typo regarding piddir
Greg Sabino Mullane [Fri, 24 Feb 2012 13:34:50 +0000 (08:34 -0500)]
Fix typo regarding piddir

13 years agoVAC daemon cleanups
Greg Sabino Mullane [Fri, 24 Feb 2012 04:44:35 +0000 (23:44 -0500)]
VAC daemon cleanups

13 years agoWrong setting!
Greg Sabino Mullane [Fri, 24 Feb 2012 04:37:20 +0000 (23:37 -0500)]
Wrong setting!

13 years agoMake sure vac cannot accidentally use other database handles.
Greg Sabino Mullane [Thu, 23 Feb 2012 23:16:25 +0000 (18:16 -0500)]
Make sure vac cannot accidentally use other database handles.

13 years agoHandle schema-less vacuum attempts gracefully.
Greg Sabino Mullane [Thu, 23 Feb 2012 21:51:49 +0000 (16:51 -0500)]
Handle schema-less vacuum attempts gracefully.
Should be rare in the future as we will filter those dbs out earlier.

13 years agoTesting tweaks.
Greg Sabino Mullane [Thu, 23 Feb 2012 21:32:57 +0000 (16:32 -0500)]
Testing tweaks.

13 years agoFix up "bestdb" bits
Greg Sabino Mullane [Thu, 23 Feb 2012 21:27:35 +0000 (16:27 -0500)]
Fix up "bestdb" bits

13 years agoTypo in herdmap lookup
Greg Sabino Mullane [Thu, 23 Feb 2012 21:18:34 +0000 (16:18 -0500)]
Typo in herdmap lookup

13 years agoBetter fullcopy support in validate_sync
Greg Sabino Mullane [Thu, 23 Feb 2012 21:07:36 +0000 (16:07 -0500)]
Better fullcopy support in validate_sync

13 years agoRearrange bucardo_config into the more standard "name" and "setting"
Greg Sabino Mullane [Thu, 23 Feb 2012 19:00:22 +0000 (14:00 -0500)]
Rearrange bucardo_config into the more standard "name" and "setting"
Add sync.synctype back in, so we can tell 'delta' from 'fullcopy'

13 years agoMove the alter database after the create schema
Greg Sabino Mullane [Fri, 10 Feb 2012 13:39:54 +0000 (08:39 -0500)]
Move the alter database after the create schema

13 years agoBump to 4.99.4
Greg Sabino Mullane [Fri, 10 Feb 2012 13:30:19 +0000 (08:30 -0500)]
Bump to 4.99.4

13 years agoAllow alternate spelling of tables
Greg Sabino Mullane [Sun, 5 Feb 2012 23:54:53 +0000 (18:54 -0500)]
Allow alternate spelling of tables

13 years agoAllow alternate underscore format for bucardo, e.g. "bucardo list_dbgroups"
Greg Sabino Mullane [Wed, 1 Feb 2012 14:44:57 +0000 (09:44 -0500)]
Allow alternate underscore format for bucardo, e.g. "bucardo list_dbgroups"

13 years agoBump to 2012
Greg Sabino Mullane [Wed, 1 Feb 2012 14:41:15 +0000 (09:41 -0500)]
Bump to 2012

13 years agoMinor cleanups to the <verb>_database functions.
Greg Sabino Mullane [Tue, 24 Jan 2012 00:59:23 +0000 (19:59 -0500)]
Minor cleanups to the <verb>_database functions.

13 years agoMajor refactoring of the add_database function
Greg Sabino Mullane [Sun, 22 Jan 2012 22:54:39 +0000 (17:54 -0500)]
Major refactoring of the add_database function

13 years agoClean up add_database help, remove sourcelimit and targetlimit
Greg Sabino Mullane [Sun, 22 Jan 2012 21:41:52 +0000 (16:41 -0500)]
Clean up add_database help, remove sourcelimit and targetlimit

13 years agoHandle missing public schema
Greg Sabino Mullane [Fri, 20 Jan 2012 17:17:15 +0000 (12:17 -0500)]
Handle missing public schema

13 years agoSmall add_db tweasks.
Greg Sabino Mullane [Thu, 19 Jan 2012 22:09:10 +0000 (17:09 -0500)]
Small add_db tweasks.

13 years agoClean up add_database arguments
Greg Sabino Mullane [Thu, 19 Jan 2012 20:12:21 +0000 (15:12 -0500)]
Clean up add_database arguments

13 years agoPull in changes from the old branch
Greg Sabino Mullane [Thu, 19 Jan 2012 19:12:07 +0000 (14:12 -0500)]
Pull in changes from the old branch

13 years agoSequence reminder 4.99.3
Greg Sabino Mullane [Thu, 19 Jan 2012 19:06:40 +0000 (14:06 -0500)]
Sequence reminder

13 years agoQuick sleep in this test
Greg Sabino Mullane [Thu, 5 Jan 2012 21:48:27 +0000 (16:48 -0500)]
Quick sleep in this test

13 years agoMake sure we commit so we don't have the truncates waiting too long in the tests.
Greg Sabino Mullane [Thu, 5 Jan 2012 21:10:01 +0000 (16:10 -0500)]
Make sure we commit so we don't have the truncates waiting too long in the tests.

13 years agoNo need to complain about a failed unlink if the file is not there.
Greg Sabino Mullane [Thu, 5 Jan 2012 21:05:58 +0000 (16:05 -0500)]
No need to complain about a failed unlink if the file is not there.

13 years agosourcelimit and targetlimit no longer being used
Greg Sabino Mullane [Mon, 2 Jan 2012 05:48:20 +0000 (00:48 -0500)]
sourcelimit and targetlimit no longer being used

13 years agoCleanup; remove some unused configuration vars
Greg Sabino Mullane [Mon, 2 Jan 2012 05:46:23 +0000 (00:46 -0500)]
Cleanup; remove some unused configuration vars

13 years agoNo need for freezer schema anymore. Note how to invoke
Greg Sabino Mullane [Mon, 2 Jan 2012 05:30:38 +0000 (00:30 -0500)]
No need for freezer schema anymore. Note how to invoke

13 years agoRemove test SQLite database file on make clean
Greg Sabino Mullane [Mon, 2 Jan 2012 05:28:02 +0000 (00:28 -0500)]
Remove test SQLite database file on make clean

13 years agoDon't worry about other messages if we are a VAC process.
Greg Sabino Mullane [Fri, 16 Dec 2011 19:16:10 +0000 (14:16 -0500)]
Don't worry about other messages if we are a VAC process.

13 years agoName is "stopsync" not "stop_sync". Per error report from the list.
Greg Sabino Mullane [Fri, 16 Dec 2011 19:14:15 +0000 (14:14 -0500)]
Name is "stopsync" not "stop_sync". Per error report from the list.

13 years agoUse File::Spec->catfile everywhere
Greg Sabino Mullane [Fri, 16 Dec 2011 18:51:11 +0000 (13:51 -0500)]
Use File::Spec->catfile everywhere

13 years agoNo sense in having a full shebang, this should only ever be required by the Bucardo...
Greg Sabino Mullane [Fri, 16 Dec 2011 13:04:46 +0000 (08:04 -0500)]
No sense in having a full shebang, this should only ever be required by the Bucardo program.
Mild comment cleanup.

13 years agoFix misspelling
Jon Jensen [Thu, 15 Dec 2011 23:10:51 +0000 (16:10 -0700)]
Fix misspelling

13 years agoAdd git path
Greg Sabino Mullane [Thu, 15 Dec 2011 06:24:05 +0000 (01:24 -0500)]
Add git path

13 years agoMinor tweaks
Greg Sabino Mullane [Mon, 12 Dec 2011 04:43:25 +0000 (23:43 -0500)]
Minor tweaks

13 years agoFew more gitignore additions.
Greg Sabino Mullane [Sun, 11 Dec 2011 12:04:33 +0000 (07:04 -0500)]
Few more gitignore additions.

13 years agoMinor tweaks
Greg Sabino Mullane [Sun, 11 Dec 2011 03:45:28 +0000 (22:45 -0500)]
Minor tweaks

13 years agoMinor cleanups
Greg Sabino Mullane [Sun, 11 Dec 2011 01:27:15 +0000 (20:27 -0500)]
Minor cleanups

13 years agoSpelling tweaks
Greg Sabino Mullane [Sat, 10 Dec 2011 17:34:29 +0000 (12:34 -0500)]
Spelling tweaks

13 years agoFix for Booleans in Mongo.
Greg Sabino Mullane [Sat, 10 Dec 2011 03:54:44 +0000 (22:54 -0500)]
Fix for Booleans in Mongo.
Make sure we commit in mongo tests to our truncate does not hang!

13 years agoRemove unwanted rollback calls from sqlite tests.
Greg Sabino Mullane [Thu, 8 Dec 2011 05:15:32 +0000 (00:15 -0500)]
Remove unwanted rollback calls from sqlite tests.

13 years agoTesting tweaks.
Greg Sabino Mullane [Thu, 8 Dec 2011 05:10:08 +0000 (00:10 -0500)]
Testing tweaks.

13 years agoMake sure we use the MySQL table stuff for the tests.
Greg Sabino Mullane [Wed, 7 Dec 2011 03:28:42 +0000 (22:28 -0500)]
Make sure we use the MySQL table stuff for the tests.

13 years agoSet GMT for MySQL
Greg Sabino Mullane [Wed, 7 Dec 2011 03:27:46 +0000 (22:27 -0500)]
Set GMT for MySQL

13 years agoSince somebody asked, put DB2 on the todo list.
Greg Sabino Mullane [Tue, 6 Dec 2011 21:07:05 +0000 (16:07 -0500)]
Since somebody asked, put DB2 on the todo list.

13 years agoAdd 'booly' column to the Mongo tests.
Greg Sabino Mullane [Tue, 6 Dec 2011 00:57:07 +0000 (19:57 -0500)]
Add 'booly' column to the Mongo tests.

13 years agoTest cleanups, especially with regards to true/false vs. 1/0
Greg Sabino Mullane [Mon, 5 Dec 2011 13:16:54 +0000 (08:16 -0500)]
Test cleanups, especially with regards to true/false vs. 1/0

13 years agoArrays start at 0, not 1
Greg Sabino Mullane [Mon, 5 Dec 2011 04:12:12 +0000 (23:12 -0500)]
Arrays start at 0, not 1

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