bucardo.git
10 years agoUpdate the Changes file with latest items; fix spelling error.
Greg Sabino Mullane [Fri, 29 May 2015 15:00:20 +0000 (11:00 -0400)]
Update the Changes file with latest items; fix spelling error.

10 years agoIf we cannot call connect_database, throw an exception rather than returning a string...
Greg Sabino Mullane [Thu, 28 May 2015 02:49:07 +0000 (22:49 -0400)]
If we cannot call connect_database, throw an exception rather than returning a string (relic of a bygone day)

10 years agoBetter error message if we try to indirectly connect to an unknown database via ...
Greg Sabino Mullane [Thu, 28 May 2015 02:37:59 +0000 (22:37 -0400)]
Better error message if we try to indirectly connect to an unknown database via 'bucardo' command-line.
Example: bucardo add table foobar db=nosuchdb

10 years agoWhen showing list of tables via 'bucardo list relgroup', output in the same order...
Greg Sabino Mullane [Thu, 28 May 2015 02:06:03 +0000 (22:06 -0400)]
When showing list of tables via 'bucardo list relgroup', output in the same order that Bucardo will use: higher priority first, then alphabetical by full name.

10 years agoMake sure we paren pkeylist in case it is a multi-pk
Greg Sabino Mullane [Sun, 24 May 2015 16:30:29 +0000 (12:30 -0400)]
Make sure we paren pkeylist in case it is a multi-pk

10 years agoWhen a kid does a rollback (e.g. serialization error), make sure we re-disable the...
Greg Sabino Mullane [Sat, 23 May 2015 16:22:03 +0000 (12:22 -0400)]
When a kid does a rollback (e.g. serialization error), make sure we re-disable the triggers on each round.
Long-term we need to make this system more robust, perhaps by wrapping all commits and rollbacks in a sub.

10 years agoIf our final rollback fails, we might as well throw an exception right away.
Greg Sabino Mullane [Sat, 23 May 2015 16:18:09 +0000 (12:18 -0400)]
If our final rollback fails, we might as well throw an exception right away.

10 years agoWhen doing a delete of a target, use the escaped version of the primary key columns.
Greg Sabino Mullane [Fri, 22 May 2015 02:45:51 +0000 (22:45 -0400)]
When doing a delete of a target, use the escaped version of the primary key columns.

10 years agoHave validate_sync check the contents of functions, not just their existence, to...
Greg Sabino Mullane [Wed, 20 May 2015 16:46:20 +0000 (12:46 -0400)]
Have validate_sync check the contents of functions, not just their existence, to allow us to update functions on remote targets on an upgrade.

10 years agoThrow an "upgrade" call into the testing
Greg Sabino Mullane [Wed, 20 May 2015 16:45:13 +0000 (12:45 -0400)]
Throw an "upgrade" call into the testing

10 years agoMore support for my crappy typing skills.
Greg Sabino Mullane [Tue, 19 May 2015 03:05:58 +0000 (23:05 -0400)]
More support for my crappy typing skills.

10 years agoTypo
Greg Sabino Mullane [Fri, 15 May 2015 15:53:08 +0000 (11:53 -0400)]
Typo

10 years agoRename "tablename" to "dtablename" to prevent confusion in a plpgsql function.
Greg Sabino Mullane [Fri, 15 May 2015 15:52:19 +0000 (11:52 -0400)]
Rename "tablename" to "dtablename" to prevent confusion in a plpgsql function.

10 years agoDebug cleanups
Greg Sabino Mullane [Tue, 12 May 2015 02:39:46 +0000 (22:39 -0400)]
Debug cleanups

10 years agoAdd new "delta" command to view the current delta count across all source targets.
Greg Sabino Mullane [Mon, 4 May 2015 23:24:21 +0000 (19:24 -0400)]
Add new "delta" command to view the current delta count across all source targets.

