bucardo.git
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.

14 years agoDon't check pg_listener when deactivating syncs if backend is 9 or better.
Greg Sabino Mullane [Thu, 14 Apr 2011 18:19:48 +0000 (14:19 -0400)]
Don't check pg_listener when deactivating syncs if backend is 9 or better.

14 years agoNote 4.4.3 patch.
Greg Sabino Mullane [Thu, 14 Apr 2011 18:10:55 +0000 (14:10 -0400)]
Note 4.4.3 patch.
Bump to version 4.4.3 everywhere.

14 years agoMake sure we commit to target before master, to fix rare race condition.
Greg Sabino Mullane [Thu, 14 Apr 2011 18:07:30 +0000 (14:07 -0400)]
Make sure we commit to target before master, to fix rare race condition.
Bump version to 4.4.3

14 years agoReady for 4.4.2 release 4.4.2
Greg Sabino Mullane [Thu, 17 Mar 2011 00:45:21 +0000 (20:45 -0400)]
Ready for 4.4.2 release

14 years agoDon't test glog calls yet.
Greg Sabino Mullane [Wed, 16 Mar 2011 13:31:23 +0000 (09:31 -0400)]
Don't test glog calls yet.

14 years agoGet everything back to a consistent 4.4.2 and prepare for a release.
Greg Sabino Mullane [Tue, 15 Mar 2011 23:22:22 +0000 (19:22 -0400)]
Get everything back to a consistent 4.4.2 and prepare for a release.
Bucardo 5 will be its own branch, more than likely.

15 years agoTime zone adjustment should be local to the function.
Greg Sabino Mullane [Tue, 9 Nov 2010 14:57:02 +0000 (09:57 -0500)]
Time zone adjustment should be local to the function.

15 years agoMinor comment tweaks.
Greg Sabino Mullane [Thu, 9 Sep 2010 20:00:56 +0000 (16:00 -0400)]
Minor comment tweaks.

15 years agoOnly show msec to three places in log
Greg Sabino Mullane [Thu, 9 Sep 2010 19:55:14 +0000 (15:55 -0400)]
Only show msec to three places in log

15 years agoLoad async constants for DBD::Pg
Greg Sabino Mullane [Thu, 9 Sep 2010 19:54:23 +0000 (15:54 -0400)]
Load async constants for DBD::Pg

15 years agoFlush out subroutine comment headers
Greg Sabino Mullane [Thu, 9 Sep 2010 19:52:58 +0000 (15:52 -0400)]
Flush out subroutine comment headers

15 years agoReport DBI and DBD::Pg versions in log on startup
Greg Sabino Mullane [Thu, 9 Sep 2010 19:51:12 +0000 (15:51 -0400)]
Report DBI and DBD::Pg versions in log on startup

15 years agoLatest Changes
Greg Sabino Mullane [Tue, 7 Sep 2010 17:41:42 +0000 (13:41 -0400)]
Latest Changes

15 years agoAllow 'bucardo_ctl status' to run even if piddir is not available.
Greg Sabino Mullane [Tue, 7 Sep 2010 17:41:06 +0000 (13:41 -0400)]
Allow 'bucardo_ctl status' to run even if piddir is not available.

15 years agoRemove perlcritic pragmas - no longer needed.
Greg Sabino Mullane [Sun, 5 Sep 2010 19:28:55 +0000 (15:28 -0400)]
Remove perlcritic pragmas - no longer needed.

15 years agoUpdate Changes file
Greg Sabino Mullane [Thu, 2 Sep 2010 23:47:19 +0000 (19:47 -0400)]
Update Changes file

15 years agoAdd 'default_standard_conflict' setting, per idea from Franz Dürr.
Greg Sabino Mullane [Thu, 2 Sep 2010 23:42:42 +0000 (19:42 -0400)]
Add 'default_standard_conflict' setting, per idea from Franz Dürr.

