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

15 years agoReformatting and code comment enhancements.
Greg Sabino Mullane [Thu, 26 Aug 2010 08:22:10 +0000 (04:22 -0400)]
Reformatting and code comment enhancements.

15 years agoMake debug an env var
Greg Sabino Mullane [Tue, 24 Aug 2010 23:54:11 +0000 (19:54 -0400)]
Make debug an env var

15 years agoBoth sides serializable for now.
Greg Sabino Mullane [Tue, 24 Aug 2010 23:52:21 +0000 (19:52 -0400)]
Both sides serializable for now.

15 years agoVarious P:C fixes
Greg Sabino Mullane [Tue, 24 Aug 2010 21:28:19 +0000 (17:28 -0400)]
Various P:C fixes

15 years agoSpellchecking run.
Greg Sabino Mullane [Tue, 24 Aug 2010 21:17:08 +0000 (17:17 -0400)]
Spellchecking run.

15 years agoUpdate todo list.
Greg Sabino Mullane [Tue, 24 Aug 2010 21:12:17 +0000 (17:12 -0400)]
Update todo list.

15 years agoStandardize the shebang and emacs hint lines.
Greg Sabino Mullane [Tue, 24 Aug 2010 20:54:36 +0000 (16:54 -0400)]
Standardize the shebang and emacs hint lines.

15 years agoTabs to spaces.
Greg Sabino Mullane [Tue, 24 Aug 2010 20:53:13 +0000 (16:53 -0400)]
Tabs to spaces.

15 years agoRemove more unused or unnecessary test files.
Greg Sabino Mullane [Tue, 24 Aug 2010 20:52:25 +0000 (16:52 -0400)]
Remove more unused or unnecessary test files.

15 years agoRemove multicol tests: already done inside of other tests with bucardo_test2
Greg Sabino Mullane [Tue, 24 Aug 2010 20:49:01 +0000 (16:49 -0400)]
Remove multicol tests: already done inside of other tests with bucardo_test2

15 years agoMinor tweaks to testing file.
Greg Sabino Mullane [Tue, 24 Aug 2010 20:46:59 +0000 (16:46 -0400)]
Minor tweaks to testing file.

15 years agoChange name of test sync.
Greg Sabino Mullane [Tue, 24 Aug 2010 20:46:50 +0000 (16:46 -0400)]
Change name of test sync.

15 years agoRename 05-fullcopy.t to 10-fullcopy.t
Greg Sabino Mullane [Tue, 24 Aug 2010 20:43:00 +0000 (16:43 -0400)]
Rename 05-fullcopy.t to 10-fullcopy.t

15 years agoRemove 04-pushdelta.t, superceded by 10-pushdelta.t
Greg Sabino Mullane [Tue, 24 Aug 2010 20:41:19 +0000 (16:41 -0400)]
Remove 04-pushdelta.t, superceded by 10-pushdelta.t

15 years agoRemove 03-goat.t test.
Greg Sabino Mullane [Tue, 24 Aug 2010 20:27:19 +0000 (16:27 -0400)]
Remove 03-goat.t test.

15 years agoRemove 02-simple.t: no longer needed.
Greg Sabino Mullane [Tue, 24 Aug 2010 20:26:45 +0000 (16:26 -0400)]
Remove 02-simple.t: no longer needed.

15 years agoRemove "monkey" tests: already done better implicitly in other tests.
Greg Sabino Mullane [Tue, 24 Aug 2010 20:25:51 +0000 (16:25 -0400)]
Remove "monkey" tests: already done better implicitly in other tests.

15 years agoUse standard env shebang
Greg Sabino Mullane [Tue, 24 Aug 2010 20:23:40 +0000 (16:23 -0400)]
Use standard env shebang

15 years agoCheck all Perl scripts for validity.
Greg Sabino Mullane [Tue, 24 Aug 2010 20:22:44 +0000 (16:22 -0400)]
Check all Perl scripts for validity.

15 years agoRemove typo.
Greg Sabino Mullane [Tue, 24 Aug 2010 20:13:55 +0000 (16:13 -0400)]
Remove typo.

15 years agogit cleanups
Greg Sabino Mullane [Tue, 24 Aug 2010 19:59:12 +0000 (15:59 -0400)]
git cleanups

15 years agoTest to check all files for tabs and strange characters.
Greg Sabino Mullane [Tue, 24 Aug 2010 19:56:03 +0000 (15:56 -0400)]
Test to check all files for tabs and strange characters.

15 years agoRemove old file.
Greg Sabino Mullane [Tue, 24 Aug 2010 19:55:54 +0000 (15:55 -0400)]
Remove old file.