10 years agoMake the 'pkonly' argument to 'bucardo add all tables' work more intuitively: prevent...
Greg Sabino Mullane [Mon, 4 May 2015 15:34:01 +0000 (11:34 -0400)]
Make the 'pkonly' argument to 'bucardo add all tables' work more intuitively: prevent addition at all, not just during the add to herd step.

10 years agoRemove default value from sync.isolation_level, so we can respect the global one...
Greg Sabino Mullane [Sat, 2 May 2015 01:23:40 +0000 (21:23 -0400)]
Remove default value from sync.isolation_level, so we can respect the global one easier.

10 years agoRemove errant tab
Greg Sabino Mullane [Fri, 1 May 2015 20:51:15 +0000 (16:51 -0400)]
Remove errant tab

10 years agoUpdate Changes file
Greg Sabino Mullane [Fri, 1 May 2015 02:19:41 +0000 (22:19 -0400)]
Update Changes file

10 years agoPrevent spurious warnings when testing older versions of Postgres
Greg Sabino Mullane [Fri, 1 May 2015 02:09:43 +0000 (22:09 -0400)]
Prevent spurious warnings when testing older versions of Postgres

10 years agoRewrite bucardo_purge_delta to use an "oid" argument to support older versions that...
Greg Sabino Mullane [Thu, 30 Apr 2015 23:07:44 +0000 (19:07 -0400)]
Rewrite bucardo_purge_delta to use an "oid" argument to support older versions that do not support easy casting from regclass to text.

10 years agoBetter SQL for gathering latest changes across all tables for conflict resolution.
Greg Sabino Mullane [Wed, 29 Apr 2015 03:15:59 +0000 (23:15 -0400)]
Better SQL for gathering latest changes across all tables for conflict resolution.

10 years agoUse old-school form for ORDER BY, as NULLS LAST is not in older versions.
Greg Sabino Mullane [Wed, 29 Apr 2015 02:53:57 +0000 (22:53 -0400)]
Use old-school form for ORDER BY, as NULLS LAST is not in older versions.

10 years agoWhen comparing sequences, be a little looser about missing fields as sequences have...
Greg Sabino Mullane [Wed, 29 Apr 2015 02:53:10 +0000 (22:53 -0400)]
When comparing sequences, be a little looser about missing fields as sequences have changed over the years.

10 years agoMore version routing bugs
Greg Sabino Mullane [Tue, 28 Apr 2015 22:30:23 +0000 (18:30 -0400)]
More version routing bugs

10 years agoNeed to check < 80300 to catch Postgres version 8.2.x!
Greg Sabino Mullane [Tue, 28 Apr 2015 22:28:26 +0000 (18:28 -0400)]
Need to check < 80300 to catch Postgres version 8.2.x!

10 years agoSupport the lack of array_agg in 8.2 by rolling our own as needed.
Greg Sabino Mullane [Tue, 28 Apr 2015 20:49:43 +0000 (16:49 -0400)]
Support the lack of array_agg in 8.2 by rolling our own as needed.

10 years agoAdd a noop sslmode to the tests
Greg Sabino Mullane [Tue, 28 Apr 2015 19:33:57 +0000 (15:33 -0400)]
Add a noop sslmode to the tests

10 years agoFix missing semicolon when building DSN
Greg Sabino Mullane [Tue, 28 Apr 2015 16:35:52 +0000 (12:35 -0400)]
Fix missing semicolon when building DSN

10 years agoUpdate the Changes file with recent activity
Greg Sabino Mullane [Sat, 25 Apr 2015 12:07:10 +0000 (08:07 -0400)]
Update the Changes file with recent activity

10 years agoWhen contructing a Postgres DSN, do not use literal 'conn=' but just the values.
Greg Sabino Mullane [Sat, 25 Apr 2015 11:14:52 +0000 (07:14 -0400)]
When contructing a Postgres DSN, do not use literal 'conn=' but just the values.
Per report on mailing list from Alexandre Busquets

