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

15 years agoRemove unused okmsg var from the tests.
Greg Sabino Mullane [Sun, 20 Jun 2010 20:24:07 +0000 (16:24 -0400)]
Remove unused okmsg var from the tests.

15 years agoRather than tail the log file to see if a cluster has started, wait until we have...
Greg Sabino Mullane [Sun, 20 Jun 2010 20:22:35 +0000 (16:22 -0400)]
Rather than tail the log file to see if a cluster has started, wait until we have a valid connection. Thanks to Andre Felipe Machado for pointing out that the original message was very locale-centric.

15 years agoBetter message formatting on kid cleanup.
Greg Sabino Mullane [Sat, 19 Jun 2010 16:05:33 +0000 (12:05 -0400)]
Better message formatting on kid cleanup.

15 years agoTake advanatage of the fact we require Time::HiRes by using it to
Greg Sabino Mullane [Sat, 19 Jun 2010 15:27:48 +0000 (11:27 -0400)]
Take advanatage of the fact we require Time::HiRes by using it to
time the sync via tv_interval, and to get a more accurate epoch on startup.

15 years agoMove message to DEBUG, as it is redundant.
Greg Sabino Mullane [Sat, 19 Jun 2010 15:01:27 +0000 (11:01 -0400)]
Move message to DEBUG, as it is redundant.

15 years agoMake total count verbose, not normal.
Greg Sabino Mullane [Sat, 19 Jun 2010 15:00:12 +0000 (11:00 -0400)]
Make total count verbose, not normal.

15 years agoMore log_level adjustments.
Greg Sabino Mullane [Sat, 19 Jun 2010 14:58:52 +0000 (10:58 -0400)]
More log_level adjustments.

15 years agoUpdate Changes file
Greg Sabino Mullane [Fri, 18 Jun 2010 19:21:02 +0000 (15:21 -0400)]
Update Changes file

15 years agoForce log_levels to the known values.
Greg Sabino Mullane [Fri, 18 Jun 2010 19:19:51 +0000 (15:19 -0400)]
Force log_levels to the known values.

15 years agoMore log_level tweaks.
Greg Sabino Mullane [Fri, 18 Jun 2010 19:15:38 +0000 (15:15 -0400)]
More log_level tweaks.
Refactor the config listing and show it on config_reload.
Allow the log_levels to be case-insensitive.

15 years agoChange log_level of backend PID messages to verbose.
Greg Sabino Mullane [Fri, 18 Jun 2010 18:31:40 +0000 (14:31 -0400)]
Change log_level of backend PID messages to verbose.

15 years agoAllow use of named log_levels: keep all numbers internal.
Greg Sabino Mullane [Fri, 18 Jun 2010 18:30:16 +0000 (14:30 -0400)]
Allow use of named log_levels: keep all numbers internal.

15 years agoChange default log_level to a named value
Greg Sabino Mullane [Fri, 18 Jun 2010 18:16:45 +0000 (14:16 -0400)]
Change default log_level to a named value

15 years agoOne more glog() setting.
Greg Sabino Mullane [Fri, 18 Jun 2010 18:15:53 +0000 (14:15 -0400)]
One more glog() setting.

15 years agoMake sure all glog calls use a named value.
Greg Sabino Mullane [Fri, 18 Jun 2010 18:14:33 +0000 (14:14 -0400)]
Make sure all glog calls use a named value.

15 years agoTell what signal was used.
Greg Sabino Mullane [Fri, 18 Jun 2010 18:10:48 +0000 (14:10 -0400)]
Tell what signal was used.

15 years agoReassigning of log_levels.
Greg Sabino Mullane [Fri, 18 Jun 2010 18:08:55 +0000 (14:08 -0400)]
Reassigning of log_levels.
Introduce new log_level, LOG_WARN

15 years agoSimplify logging to four levels and give them names.
Rosser Schwarz [Fri, 18 Jun 2010 17:20:17 +0000 (13:20 -0400)]
Simplify logging to four levels and give them names.

15 years agoDon't allow kicking of inactive syncs.
Greg Sabino Mullane [Tue, 15 Jun 2010 16:54:05 +0000 (12:54 -0400)]
Don't allow kicking of inactive syncs.

15 years agoOn invalid sync, show a list of all valid syncs.
Greg Sabino Mullane [Tue, 15 Jun 2010 16:50:02 +0000 (12:50 -0400)]
On invalid sync, show a list of all valid syncs.
Remove some of the new NO_PG_LISTENER items: will find a better way.

15 years agoUpdate Changes file.
Greg Sabino Mullane [Tue, 15 Jun 2010 16:39:28 +0000 (12:39 -0400)]
Update Changes file.