15 years agoTabs to spaces.
Greg Sabino Mullane [Tue, 24 Aug 2010 19:55:37 +0000 (15:55 -0400)]
Tabs to spaces.

15 years agoUpdate MANIFEST.
Greg Sabino Mullane [Tue, 24 Aug 2010 19:55:15 +0000 (15:55 -0400)]
Update MANIFEST.

15 years agoTabs to spaces.
Greg Sabino Mullane [Tue, 24 Aug 2010 19:16:05 +0000 (15:16 -0400)]
Tabs to spaces.

15 years agoTabs to spaces.
Greg Sabino Mullane [Tue, 24 Aug 2010 19:03:46 +0000 (15:03 -0400)]
Tabs to spaces.

15 years agoNew swap sync testing file.
Greg Sabino Mullane [Tue, 24 Aug 2010 18:56:45 +0000 (14:56 -0400)]
New swap sync testing file.

15 years agoFix error in bind_param for target to source.
Greg Sabino Mullane [Tue, 24 Aug 2010 17:36:41 +0000 (13:36 -0400)]
Fix error in bind_param for target to source.

15 years agoRecent changes.
Greg Sabino Mullane [Tue, 24 Aug 2010 16:10:34 +0000 (12:10 -0400)]
Recent changes.

15 years agoRemove race condition from bucardo_purge_q_table()
Greg Sabino Mullane [Tue, 24 Aug 2010 16:10:02 +0000 (12:10 -0400)]
Remove race condition from bucardo_purge_q_table()

15 years agoTypo.
Greg Sabino Mullane [Mon, 23 Aug 2010 21:40:58 +0000 (17:40 -0400)]
Typo.

15 years agoUse timeofday not now() for all q updates.
Greg Sabino Mullane [Mon, 23 Aug 2010 21:04:49 +0000 (17:04 -0400)]
Use timeofday not now() for all q updates.

15 years agoTweak the q_cleanup index.
Greg Sabino Mullane [Mon, 23 Aug 2010 21:00:21 +0000 (17:00 -0400)]
Tweak the q_cleanup index.

15 years agoFix for bytea primary key checking in swap syncs.
Greg Sabino Mullane [Mon, 23 Aug 2010 03:11:57 +0000 (23:11 -0400)]
Fix for bytea primary key checking in swap syncs.

15 years agoTesting fix: reconnect to new database.
Greg Sabino Mullane [Mon, 23 Aug 2010 00:28:25 +0000 (20:28 -0400)]
Testing fix: reconnect to new database.
Better log_line_prefix

15 years agoFix typo in testing module.
Greg Sabino Mullane [Sun, 22 Aug 2010 18:04:52 +0000 (14:04 -0400)]
Fix typo in testing module.

15 years agoRename the ENCODE cal for bytea selects.
Greg Sabino Mullane [Sun, 22 Aug 2010 17:29:02 +0000 (13:29 -0400)]
Rename the ENCODE cal for bytea selects.

15 years agoAllows "all sequences" for certain items (e.g. standard_conflict)
Greg Sabino Mullane [Sun, 22 Aug 2010 03:17:53 +0000 (23:17 -0400)]
Allows "all sequences" for certain items (e.g. standard_conflict)

15 years agoBack out last change
Greg Sabino Mullane [Sun, 22 Aug 2010 03:17:43 +0000 (23:17 -0400)]
Back out last change

15 years agoAllow a few things to be updated as "all tables" via bucardo_clt.
Greg Sabino Mullane [Sun, 22 Aug 2010 03:09:23 +0000 (23:09 -0400)]
Allow a few things to be updated as "all tables" via bucardo_clt.
Specifically, allows this: bucardo_ctl update all tables standard_conflict=source

15 years agoRemove the check on conflict handling for sequences for now.
Greg Sabino Mullane [Sun, 22 Aug 2010 03:08:59 +0000 (23:08 -0400)]
Remove the check on conflict handling for sequences for now.

15 years agoTesting updates.
Greg Sabino Mullane [Sat, 21 Aug 2010 22:32:42 +0000 (18:32 -0400)]
Testing updates.

15 years agoMake sure we commit to source if our only update was sequences.
Greg Sabino Mullane [Fri, 20 Aug 2010 20:45:07 +0000 (16:45 -0400)]
Make sure we commit to source if our only update was sequences.
Add some debugging.

15 years agoSet schema and table earlier so we give the right message on pushdelta skipping due...
Greg Sabino Mullane [Thu, 19 Aug 2010 16:45:42 +0000 (12:45 -0400)]
Set schema and table earlier so we give the right message on pushdelta skipping due to truncate.