10 years agoAdjustments for new version of ExtUtils::MakeMaker
Mathieu Arnold [Mon, 20 Apr 2015 13:45:20 +0000 (09:45 -0400)]
Adjustments for new version of ExtUtils::MakeMaker

10 years agoAllow dashes in valid schema and table names
David Christensen [Fri, 17 Apr 2015 18:09:51 +0000 (13:09 -0500)]
Allow dashes in valid schema and table names

10 years agoMinor var renamings
Greg Sabino Mullane [Sun, 12 Apr 2015 03:15:30 +0000 (23:15 -0400)]
Minor var renamings

10 years agoMake delete_table() handle a table object, not just a table name.
Greg Sabino Mullane [Fri, 10 Apr 2015 01:40:42 +0000 (21:40 -0400)]
Make delete_table() handle a table object, not just a table name.

10 years agoMake truncate_table() handle a table object, not just a table name.
Greg Sabino Mullane [Fri, 10 Apr 2015 01:04:19 +0000 (21:04 -0400)]
Make truncate_table() handle a table object, not just a table name.

10 years agoDocumentation typo
Greg Sabino Mullane [Thu, 9 Apr 2015 15:06:06 +0000 (11:06 -0400)]
Documentation typo

10 years agoWhitespace
Greg Sabino Mullane [Wed, 8 Apr 2015 01:07:42 +0000 (21:07 -0400)]
Whitespace

10 years agoSimplify push_rows and change args from eight to five.
Greg Sabino Mullane [Thu, 2 Apr 2015 01:58:29 +0000 (21:58 -0400)]
Simplify push_rows and change args from eight to five.

10 years agoBetter display for 'bucardo list clones'
Greg Sabino Mullane [Sat, 28 Mar 2015 11:45:45 +0000 (07:45 -0400)]
Better display for 'bucardo list clones'
Allow clone primes to specify multiple databases.

10 years agoMake 'bucardo list all' a little less verbose for some not-so-common items
Greg Sabino Mullane [Thu, 26 Mar 2015 19:36:50 +0000 (15:36 -0400)]
Make 'bucardo list all' a little less verbose for some not-so-common items

10 years agoFix up some weird whitespace problems
Greg Sabino Mullane [Thu, 26 Mar 2015 19:34:43 +0000 (15:34 -0400)]
Fix up some weird whitespace problems

10 years agoSome infrastructure for the upcoming bucardo clone feature
Greg Sabino Mullane [Thu, 26 Mar 2015 19:25:22 +0000 (15:25 -0400)]
Some infrastructure for the upcoming bucardo clone feature

10 years agoLet's remove plperl someday if we can.
Greg Sabino Mullane [Mon, 23 Mar 2015 16:18:36 +0000 (12:18 -0400)]
Let's remove plperl someday if we can.

10 years agoRespect the QUIET flag when creating the superuser.
Greg Sabino Mullane [Sun, 22 Mar 2015 03:16:54 +0000 (23:16 -0400)]
Respect the QUIET flag when creating the superuser.

10 years agoMake sure before_check_rows code is only enabled for pushdelta (e.g. not fullcopy)
Greg Sabino Mullane [Fri, 20 Mar 2015 22:39:04 +0000 (18:39 -0400)]
Make sure before_check_rows code is only enabled for pushdelta (e.g. not fullcopy)

10 years agoTweak gitignore
Greg Sabino Mullane [Fri, 20 Mar 2015 22:11:15 +0000 (18:11 -0400)]
Tweak gitignore

10 years agoConsolidate all the "start of transaction" setting things. Expand disable_triggers...
Greg Sabino Mullane [Fri, 20 Mar 2015 20:42:23 +0000 (16:42 -0400)]
Consolidate all the "start of transaction" setting things. Expand disable_triggers to include mysql code.

10 years agoMove manifest file around
Greg Sabino Mullane [Fri, 20 Mar 2015 20:41:28 +0000 (16:41 -0400)]
Move manifest file around