15 years agoUpdate the Changes file.
Greg Sabino Mullane [Thu, 2 Sep 2010 20:35:42 +0000 (16:35 -0400)]
Update the Changes file.

15 years agoFix for timestamptz testing.
Greg Sabino Mullane [Thu, 2 Sep 2010 16:09:51 +0000 (12:09 -0400)]
Fix for timestamptz testing.

15 years agoForce GMT timezone for better timestamptz comparisons.
Greg Sabino Mullane [Thu, 2 Sep 2010 16:09:31 +0000 (12:09 -0400)]
Force GMT timezone for better timestamptz comparisons.

15 years agoSupport new table types.
Greg Sabino Mullane [Thu, 2 Sep 2010 15:24:41 +0000 (11:24 -0400)]
Support new table types.

15 years agoAdd timestamptz tabletype to tests.
Greg Sabino Mullane [Thu, 2 Sep 2010 15:24:15 +0000 (11:24 -0400)]
Add timestamptz tabletype to tests.

15 years agoPatch file for common question regarding 4.4.0
Greg Sabino Mullane [Thu, 2 Sep 2010 14:11:59 +0000 (10:11 -0400)]
Patch file for common question regarding 4.4.0

15 years agoMore sequence testing
Greg Sabino Mullane [Thu, 2 Sep 2010 04:36:46 +0000 (00:36 -0400)]
More sequence testing

15 years agoSmall test tweak.
Greg Sabino Mullane [Wed, 1 Sep 2010 20:43:46 +0000 (16:43 -0400)]
Small test tweak.

15 years agoUse microsecond timing and linefrom in logs for testing.
Greg Sabino Mullane [Wed, 1 Sep 2010 20:21:20 +0000 (16:21 -0400)]
Use microsecond timing and linefrom in logs for testing.

15 years agoRemove debugging lines.
Greg Sabino Mullane [Wed, 1 Sep 2010 20:21:04 +0000 (16:21 -0400)]
Remove debugging lines.

15 years agoAdd log_microsecond option, fix log_showline bug.
Greg Sabino Mullane [Wed, 1 Sep 2010 14:18:17 +0000 (10:18 -0400)]
Add log_microsecond option, fix log_showline bug.

15 years agoEnable more sequence tests.
Greg Sabino Mullane [Wed, 1 Sep 2010 14:06:40 +0000 (10:06 -0400)]
Enable more sequence tests.

15 years agoCleanup and overhaul of sequence replication.
Greg Sabino Mullane [Wed, 1 Sep 2010 14:06:09 +0000 (10:06 -0400)]
Cleanup and overhaul of sequence replication.

15 years agoRemove unused methods, rejigger the Test::More override items.
Greg Sabino Mullane [Tue, 31 Aug 2010 18:48:08 +0000 (14:48 -0400)]
Remove unused methods, rejigger the Test::More override items.

15 years agoCheckpoint for new sequence handling work.
Greg Sabino Mullane [Mon, 30 Aug 2010 01:59:48 +0000 (21:59 -0400)]
Checkpoint for new sequence handling work.

15 years agoMinor cleanups.
Greg Sabino Mullane [Mon, 30 Aug 2010 01:59:20 +0000 (21:59 -0400)]
Minor cleanups.

15 years ago2 is now a common state after an exception, as we always COPY.
Greg Sabino Mullane [Sat, 28 Aug 2010 17:30:24 +0000 (13:30 -0400)]
2 is now a common state after an exception, as we always COPY.

15 years agoPass more information to exception handling code.
Greg Sabino Mullane [Sat, 28 Aug 2010 17:26:42 +0000 (13:26 -0400)]
Pass more information to exception handling code.
Add quote() methods to safe list.

15 years agoCheck all glog() calls.
Greg Sabino Mullane [Thu, 26 Aug 2010 08:22:28 +0000 (04:22 -0400)]
Check all glog() calls.