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

10 years agoMakedelta tweaks
Greg Sabino Mullane [Thu, 18 Dec 2014 20:07:22 +0000 (15:07 -0500)]
Makedelta tweaks

10 years agoAllow specification of non-default port when sending email.
Greg Sabino Mullane [Sun, 14 Dec 2014 18:35:37 +0000 (13:35 -0500)]
Allow specification of non-default port when sending email.
Attempt support for SASL auth as well (untested)

10 years agoBetter debug for invalid customcols
Greg Sabino Mullane [Sun, 14 Dec 2014 18:25:04 +0000 (13:25 -0500)]
Better debug for invalid customcols

10 years agoCleanup of testing infrastructure. Primary change is using CREATE DATABASE .. TEMPLAT...
Greg Sabino Mullane [Sat, 13 Dec 2014 03:19:39 +0000 (22:19 -0500)]
Cleanup of testing infrastructure. Primary change is using CREATE DATABASE .. TEMPLATE for the "extra" databases.

10 years agoAllow skipping of test cleanup via environment variable BUCARDO_NOCLEANUP
Greg Sabino Mullane [Sat, 13 Dec 2014 03:18:49 +0000 (22:18 -0500)]
Allow skipping of test cleanup via environment variable BUCARDO_NOCLEANUP

10 years agoStandardize the Changes file, back to version 5.0.0
Greg Sabino Mullane [Thu, 11 Dec 2014 03:36:41 +0000 (22:36 -0500)]
Standardize the Changes file, back to version 5.0.0

10 years agoDo not consider "nouns" when ooking for matching tables inside of add customcols...
Greg Sabino Mullane [Tue, 9 Dec 2014 20:04:45 +0000 (15:04 -0500)]
Do not consider "nouns" when ooking for matching tables inside of add customcols - the db= parameter can confuse things

10 years agoAllow customcodes an easier look at the changed rows, so they don't have to go figure...
Greg Sabino Mullane [Tue, 9 Dec 2014 19:22:48 +0000 (14:22 -0500)]
Allow customcodes an easier look at the changed rows, so they don't have to go figure it out themselves.
Show our customcode names, not ids, in the log output.

10 years agoFix two typos
Greg Sabino Mullane [Mon, 8 Dec 2014 22:10:51 +0000 (17:10 -0500)]
Fix two typos

10 years agoQuick idea about sourceonly type
Greg Sabino Mullane [Mon, 8 Dec 2014 16:26:15 +0000 (11:26 -0500)]
Quick idea about sourceonly type

10 years agoCheck for database makedelta of "true", not just truthy existence.
Greg Sabino Mullane [Mon, 8 Dec 2014 00:59:48 +0000 (19:59 -0500)]
Check for database makedelta of "true", not just truthy existence.
Fix some whitespace

10 years agoIncrease sleep time in this test
Greg Sabino Mullane [Sat, 6 Dec 2014 17:57:51 +0000 (12:57 -0500)]
Increase sleep time in this test

10 years agoSupport for hinting to the MCP that a database may be down.
Greg Sabino Mullane [Wed, 3 Dec 2014 20:56:25 +0000 (15:56 -0500)]
Support for hinting to the MCP that a database may be down.

10 years agoTests: calls to empty_cluster must now handle an arrayref
Greg Sabino Mullane [Mon, 1 Dec 2014 16:22:09 +0000 (11:22 -0500)]
Tests: calls to empty_cluster must now handle an arrayref

10 years agoAdd tests for new remove all functionality
Greg Sabino Mullane [Fri, 28 Nov 2014 18:03:07 +0000 (13:03 -0500)]
Add tests for new remove all functionality

10 years agoAllow removing all tables or sequences at once via command line, e.g. 'bucardo remove...
Greg Sabino Mullane [Fri, 28 Nov 2014 16:24:55 +0000 (11:24 -0500)]
Allow removing all tables or sequences at once via command line, e.g. 'bucardo remove all tables'

10 years agoAllow --makedelta=foo to work on command line when adding all tables
Greg Sabino Mullane [Fri, 28 Nov 2014 12:55:09 +0000 (07:55 -0500)]
Allow --makedelta=foo to work on command line when adding all tables

10 years agoAllwo --dryrun to work when adding items, esp. tables
Greg Sabino Mullane [Fri, 28 Nov 2014 12:44:12 +0000 (07:44 -0500)]
Allwo --dryrun to work when adding items, esp. tables

10 years agoMinor test adjustments
Greg Sabino Mullane [Fri, 28 Nov 2014 12:27:52 +0000 (07:27 -0500)]
Minor test adjustments

10 years agoChange some truncates to deletes: truncate just not MVCC-safe enough yet.
Greg Sabino Mullane [Fri, 28 Nov 2014 12:27:20 +0000 (07:27 -0500)]
Change some truncates to deletes: truncate just not MVCC-safe enough yet.

10 years agoAdd new test file 50-star.t
Greg Sabino Mullane [Thu, 27 Nov 2014 17:49:37 +0000 (12:49 -0500)]
Add new test file 50-star.t

10 years agoMake sure we quote sequence name in the tests.
Greg Sabino Mullane [Thu, 27 Nov 2014 17:34:55 +0000 (12:34 -0500)]
Make sure we quote sequence name in the tests.