10 years agoClean up and refactor some of the disable/enable trigger functionality.
Greg Sabino Mullane [Fri, 20 Mar 2015 17:53:35 +0000 (13:53 -0400)]
Clean up and refactor some of the disable/enable trigger functionality.

10 years agoClean up and refactor some of the disable/enable index functionality.
Greg Sabino Mullane [Fri, 20 Mar 2015 17:37:45 +0000 (13:37 -0400)]
Clean up and refactor some of the disable/enable index functionality.

10 years agoMove flatfile and semaphore creation before trigger disabling, etc.
Greg Sabino Mullane [Mon, 16 Mar 2015 22:14:29 +0000 (18:14 -0400)]
Move flatfile and semaphore creation before trigger disabling, etc.

10 years agoMove transaction start and isolation level setting into separate sub
Greg Sabino Mullane [Mon, 16 Mar 2015 22:04:03 +0000 (18:04 -0400)]
Move transaction start and isolation level setting into separate sub

10 years agoMove the lock file functionality to separate subroutines, and make them smarter.
Greg Sabino Mullane [Mon, 16 Mar 2015 04:41:50 +0000 (00:41 -0400)]
Move the lock file functionality to separate subroutines, and make them smarter.

10 years agoTest the lockfile creation
Greg Sabino Mullane [Mon, 16 Mar 2015 04:41:03 +0000 (00:41 -0400)]
Test the lockfile creation

10 years agoSimplify the new index subroutines
Greg Sabino Mullane [Sun, 15 Mar 2015 13:52:21 +0000 (09:52 -0400)]
Simplify the new index subroutines

10 years agoAdd 'PRAGMA defer_foreign_keys' for sqlite targets
Greg Sabino Mullane [Sun, 15 Mar 2015 03:42:34 +0000 (23:42 -0400)]
Add 'PRAGMA defer_foreign_keys' for sqlite targets

10 years agoCleanup and refactor the rebuild_index code.
Greg Sabino Mullane [Sun, 15 Mar 2015 03:29:40 +0000 (23:29 -0400)]
Cleanup and refactor the rebuild_index code.

10 years agorebuild_index for tables needs to default to null, not 0, so that sync-level rebuild_...
Greg Sabino Mullane [Sun, 15 Mar 2015 03:27:55 +0000 (23:27 -0400)]
rebuild_index for tables needs to default to null, not 0, so that sync-level rebuild_index can override it.

10 years agoTest rebuild_index
Greg Sabino Mullane [Sun, 15 Mar 2015 03:26:28 +0000 (23:26 -0400)]
Test rebuild_index

10 years agoIf version of Postgres is less than 8.2, do not attempt to change standard_confirming...
Greg Sabino Mullane [Fri, 13 Mar 2015 16:17:05 +0000 (12:17 -0400)]
If version of Postgres is less than 8.2, do not attempt to change standard_confirming_strings.
Kind of a moot point anyway, as I cannot seem to get 8.1 to even compile with plperl anymore...

10 years agoMove trigger disabling and enabling into separate subs.
Greg Sabino Mullane [Fri, 13 Mar 2015 16:16:06 +0000 (12:16 -0400)]
Move trigger disabling and enabling into separate subs.
This begins treating more things as methods and objects, which is going to be needed for the addition of the "clone" subsystem.

10 years agoEnable testing of trigger and rule disabling again.
Greg Sabino Mullane [Wed, 11 Mar 2015 03:18:20 +0000 (23:18 -0400)]
Enable testing of trigger and rule disabling again.
Very necessary as the trigger disabling code is about to be rewritten.

10 years agoMove a file around
Greg Sabino Mullane [Tue, 10 Mar 2015 02:26:15 +0000 (22:26 -0400)]
Move a file around

10 years agoHousekeeping
Greg Sabino Mullane [Thu, 26 Feb 2015 03:39:17 +0000 (22:39 -0500)]
Housekeeping