15 years agoLog full error information to log on kid death.
Greg Sabino Mullane [Thu, 19 Aug 2010 15:55:36 +0000 (11:55 -0400)]
Log full error information to log on kid death.

15 years agoNew pushdelta test (work in progress)
Greg Sabino Mullane [Wed, 18 Aug 2010 20:06:52 +0000 (16:06 -0400)]
New pushdelta test (work in progress)

15 years agoCall finish() on statement handle.
Greg Sabino Mullane [Tue, 17 Aug 2010 01:17:12 +0000 (21:17 -0400)]
Call finish() on statement handle.

15 years agoMinor tweaks.
Greg Sabino Mullane [Mon, 16 Aug 2010 21:04:18 +0000 (17:04 -0400)]
Minor tweaks.

15 years agoOverhaul testing suite, starting with 05-fullcopy.t
Greg Sabino Mullane [Mon, 16 Aug 2010 20:48:14 +0000 (16:48 -0400)]
Overhaul testing suite, starting with 05-fullcopy.t

15 years ago Allow 'bucardo_ctl update herd foo remove <table(s)>'
Greg Sabino Mullane [Mon, 16 Aug 2010 19:46:27 +0000 (15:46 -0400)]
 Allow 'bucardo_ctl update herd foo remove <table(s)>'
 and 'bucardo_ctl update herd foo add <table(s)>'

15 years agoBetter debug message.
Greg Sabino Mullane [Mon, 16 Aug 2010 18:29:40 +0000 (14:29 -0400)]
Better debug message.

15 years agoDoc fix.
Greg Sabino Mullane [Fri, 6 Aug 2010 19:53:04 +0000 (15:53 -0400)]
Doc fix.

15 years agoNote latest change
Greg Sabino Mullane [Fri, 6 Aug 2010 17:45:38 +0000 (13:45 -0400)]
Note latest change

15 years agoAllow "schema.table" format for bucardo_ctl list tables
Greg Sabino Mullane [Fri, 6 Aug 2010 17:44:49 +0000 (13:44 -0400)]
Allow "schema.table" format for bucardo_ctl list tables

15 years agoAdd vacuum_after_copy to the schema
Greg Sabino Mullane [Fri, 6 Aug 2010 17:44:30 +0000 (13:44 -0400)]
Add vacuum_after_copy to the schema

15 years agoGet rid of the local stuff and just change autocommit directly.
Greg Sabino Mullane [Fri, 6 Aug 2010 02:01:17 +0000 (22:01 -0400)]
Get rid of the local stuff and just change autocommit directly.

15 years agoNote latest change.
Greg Sabino Mullane [Thu, 5 Aug 2010 17:24:49 +0000 (13:24 -0400)]
Note latest change.

15 years agoAdd new variable vacuum_after_copy
Greg Sabino Mullane [Thu, 5 Aug 2010 17:23:08 +0000 (13:23 -0400)]
Add new variable vacuum_after_copy
Make sure we only do the initial CTL-level truncate check for pushdelta syncs.

15 years agoCleanup of onetimecopy and truncate logic.
Greg Sabino Mullane [Thu, 5 Aug 2010 15:52:20 +0000 (11:52 -0400)]
Cleanup of onetimecopy and truncate logic.

15 years agoRemove unused constraint
Greg Sabino Mullane [Thu, 29 Jul 2010 02:43:45 +0000 (22:43 -0400)]
Remove unused constraint

15 years agoRemove txnmode variable.
Greg Sabino Mullane [Wed, 28 Jul 2010 03:44:34 +0000 (23:44 -0400)]
Remove txnmode variable.

15 years agoRemove unused column sync.copytype
Greg Sabino Mullane [Wed, 28 Jul 2010 02:32:19 +0000 (22:32 -0400)]
Remove unused column sync.copytype

15 years agoBreak statement-level truncation trigger into its own function and trigger,
Greg Sabino Mullane [Wed, 28 Jul 2010 01:17:05 +0000 (21:17 -0400)]
Break statement-level truncation trigger into its own function and trigger,
as we still want to catch it happening even if not pinging.

15 years agoMake sure we truly reset onetimecopy for persistent controllers and children.
Greg Sabino Mullane [Wed, 28 Jul 2010 01:15:38 +0000 (21:15 -0400)]
Make sure we truly reset onetimecopy for persistent controllers and children.
Better logging on truncate events.