15 years agoWhen doing a bucardo_ctl kick and the sync dies, show why.
Greg Sabino Mullane [Tue, 15 Jun 2010 16:37:15 +0000 (12:37 -0400)]
When doing a bucardo_ctl kick and the sync dies, show why.

15 years agoFix up bucardo.q entries to always use the controller's PID as ppid.
Greg Sabino Mullane [Tue, 15 Jun 2010 16:36:06 +0000 (12:36 -0400)]
Fix up bucardo.q entries to always use the controller's PID as ppid.
Better error messages when a kid dies.

15 years agoTypo.
Greg Sabino Mullane [Tue, 15 Jun 2010 14:18:58 +0000 (10:18 -0400)]
Typo.

15 years agoLower log_level of those "Checking column" messages.
Greg Sabino Mullane [Mon, 14 Jun 2010 15:03:59 +0000 (11:03 -0400)]
Lower log_level of those "Checking column" messages.

15 years agoIf in one-time-copy mode, always create a q entry, regardless of synctype.
Greg Sabino Mullane [Sun, 13 Jun 2010 17:08:05 +0000 (13:08 -0400)]
If in one-time-copy mode, always create a q entry, regardless of synctype.

15 years agoState PID on way out.
Greg Sabino Mullane [Sun, 13 Jun 2010 02:44:08 +0000 (22:44 -0400)]
State PID on way out.

15 years agoMinor log output tweaks.
Greg Sabino Mullane [Sat, 12 Jun 2010 22:20:46 +0000 (18:20 -0400)]
Minor log output tweaks.

15 years agoLog wording tweak.
Greg Sabino Mullane [Sat, 12 Jun 2010 22:16:29 +0000 (18:16 -0400)]
Log wording tweak.

15 years agoRefactor display of db time, timezone, and version, have targets show it too.
Greg Sabino Mullane [Sat, 12 Jun 2010 22:10:48 +0000 (18:10 -0400)]
Refactor display of db time, timezone, and version, have targets show it too.

15 years agoShow Perl's $^O value on startup.
Greg Sabino Mullane [Sat, 12 Jun 2010 21:19:23 +0000 (17:19 -0400)]
Show Perl's $^O value on startup.

15 years agoHeader of log messages already has a space.
Greg Sabino Mullane [Sat, 12 Jun 2010 21:02:47 +0000 (17:02 -0400)]
Header of log messages already has a space.

15 years agoBetter display of Perl version.
Greg Sabino Mullane [Sat, 12 Jun 2010 20:53:27 +0000 (16:53 -0400)]
Better display of Perl version.

15 years agoMissing log_level on a glog
Greg Sabino Mullane [Tue, 8 Jun 2010 22:00:06 +0000 (18:00 -0400)]
Missing log_level on a glog

15 years agoUpdate Changes file.
Greg Sabino Mullane [Mon, 7 Jun 2010 17:53:40 +0000 (13:53 -0400)]
Update Changes file.

15 years agoDon't do a timeout kick if in onetimecopy mode.
Greg Sabino Mullane [Mon, 7 Jun 2010 17:50:56 +0000 (13:50 -0400)]
Don't do a timeout kick if in onetimecopy mode.

15 years agoShow delta count only if non-zero for log_level 5
Greg Sabino Mullane [Sun, 6 Jun 2010 22:19:39 +0000 (18:19 -0400)]
Show delta count only if non-zero for log_level 5

15 years agoChange "timed out" messages to log level 6
Greg Sabino Mullane [Sun, 6 Jun 2010 22:12:38 +0000 (18:12 -0400)]
Change "timed out" messages to log level 6

15 years agoShow PIDs for kids and controllers in opeining message
Greg Sabino Mullane [Sun, 6 Jun 2010 22:11:14 +0000 (18:11 -0400)]
Show PIDs for kids and controllers in opeining message

15 years agoTweak log_levels
Greg Sabino Mullane [Sun, 6 Jun 2010 22:07:41 +0000 (18:07 -0400)]
Tweak log_levels

15 years agoMake sure we support deprecated "config set" and "config show".
Greg Sabino Mullane [Sun, 6 Jun 2010 21:58:31 +0000 (17:58 -0400)]
Make sure we support deprecated "config set" and "config show".
Have docs show simple "set" and "show"

15 years agoReport Postgres versions on startup.
Greg Sabino Mullane [Sat, 5 Jun 2010 17:12:03 +0000 (13:12 -0400)]
Report Postgres versions on startup.

15 years agolog_level tweaks
Greg Sabino Mullane [Sat, 5 Jun 2010 02:39:05 +0000 (22:39 -0400)]
log_level tweaks

15 years agoTweak log_levels
Greg Sabino Mullane [Fri, 4 Jun 2010 20:43:57 +0000 (16:43 -0400)]
Tweak log_levels