10 years agoClean up docs for 'bucardo add db'. Simplify given args, reword things, etc.
Greg Sabino Mullane [Thu, 26 Feb 2015 02:38:58 +0000 (21:38 -0500)]
Clean up docs for 'bucardo add db'. Simplify given args, reword things, etc.

10 years agoQuick idea from #bucardo
Greg Sabino Mullane [Mon, 23 Feb 2015 15:42:41 +0000 (10:42 -0500)]
Quick idea from #bucardo

10 years agoHave controller ignore any notices starting with "kid_", per a report from the field.
Greg Sabino Mullane [Mon, 16 Feb 2015 20:07:01 +0000 (15:07 -0500)]
Have controller ignore any notices starting with "kid_", per a report from the field.
Not sure how this is happening exactly, but cleaning up the listen/notify system is on the todo

10 years agoQuick note about listen/notify enhancement
Greg Sabino Mullane [Mon, 16 Feb 2015 20:04:26 +0000 (15:04 -0500)]
Quick note about listen/notify enhancement

10 years agoUse the two-arg form of pg_get_constraintdef when comparing live constraints to our...
Greg Sabino Mullane [Thu, 29 Jan 2015 02:20:49 +0000 (21:20 -0500)]
Use the two-arg form of pg_get_constraintdef when comparing live constraints to our schema, which allows for other simplifications.

10 years agoMinor comment tweaks
Greg Sabino Mullane [Thu, 29 Jan 2015 02:01:02 +0000 (21:01 -0500)]
Minor comment tweaks

10 years agoCode cleanup: simplify the second dbpass eliding bit.
Greg Sabino Mullane [Wed, 28 Jan 2015 04:27:59 +0000 (23:27 -0500)]
Code cleanup: simplify the second dbpass eliding bit.

10 years agoMild code cleanup and refactoring.
Greg Sabino Mullane [Wed, 28 Jan 2015 04:20:52 +0000 (23:20 -0500)]
Mild code cleanup and refactoring.

10 years agoRecord git commit for 5.3.1 in the Changes file
Greg Sabino Mullane [Tue, 27 Jan 2015 18:49:46 +0000 (13:49 -0500)]
Record git commit for 5.3.1 in the Changes file

10 years agoSignature for 5.3.1 5.3.1
Greg Sabino Mullane [Tue, 27 Jan 2015 18:48:46 +0000 (13:48 -0500)]
Signature for 5.3.1

10 years agoUpdate Changes file and bump version to 5.3.1
Greg Sabino Mullane [Mon, 26 Jan 2015 12:15:06 +0000 (07:15 -0500)]
Update Changes file and bump version to 5.3.1

10 years agoMinor cleanups and variable renames
Greg Sabino Mullane [Mon, 26 Jan 2015 12:08:27 +0000 (07:08 -0500)]
Minor cleanups and variable renames

10 years agoAs get_config already dies on failure to find a match, remove the || dies after calli...
Greg Sabino Mullane [Sat, 17 Jan 2015 05:02:05 +0000 (00:02 -0500)]
As get_config already dies on failure to find a match, remove the || dies after calling it.

10 years agoInside connect_database, die with the error at hand if we cannot handle it smoothly
Greg Sabino Mullane [Sat, 17 Jan 2015 04:58:38 +0000 (23:58 -0500)]
Inside connect_database, die with the error at hand if we cannot handle it smoothly

10 years agoGive a warning when a bucardo rc file has an unparseable line,
Greg Sabino Mullane [Sat, 17 Jan 2015 04:49:54 +0000 (23:49 -0500)]
Give a warning when a bucardo rc file has an unparseable line,

10 years agoWhen clearing out the async mode, do not do so unless the state() is sane.
Greg Sabino Mullane [Tue, 13 Jan 2015 20:07:49 +0000 (15:07 -0500)]
When clearing out the async mode, do not do so unless the state() is sane.

10 years agoBump copyright to 2015
Greg Sabino Mullane [Sat, 3 Jan 2015 17:05:08 +0000 (12:05 -0500)]
Bump copyright to 2015