10 years agoWhen showing microseconds in the log, force the third and final zero to appear
Greg Sabino Mullane [Wed, 26 Nov 2014 23:30:59 +0000 (18:30 -0500)]
When showing microseconds in the log, force the third and final zero to appear

10 years agoTesting changes: allow creation of "extra" numberic databases e.g. B1, B2, B3
Greg Sabino Mullane [Wed, 26 Nov 2014 23:28:52 +0000 (18:28 -0500)]
Testing changes: allow creation of "extra" numberic databases e.g. B1, B2, B3
Increase the timeout for Bucardo startup because of heavy tests
Boost max_connections to 150 for database A, and to 75 for all others

10 years agoMerge branch 'master' of bucardo.org:/var/lib/git/bucardo
Greg Sabino Mullane [Tue, 25 Nov 2014 20:26:32 +0000 (15:26 -0500)]
Merge branch 'master' of bucardo.org:/var/lib/git/bucardo

10 years agoHave bucardo list tables show the makedelta information
Greg Sabino Mullane [Tue, 25 Nov 2014 20:26:06 +0000 (15:26 -0500)]
Have bucardo list tables show the makedelta information

10 years agoRandom reminder in TODO
Greg Sabino Mullane [Tue, 25 Nov 2014 20:25:51 +0000 (15:25 -0500)]
Random reminder in TODO

10 years agoRevert "minor change; commit test"
David Christensen [Tue, 25 Nov 2014 19:48:45 +0000 (13:48 -0600)]
Revert "minor change; commit test"

This reverts commit 18576b348cf46a7c2014397e6a576be07e2ab9ba.

10 years agominor change; commit test
David Christensen [Tue, 25 Nov 2014 15:07:29 +0000 (09:07 -0600)]
minor change; commit test

10 years agoDon't worry about running pg_cancel if our txn errored out because of serialization...
Greg Sabino Mullane [Tue, 25 Nov 2014 19:43:42 +0000 (14:43 -0500)]
Don't worry about running pg_cancel if our txn errored out because of serialization errors.

10 years agoRevert "minor change; commit test"
David Christensen [Tue, 25 Nov 2014 19:35:55 +0000 (13:35 -0600)]
Revert "minor change; commit test"

This reverts commit 56f3480829920d75676cb258f1e41e6572f38485.

10 years agoBetter filtering in tests
Greg Sabino Mullane [Tue, 25 Nov 2014 19:34:31 +0000 (14:34 -0500)]
Better filtering in tests

10 years agoWhen validate_sync fails, show the error in the logs
Greg Sabino Mullane [Tue, 25 Nov 2014 19:23:15 +0000 (14:23 -0500)]
When validate_sync fails, show the error in the logs

10 years agoRevert work-in-progress test file
Greg Sabino Mullane [Tue, 25 Nov 2014 19:00:30 +0000 (14:00 -0500)]
Revert work-in-progress test file

10 years agoMerge branch 'master' of bucardo.org:/var/lib/git/bucardo
Greg Sabino Mullane [Tue, 25 Nov 2014 18:49:32 +0000 (13:49 -0500)]
Merge branch 'master' of bucardo.org:/var/lib/git/bucardo

10 years agoWhen the VAC exits, disconnect from any databases cleanly we may still be connected to.
Greg Sabino Mullane [Tue, 25 Nov 2014 18:49:03 +0000 (13:49 -0500)]
When the VAC exits, disconnect from any databases cleanly we may still be connected to.

10 years agominor change; commit test
David Christensen [Tue, 25 Nov 2014 15:07:29 +0000 (09:07 -0600)]
minor change; commit test

10 years agoRevert "minor change; commit test"
David Christensen [Tue, 25 Nov 2014 16:04:09 +0000 (10:04 -0600)]
Revert "minor change; commit test"

This reverts commit 0a2c99ac734532db37741c993c226ebfff53135a.

10 years agominor change; commit test
David Christensen [Tue, 25 Nov 2014 15:07:29 +0000 (09:07 -0600)]
minor change; commit test

10 years agoRevert "minor change; commit test"
David Christensen [Tue, 25 Nov 2014 15:27:02 +0000 (09:27 -0600)]
Revert "minor change; commit test"

This reverts commit 85a180f7d3d657cc72b1fa8e5a9cd7e0033f6f5d.

10 years agominor change; commit test
David Christensen [Tue, 25 Nov 2014 15:07:29 +0000 (09:07 -0600)]
minor change; commit test

10 years agoRevert "minor change; commit test"
David Christensen [Tue, 25 Nov 2014 15:24:21 +0000 (09:24 -0600)]
Revert "minor change; commit test"

This reverts commit 7d8c1552346ae84ffc953d9608f66bb4d32aaedd.

10 years agominor change; commit test
David Christensen [Tue, 25 Nov 2014 15:07:29 +0000 (09:07 -0600)]
minor change; commit test

10 years agoNext version will be 5.3.0 due to makedelta per db change
Greg Sabino Mullane [Tue, 25 Nov 2014 15:03:36 +0000 (10:03 -0500)]
Next version will be 5.3.0 due to makedelta per db change

10 years agoNote recent changes
Greg Sabino Mullane [Tue, 25 Nov 2014 12:27:49 +0000 (07:27 -0500)]
Note recent changes