15 years agoShow PID in log by default (log_showpid=1)
Greg Sabino Mullane [Sun, 25 Jul 2010 22:11:40 +0000 (18:11 -0400)]
Show PID in log by default (log_showpid=1)

15 years agobucardo_ctl: minor doc tweaks
Greg Sabino Mullane [Fri, 23 Jul 2010 21:10:17 +0000 (17:10 -0400)]
bucardo_ctl: minor doc tweaks

15 years agobucardo_ctl: Add 'pkonly' arguments when adding tables to a herd
Greg Sabino Mullane [Fri, 23 Jul 2010 21:08:01 +0000 (17:08 -0400)]
bucardo_ctl: Add 'pkonly' arguments when adding tables to a herd
bucardo_ctl: Allow adding to a herd even if all tables are already added to the db

15 years agobucardo_ctl: allow alternate formats: 'add tables all' and 'add sequences all'
Greg Sabino Mullane [Fri, 23 Jul 2010 19:57:48 +0000 (15:57 -0400)]
bucardo_ctl: allow alternate formats: 'add tables all' and 'add sequences all'

15 years agobucardo_ctl: allow plurals in "add object"
Greg Sabino Mullane [Fri, 23 Jul 2010 19:44:25 +0000 (15:44 -0400)]
bucardo_ctl: allow plurals in "add object"

15 years agobucardo_ctl: give a friendly list of databases on add <object> when needed.
Greg Sabino Mullane [Fri, 23 Jul 2010 19:42:07 +0000 (15:42 -0400)]
bucardo_ctl: give a friendly list of databases on add <object> when needed.

15 years agoPut bucardo schema in search path for the database.
Greg Sabino Mullane [Sun, 18 Jul 2010 03:06:40 +0000 (23:06 -0400)]
Put bucardo schema in search path for the database.
Populate the upgrade_log with the initial install version and time.

15 years agoRemove the test database directories when doing cleanup.
Greg Sabino Mullane [Sun, 18 Jul 2010 02:53:57 +0000 (22:53 -0400)]
Remove the test database directories when doing cleanup.

15 years agoUse clock_timestamp if Postgres version is 8.2 or better.
Greg Sabino Mullane [Wed, 14 Jul 2010 18:34:07 +0000 (14:34 -0400)]
Use clock_timestamp if Postgres version is 8.2 or better.
Fixes bug 25: http://bucardo.org/bugzilla/show_bug.cgi?id=25
Thanks to David Christensen <david@endpoint.com> for digging in and solving this.

15 years agoAdd some debug lines around large data fetch.
Greg Sabino Mullane [Fri, 9 Jul 2010 18:34:37 +0000 (14:34 -0400)]
Add some debug lines around large data fetch.

15 years agoSet the application_name (to 'bucardo', natch) if the db is >= 9.0
Greg Sabino Mullane [Sat, 26 Jun 2010 15:14:28 +0000 (11:14 -0400)]
Set the application_name (to 'bucardo', natch) if the db is >= 9.0

15 years agoNote recent fix to Bucardo.pm
Greg Sabino Mullane [Tue, 22 Jun 2010 21:57:09 +0000 (17:57 -0400)]
Note recent fix to Bucardo.pm

15 years agoFix broken logic for multi-primary key makedelta.
Greg Sabino Mullane [Tue, 22 Jun 2010 21:04:25 +0000 (17:04 -0400)]
Fix broken logic for multi-primary key makedelta.

15 years agoShow proper message when doing makedelta, and add message for source.
Greg Sabino Mullane [Tue, 22 Jun 2010 20:11:28 +0000 (16:11 -0400)]
Show proper message when doing makedelta, and add message for source.

15 years agoNote recent function addition.
Greg Sabino Mullane [Tue, 22 Jun 2010 15:48:51 +0000 (11:48 -0400)]
Note recent function addition.

15 years agoAdd function 'create_child_q_table' for manual child_q creations.
Greg Sabino Mullane [Tue, 22 Jun 2010 15:48:07 +0000 (11:48 -0400)]
Add function 'create_child_q_table' for manual child_q creations.

15 years agoAdd special 'batch' argument for test suite installs.
Greg Sabino Mullane [Tue, 22 Jun 2010 15:37:28 +0000 (11:37 -0400)]
Add special 'batch' argument for test suite installs.
Allow for non-single name function arguments.

15 years agoNore async spot.
Greg Sabino Mullane [Sun, 20 Jun 2010 20:42:37 +0000 (16:42 -0400)]
Nore async spot.

15 years agoCredits
Greg Sabino Mullane [Sun, 20 Jun 2010 20:25:03 +0000 (16:25 -0400)]
Credits