Greg Sabino Mullane [Fri, 29 May 2015 15:00:20 +0000 (11:00 -0400)]
Update the Changes file with latest items; fix spelling error.
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)
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
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.
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
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.
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.
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.
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.
Greg Sabino Mullane [Wed, 20 May 2015 16:45:13 +0000 (12:45 -0400)]
Throw an "upgrade" call into the testing
Greg Sabino Mullane [Tue, 19 May 2015 03:05:58 +0000 (23:05 -0400)]
More support for my crappy typing skills.
Greg Sabino Mullane [Fri, 15 May 2015 15:53:08 +0000 (11:53 -0400)]
Typo
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.
Greg Sabino Mullane [Tue, 12 May 2015 02:39:46 +0000 (22:39 -0400)]
Debug cleanups
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.
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.
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.
Greg Sabino Mullane [Fri, 1 May 2015 20:51:15 +0000 (16:51 -0400)]
Remove errant tab
Greg Sabino Mullane [Fri, 1 May 2015 02:19:41 +0000 (22:19 -0400)]
Update Changes file
Greg Sabino Mullane [Fri, 1 May 2015 02:09:43 +0000 (22:09 -0400)]
Prevent spurious warnings when testing older versions of Postgres
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.
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.
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.
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.
Greg Sabino Mullane [Tue, 28 Apr 2015 22:30:23 +0000 (18:30 -0400)]
More version routing bugs
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!
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.
Greg Sabino Mullane [Tue, 28 Apr 2015 19:33:57 +0000 (15:33 -0400)]
Add a noop sslmode to the tests
Greg Sabino Mullane [Tue, 28 Apr 2015 16:35:52 +0000 (12:35 -0400)]
Fix missing semicolon when building DSN
Greg Sabino Mullane [Sat, 25 Apr 2015 12:07:10 +0000 (08:07 -0400)]
Update the Changes file with recent activity
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
Mathieu Arnold [Mon, 20 Apr 2015 13:45:20 +0000 (09:45 -0400)]
Adjustments for new version of ExtUtils::MakeMaker
David Christensen [Fri, 17 Apr 2015 18:09:51 +0000 (13:09 -0500)]
Allow dashes in valid schema and table names
Greg Sabino Mullane [Sun, 12 Apr 2015 03:15:30 +0000 (23:15 -0400)]
Minor var renamings
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.
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.
Greg Sabino Mullane [Thu, 9 Apr 2015 15:06:06 +0000 (11:06 -0400)]
Documentation typo
Greg Sabino Mullane [Wed, 8 Apr 2015 01:07:42 +0000 (21:07 -0400)]
Whitespace
Greg Sabino Mullane [Thu, 2 Apr 2015 01:58:29 +0000 (21:58 -0400)]
Simplify push_rows and change args from eight to five.
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.
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
Greg Sabino Mullane [Thu, 26 Mar 2015 19:34:43 +0000 (15:34 -0400)]
Fix up some weird whitespace problems
Greg Sabino Mullane [Thu, 26 Mar 2015 19:25:22 +0000 (15:25 -0400)]
Some infrastructure for the upcoming bucardo clone feature
Greg Sabino Mullane [Mon, 23 Mar 2015 16:18:36 +0000 (12:18 -0400)]
Let's remove plperl someday if we can.
Greg Sabino Mullane [Sun, 22 Mar 2015 03:16:54 +0000 (23:16 -0400)]
Respect the QUIET flag when creating the superuser.
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)
Greg Sabino Mullane [Fri, 20 Mar 2015 22:11:15 +0000 (18:11 -0400)]
Tweak gitignore
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.
Greg Sabino Mullane [Fri, 20 Mar 2015 20:41:28 +0000 (16:41 -0400)]
Move manifest file around
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.
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.
Greg Sabino Mullane [Mon, 16 Mar 2015 22:14:29 +0000 (18:14 -0400)]
Move flatfile and semaphore creation before trigger disabling, etc.
Greg Sabino Mullane [Mon, 16 Mar 2015 22:04:03 +0000 (18:04 -0400)]
Move transaction start and isolation level setting into separate sub
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.
Greg Sabino Mullane [Mon, 16 Mar 2015 04:41:03 +0000 (00:41 -0400)]
Test the lockfile creation
Greg Sabino Mullane [Sun, 15 Mar 2015 13:52:21 +0000 (09:52 -0400)]
Simplify the new index subroutines
Greg Sabino Mullane [Sun, 15 Mar 2015 03:42:34 +0000 (23:42 -0400)]
Add 'PRAGMA defer_foreign_keys' for sqlite targets
Greg Sabino Mullane [Sun, 15 Mar 2015 03:29:40 +0000 (23:29 -0400)]
Cleanup and refactor the rebuild_index code.
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.
Greg Sabino Mullane [Sun, 15 Mar 2015 03:26:28 +0000 (23:26 -0400)]
Test rebuild_index
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...
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.
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.
Greg Sabino Mullane [Tue, 10 Mar 2015 02:26:15 +0000 (22:26 -0400)]
Move a file around
Greg Sabino Mullane [Thu, 26 Feb 2015 03:39:17 +0000 (22:39 -0500)]
Housekeeping
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.
Greg Sabino Mullane [Mon, 23 Feb 2015 15:42:41 +0000 (10:42 -0500)]
Quick idea from #bucardo
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
Greg Sabino Mullane [Mon, 16 Feb 2015 20:04:26 +0000 (15:04 -0500)]
Quick note about listen/notify enhancement
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.
Greg Sabino Mullane [Thu, 29 Jan 2015 02:01:02 +0000 (21:01 -0500)]
Minor comment tweaks
Greg Sabino Mullane [Wed, 28 Jan 2015 04:27:59 +0000 (23:27 -0500)]
Code cleanup: simplify the second dbpass eliding bit.
Greg Sabino Mullane [Wed, 28 Jan 2015 04:20:52 +0000 (23:20 -0500)]
Mild code cleanup and refactoring.
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
Greg Sabino Mullane [Tue, 27 Jan 2015 18:48:46 +0000 (13:48 -0500)]
Signature for 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
Greg Sabino Mullane [Mon, 26 Jan 2015 12:08:27 +0000 (07:08 -0500)]
Minor cleanups and variable renames
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.
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
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,
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.
Greg Sabino Mullane [Sat, 3 Jan 2015 17:05:08 +0000 (12:05 -0500)]
Bump copyright to 2015
Greg Sabino Mullane [Mon, 22 Dec 2014 15:13:11 +0000 (10:13 -0500)]
URLs moves again for submitting news to postgres.org
Greg Sabino Mullane [Mon, 22 Dec 2014 15:02:36 +0000 (10:02 -0500)]
Release 5.3.0
Greg Sabino Mullane [Mon, 22 Dec 2014 15:01:49 +0000 (10:01 -0500)]
Fix release date
Greg Sabino Mullane [Mon, 22 Dec 2014 15:00:35 +0000 (10:00 -0500)]
Final Changes entry for 5.3.0
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
Greg Sabino Mullane [Mon, 22 Dec 2014 14:37:36 +0000 (09:37 -0500)]
Minor HTML doc changes
Greg Sabino Mullane [Mon, 22 Dec 2014 13:24:10 +0000 (08:24 -0500)]
Update changes for 5.3.0
Greg Sabino Mullane [Mon, 22 Dec 2014 03:45:23 +0000 (22:45 -0500)]
Quote bug!
Greg Sabino Mullane [Mon, 22 Dec 2014 02:38:15 +0000 (21:38 -0500)]
Remove old debug line
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}
Greg Sabino Mullane [Sun, 21 Dec 2014 22:12:08 +0000 (17:12 -0500)]
Many Perl::Critic tweaks
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.
Greg Sabino Mullane [Sat, 20 Dec 2014 01:54:15 +0000 (20:54 -0500)]
Spelling tweaks
Greg Sabino Mullane [Fri, 19 Dec 2014 14:22:24 +0000 (09:22 -0500)]
Testing tweak
Greg Sabino Mullane [Fri, 19 Dec 2014 05:11:52 +0000 (00:11 -0500)]
Do not overwrite existing makedelta state for tables
Greg Sabino Mullane [Fri, 19 Dec 2014 04:41:12 +0000 (23:41 -0500)]
Improve 50-star tests
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.
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.