10 years agoURLs moves again for submitting news to postgres.org
Greg Sabino Mullane [Mon, 22 Dec 2014 15:13:11 +0000 (10:13 -0500)]
URLs moves again for submitting news to postgres.org

10 years agoRelease 5.3.0
Greg Sabino Mullane [Mon, 22 Dec 2014 15:02:36 +0000 (10:02 -0500)]
Release 5.3.0

10 years agoFix release date 5.3.0
Greg Sabino Mullane [Mon, 22 Dec 2014 15:01:49 +0000 (10:01 -0500)]
Fix release date

10 years agoFinal Changes entry for 5.3.0
Greg Sabino Mullane [Mon, 22 Dec 2014 15:00:35 +0000 (10:00 -0500)]
Final Changes entry for 5.3.0

10 years agoSet release date for 5.3.0 to November 22, 2014
Greg Sabino Mullane [Mon, 22 Dec 2014 14:37:55 +0000 (09:37 -0500)]
Set release date for 5.3.0 to November 22, 2014

10 years agoMinor HTML doc changes
Greg Sabino Mullane [Mon, 22 Dec 2014 14:37:36 +0000 (09:37 -0500)]
Minor HTML doc changes

10 years agoUpdate changes for 5.3.0
Greg Sabino Mullane [Mon, 22 Dec 2014 13:24:10 +0000 (08:24 -0500)]
Update changes for 5.3.0

10 years agoQuote bug!
Greg Sabino Mullane [Mon, 22 Dec 2014 03:45:23 +0000 (22:45 -0500)]
Quote bug!

10 years agoRemove old debug line
Greg Sabino Mullane [Mon, 22 Dec 2014 02:38:15 +0000 (21:38 -0500)]
Remove old debug line

10 years agoDo not bail on default for test failures - that is why we have ENV{BUCARDO_TESTBAIL}
Greg Sabino Mullane [Sun, 21 Dec 2014 22:12:32 +0000 (17:12 -0500)]
Do not bail on default for test failures - that is why we have ENV{BUCARDO_TESTBAIL}

10 years agoMany Perl::Critic tweaks
Greg Sabino Mullane [Sun, 21 Dec 2014 22:12:08 +0000 (17:12 -0500)]
Many Perl::Critic tweaks

10 years agoMake sure we undef the CTL error handler after the fork to become a KID.
Greg Sabino Mullane [Sun, 21 Dec 2014 22:11:32 +0000 (17:11 -0500)]
Make sure we undef the CTL error handler after the fork to become a KID.
Many Perl::Critic inspired tweaks.

10 years agoSpelling tweaks
Greg Sabino Mullane [Sat, 20 Dec 2014 01:54:15 +0000 (20:54 -0500)]
Spelling tweaks

10 years agoTesting tweak
Greg Sabino Mullane [Fri, 19 Dec 2014 14:22:24 +0000 (09:22 -0500)]
Testing tweak

10 years agoDo not overwrite existing makedelta state for tables
Greg Sabino Mullane [Fri, 19 Dec 2014 05:11:52 +0000 (00:11 -0500)]
Do not overwrite existing makedelta state for tables

10 years agoImprove 50-star tests
Greg Sabino Mullane [Fri, 19 Dec 2014 04:41:12 +0000 (23:41 -0500)]
Improve 50-star tests

10 years agoModify db_notify method to allow for non-commits, as we now need that as we commit...
Greg Sabino Mullane [Fri, 19 Dec 2014 04:07:11 +0000 (23:07 -0500)]
Modify db_notify method to allow for non-commits, as we now need that as we commit to other databases in the middle of our important kid transaction.

10 years agoCreated a new level of output, DEBUG2, and moved some of the really verbose and annoy...
Greg Sabino Mullane [Thu, 18 Dec 2014 20:09:02 +0000 (15:09 -0500)]
Created a new level of output, DEBUG2, and moved some of the really verbose and annoying messages there.