Christopher Browne [Tue, 28 Apr 2009 21:08:59 +0000 (21:08 +0000)]
Minor reformat of readme - missing CRLF on final line
Christopher Browne [Tue, 28 Apr 2009 19:25:36 +0000 (19:25 +0000)]
Leading $ is forbidden in cluster names
Christopher Browne [Tue, 28 Apr 2009 18:00:46 +0000 (18:00 +0000)]
Update installation & prerequisite notes to be more aware of the
variations between major versions of Slony-I
Christopher Browne [Tue, 28 Apr 2009 14:36:21 +0000 (14:36 +0000)]
Add in an at-functions-load-time test which validates that the
cluster name is valid, to address a difference in behaviour between
slonik and pgAdminIII
Christopher Browne [Tue, 28 Apr 2009 14:33:11 +0000 (14:33 +0000)]
Fix up makefile per comments from Peter Eisentraut
Christopher Browne [Wed, 22 Apr 2009 16:44:58 +0000 (16:44 +0000)]
Fix variable name per report from Cyril Scetbon
Christopher Browne [Thu, 16 Apr 2009 21:30:27 +0000 (21:30 +0000)]
Add in notes about recent changes
Christopher Browne [Thu, 16 Apr 2009 16:47:41 +0000 (16:47 +0000)]
Bug #88 - Inconsistency in names of manual pages
Christopher Browne [Thu, 16 Apr 2009 16:45:42 +0000 (16:45 +0000)]
Bug #87 - some slonik command examples were missing a mandatory EVENT NODE
parameter
Christopher Browne [Thu, 16 Apr 2009 16:11:35 +0000 (16:11 +0000)]
Bug #86 - only install man pages if we actually were in a position to
build them
Christopher Browne [Thu, 16 Apr 2009 15:55:01 +0000 (15:55 +0000)]
Bug #85 - used wrong substitution
Christopher Browne [Thu, 16 Apr 2009 15:47:25 +0000 (15:47 +0000)]
Per bug #84 - need to revise installation notes to reflect that v2.0
is no longer compatible with PostgreSQL versions earlier than 8.3
Devrim GUNDUZ [Tue, 14 Apr 2009 09:36:43 +0000 (09:36 +0000)]
Remove excess commas in SET DROP SEQUENCE examples, per #82 (Stephane Schildknecht)
Christopher Browne [Thu, 9 Apr 2009 21:57:22 +0000 (21:57 +0000)]
Ran autoconf 2.63 against latest autoconf.ac
Christopher Browne [Thu, 9 Apr 2009 21:55:27 +0000 (21:55 +0000)]
Per bug report #79 - error message encountered when running recent
autoconf (2.63) on autoconf.ac.
-----------------
configure.ac:89: error: AC_SUBST: `2.0.1' is not a valid shell variable name
configure.ac:89: the top level
autom4te: /usr/bin/m4 failed with exit status: 1
error: Bad exit status from /var/tmp/rpm-tmp.CLmZ2P (%build)
-----------------
Commented out AC_SUBST(SLONREL_VERSION), which is the nexus of the problem.
SLONREL_VERSION isn't used in any of the .in files, so this seems a safe
change.
Christopher Browne [Wed, 8 Apr 2009 15:59:46 +0000 (15:59 +0000)]
Adding a bit to the torture of the schema test...
Remove the "public" schema altogether, using schema "foo" instead.
This as a result of an issue brought up on list by Shoaib Mir...
Christopher Browne [Mon, 6 Apr 2009 22:33:05 +0000 (22:33 +0000)]
Fix bug #76 - REPAIR CONFIG could have collisions where, when we load a
schema, one entry in sl_table already has an OID value that incorrectly
matches a value that another update is trying to fix.
This would cause REPAIR CONFIG to fail.
Put in a query that updates the oids in sl_table and sl_sequence to
randomly selected values from pg_class that couldn't match (since the
values selected are from non-table/non-sequence objects)
Christopher Browne [Thu, 2 Apr 2009 20:35:19 +0000 (20:35 +0000)]
Fix to start_slon.sh per Dimitry Koterov
Christopher Browne [Thu, 2 Apr 2009 18:52:25 +0000 (18:52 +0000)]
Elaborate on the transactionality that try{} blocks provide... They do NOT
force downstream processing of events to nest the processing into a single
transaction.
As pointed out by Dmitry Koterov on list
Christopher Browne [Wed, 1 Apr 2009 21:04:11 +0000 (21:04 +0000)]
Improve comment about config option
Christopher Browne [Wed, 1 Apr 2009 19:03:27 +0000 (19:03 +0000)]
Improve documentation of what MERGE SET does, per Mark Stosberg
Christopher Browne [Wed, 1 Apr 2009 17:13:38 +0000 (17:13 +0000)]
Mark version 2.0.2
Christopher Browne [Wed, 1 Apr 2009 17:13:05 +0000 (17:13 +0000)]
Fixed bug #71 - add to release notes
Christopher Browne [Wed, 1 Apr 2009 17:11:13 +0000 (17:11 +0000)]
Fix bug #71
http://www.slony.info/bugzilla/show_bug.cgi?id=71
- Initial logging of configuration failing on NULL items
Christopher Browne [Fri, 6 Mar 2009 18:54:09 +0000 (18:54 +0000)]
Bastian Voigt pointed out some 1.2-isms in the documentation of
"how to replicate your first database." Fixed!
Christopher Browne [Tue, 3 Mar 2009 22:20:44 +0000 (22:20 +0000)]
Change /usr/bin/sh to /bin/sh per bug#74 per Rod Taylor
Christopher Browne [Fri, 27 Feb 2009 16:44:31 +0000 (16:44 +0000)]
Add in #include that is needed by PG 8.4
Christopher Browne [Thu, 26 Feb 2009 16:24:58 +0000 (16:24 +0000)]
Fix tagging error
Christopher Browne [Thu, 26 Feb 2009 16:14:35 +0000 (16:14 +0000)]
Update the package name string (in the version check) from
"postgresql-slony1-engine" to "slony1"
Christopher Browne [Thu, 26 Feb 2009 16:14:01 +0000 (16:14 +0000)]
At this point, we don't want to by default build the "upgrade to 2.0" tooling as
it doesn't work yet.
Christopher Browne [Mon, 23 Feb 2009 19:09:40 +0000 (19:09 +0000)]
Fix for bug #63 - logtrigger() array overrun
Christopher Browne [Mon, 23 Feb 2009 17:58:53 +0000 (17:58 +0000)]
Trim out obsolete code in "upgrade functions" function
Christopher Browne [Mon, 23 Feb 2009 17:47:33 +0000 (17:47 +0000)]
Update version to 2.0.1
Christopher Browne [Mon, 23 Feb 2009 17:24:23 +0000 (17:24 +0000)]
Add in rule to generate upgrade program
Christopher Browne [Mon, 23 Feb 2009 17:23:55 +0000 (17:23 +0000)]
Fix error in schema comment
Christopher Browne [Mon, 23 Feb 2009 17:21:39 +0000 (17:21 +0000)]
Updates to release notes to indicate addition of preparations of an upgrade
system from 1.2 to 2.0
Christopher Browne [Mon, 23 Feb 2009 17:20:58 +0000 (17:20 +0000)]
Ran autoconf to update the configure script
Christopher Browne [Mon, 23 Feb 2009 17:19:15 +0000 (17:19 +0000)]
Add in preliminaries for a tool (which isn't yet fully implemented) to
do upgrade from v1.2 to v2.0
Christopher Browne [Fri, 20 Feb 2009 15:47:06 +0000 (15:47 +0000)]
Fix rules for building man pages to install the pages en masse rather than
one by one (as done by PostgreSQL), since one-by-one was breaking due to
some of the names containing spaces.
Christopher Browne [Thu, 19 Feb 2009 18:39:50 +0000 (18:39 +0000)]
Change filenames of man pages to include SLONIK, to remove filename clashes
between Slony-I and PostgreSQL.
Christopher Browne [Thu, 19 Feb 2009 16:46:38 +0000 (16:46 +0000)]
Add FAQ entry re email by Karl Lehenbauer about lastval() capturing
Slony-I sequence updates
Christopher Browne [Tue, 17 Feb 2009 17:57:14 +0000 (17:57 +0000)]
Changes to resolve regressions noticed by Hiroshi Saito.
There were some spelling mistakes corrected in the input, but not in
the output.
Christopher Browne [Tue, 3 Feb 2009 18:40:29 +0000 (18:40 +0000)]
Add release notes indicating latest sets of changes in 2.0 branch for 2.0.1
Christopher Browne [Wed, 28 Jan 2009 22:44:01 +0000 (22:44 +0000)]
Add notes about v2.0 not needing xxid.so anymore
Christopher Browne [Wed, 28 Jan 2009 22:43:02 +0000 (22:43 +0000)]
Fix typo - wrong timing
Christopher Browne [Wed, 21 Jan 2009 15:55:46 +0000 (15:55 +0000)]
per Cyril Scetbon, make sure DEBUG_LEVEL is set
Christopher Browne [Fri, 16 Jan 2009 22:59:20 +0000 (22:59 +0000)]
Fix to log purging as per discussion on list...
http://lists.slony.info/pipermail/slony1-bugs/2009-January/000302.html
Also, added recognition of more of the 1.2 branch, and removal of
trigger-related config tables that are no longer needed in v2.0. That is
not all that is needed for an upgrade to 2.0, but it is a step towards
the right direction, and shouldn't worsen the schema :-)
Christopher Browne [Fri, 16 Jan 2009 17:17:31 +0000 (17:17 +0000)]
Add in documentation about complex failover scenarios, e.g. - the handling
of failover where a whole site is lost.
cvs2svn [Fri, 16 Jan 2009 17:16:53 +0000 (17:16 +0000)]
This commit was manufactured by cvs2svn to create branch 'REL_2_0_STABLE'.
Christopher Browne [Fri, 16 Jan 2009 17:16:52 +0000 (17:16 +0000)]
Add in documentation about complex failover scenarios, e.g. - the handling
of failover where a whole site is lost.
Christopher Browne [Mon, 5 Jan 2009 22:05:09 +0000 (22:05 +0000)]
Changes applied to 2.0 also to HEAD
- Fix syntax error in tools/altperl/slon_watchdog.pl
- Add cleanup_interval example to sample slon.conf file
- Add cleanup_interval configuration configuration to regression tests
Per discussion on slony-bugs list with Cyril Scetbon
Christopher Browne [Mon, 5 Jan 2009 22:04:09 +0000 (22:04 +0000)]
- Fix syntax error in tools/altperl/slon_watchdog.pl
- Add cleanup_interval example to sample slon.conf file
- Add cleanup_interval configuration configuration to regression tests
Per discussion on slony-bugs list with Cyril Scetbon
Christopher Browne [Thu, 18 Dec 2008 21:56:20 +0000 (21:56 +0000)]
Failure upon FAIL OVER due to mismatch in #'s of columns in the INSERT
into sl_event
http://lists.slony.info/pipermail/slony1-general/2008-December/009033.html
Christopher Browne [Thu, 18 Dec 2008 21:55:52 +0000 (21:55 +0000)]
Failure upon FAIL OVER due to mismatch in #'s of columns in the INSERT
into sl_event
http://lists.slony.info/pipermail/slony1-general/2008-December/009033.html
Christopher Browne [Thu, 18 Dec 2008 21:35:03 +0000 (21:35 +0000)]
Add in notes about changes (thus far) for 2.0.1, and update release number
in the source code
Christopher Browne [Thu, 18 Dec 2008 21:27:49 +0000 (21:27 +0000)]
Fix to bug #69
http://www.slony.info/bugzilla/show_bug.cgi?id=69
The problem is that one of the new functions expects the type, "vactables", to
exist.
The "upgrade functions" function has code that *would* create it, but that
function is not run until *after* the whole slony1_functions.sql file has been
loaded, and that is way too late.
The attached patch creates, runs, and drops, a temporary function that adds the
type should it be missing.
I have run this through regression test #1 on the HEAD branch, which includes a
run of slonik "UPDATE FUNCTIONS."
Christopher Browne [Thu, 18 Dec 2008 21:27:05 +0000 (21:27 +0000)]
Fix to bug #69
http://www.slony.info/bugzilla/show_bug.cgi?id=69
The problem is that one of the new functions expects the type, "vactables", to
exist.
The "upgrade functions" function has code that *would* create it, but that
function is not run until *after* the whole slony1_functions.sql file has been
loaded, and that is way too late.
The attached patch creates, runs, and drops, a temporary function that adds the
type should it be missing.
I have run this through regression test #1 on the HEAD branch, which includes a
run of slonik "UPDATE FUNCTIONS."
Christopher Browne [Thu, 18 Dec 2008 17:54:38 +0000 (17:54 +0000)]
Per Cyril SCETBON - if there are multiple clusters where the cluster
name of one is a substring of that of the other, and they are running
on the same box, the egrep for slon processes can find both clusters'
slon processes. Add an extra space to allow them to be distinguished.
Christopher Browne [Thu, 18 Dec 2008 17:54:20 +0000 (17:54 +0000)]
Per Cyril SCETBON - if there are multiple clusters where the cluster
name of one is a substring of that of the other, and they are running
on the same box, the egrep for slon processes can find both clusters'
slon processes. Add an extra space to allow them to be distinguished.
Christopher Browne [Mon, 15 Dec 2008 23:30:58 +0000 (23:30 +0000)]
Fix typo in docs - bug #65
http://bugs.slony.info/bugzilla/show_bug.cgi?id=65
Christopher Browne [Mon, 15 Dec 2008 23:30:17 +0000 (23:30 +0000)]
Fix typo in docs - bug #65
http://bugs.slony.info/bugzilla/show_bug.cgi?id=65
Christopher Browne [Mon, 15 Dec 2008 23:26:28 +0000 (23:26 +0000)]
Fix to logging levels per bug #64
http://bugs.slony.info/bugzilla/show_bug.cgi?id=64
Christopher Browne [Mon, 15 Dec 2008 23:26:07 +0000 (23:26 +0000)]
Fix to logging levels per bug #64
http://bugs.slony.info/bugzilla/show_bug.cgi?id=64
Devrim GUNDUZ [Mon, 8 Dec 2008 21:24:25 +0000 (21:24 +0000)]
Fix Source0, per bug #66.
Devrim GUNDUZ [Tue, 2 Dec 2008 21:40:10 +0000 (21:40 +0000)]
Fix filename
cvs2svn [Mon, 24 Nov 2008 15:06:20 +0000 (15:06 +0000)]
This commit was manufactured by cvs2svn to create branch 'REL_2_0_STABLE'.
Christopher Browne [Mon, 24 Nov 2008 15:06:18 +0000 (15:06 +0000)]
Patch from Hiroshi Saito to resolve some Windows problems with 2.0
Christopher Browne [Mon, 24 Nov 2008 14:50:22 +0000 (14:50 +0000)]
Change over to v2.0. Essentially, that blanks this file.
The changes between 1.2 and 2.0 are in the RELEASE-2.0 file
Christopher Browne [Mon, 17 Nov 2008 22:47:45 +0000 (22:47 +0000)]
Update release notes
Christopher Browne [Mon, 17 Nov 2008 22:41:21 +0000 (22:41 +0000)]
Clean up WAIT FOR EVENT example
Christopher Browne [Mon, 17 Nov 2008 22:40:27 +0000 (22:40 +0000)]
Fix typo in documentation
Christopher Browne [Mon, 17 Nov 2008 22:39:47 +0000 (22:39 +0000)]
Fix problem with cleanup function - it was performing an "imperative
select" which isn't permissible
Christopher Browne [Mon, 17 Nov 2008 22:38:50 +0000 (22:38 +0000)]
Fix typo
Christopher Browne [Mon, 17 Nov 2008 22:35:16 +0000 (22:35 +0000)]
Added patch per Richard Yen to allow log shipper to rescan automatically
Christopher Browne [Thu, 6 Nov 2008 21:40:42 +0000 (21:40 +0000)]
Fix typo reported by Jaime Casanova
Devrim GUNDUZ [Tue, 21 Oct 2008 13:58:16 +0000 (13:58 +0000)]
Fix sgml error
Christopher Browne [Wed, 15 Oct 2008 21:51:54 +0000 (21:51 +0000)]
Fixes to SGML tagging - per Devrim's email of Oct 14th
Devrim GUNDUZ [Mon, 13 Oct 2008 21:39:40 +0000 (21:39 +0000)]
Fix sgml errors
Devrim GUNDUZ [Mon, 13 Oct 2008 21:27:10 +0000 (21:27 +0000)]
Fix sgml errors
Devrim GUNDUZ [Mon, 13 Oct 2008 20:18:54 +0000 (20:18 +0000)]
Fix sgml errors
Devrim GUNDUZ [Mon, 13 Oct 2008 20:12:55 +0000 (20:12 +0000)]
Fix sgml errors
Devrim GUNDUZ [Mon, 13 Oct 2008 20:07:27 +0000 (20:07 +0000)]
Fix sgml errors
Devrim GUNDUZ [Mon, 13 Oct 2008 19:48:06 +0000 (19:48 +0000)]
Fix sgml errors
Devrim GUNDUZ [Mon, 13 Oct 2008 19:29:12 +0000 (19:29 +0000)]
Fix sgml errors
Devrim GUNDUZ [Mon, 13 Oct 2008 19:16:27 +0000 (19:16 +0000)]
Fix sgml errors
Christopher Browne [Fri, 3 Oct 2008 16:41:23 +0000 (16:41 +0000)]
Add FAQ about use of "oid" column on replicable table
Christopher Browne [Thu, 25 Sep 2008 14:45:40 +0000 (14:45 +0000)]
Add recent changes to v2.0 release notes
Christopher Browne [Wed, 24 Sep 2008 21:15:41 +0000 (21:15 +0000)]
Ran autoconf with latest changes
Christopher Browne [Wed, 24 Sep 2008 19:54:09 +0000 (19:54 +0000)]
Resolution to bug #46 - incompatibility with PG 8.4.
- Set up autoconf to detect whether or not GetActiveSnapshot() is
available, and set up #define if it is
- Then config.h.in needs the #define variable, and slony1_funcs.c
refers to it to control whether it uses the old variable or the
new function.
Christopher Browne [Tue, 23 Sep 2008 21:46:23 +0000 (21:46 +0000)]
Changes to WAIT FOR EVENT requests; the "ongoing saga" of getting the
tests to be a bit more conservative so they are more likely to pass :-).
Christopher Browne [Tue, 23 Sep 2008 20:31:09 +0000 (20:31 +0000)]
Add in 2 second lags; this exercises the lag logic, and will lead to some
pauses in replication that should be useful for small tests in tossing in
a bit more asynchronous behaviour
Christopher Browne [Thu, 18 Sep 2008 21:30:08 +0000 (21:30 +0000)]
Note change in post-8.0 PG releases regarding TCP/IP sockets
Christopher Browne [Thu, 18 Sep 2008 21:29:36 +0000 (21:29 +0000)]
Add a note about an error message that can come up with STORE PATH,
SUBSCRIBE SET resulting from a foreign key violation
Christopher Browne [Thu, 18 Sep 2008 21:28:45 +0000 (21:28 +0000)]
Fix tagging error
Christopher Browne [Thu, 18 Sep 2008 21:28:18 +0000 (21:28 +0000)]
Add notes about locking of STORE TRIGGER operation
Christopher Browne [Thu, 18 Sep 2008 21:27:41 +0000 (21:27 +0000)]
Add in new material provided by Martin Eriksson
Christopher Browne [Thu, 18 Sep 2008 21:26:29 +0000 (21:26 +0000)]
Make comment clearer
Christopher Browne [Fri, 29 Aug 2008 21:06:45 +0000 (21:06 +0000)]
Fix format strings in log messages
Christopher Browne [Fri, 22 Aug 2008 22:38:19 +0000 (22:38 +0000)]
Revise WAN discussion to make it clearer, as there was some confusion
expressed on the mailing list.
Jan Wieck [Fri, 8 Aug 2008 17:52:48 +0000 (17:52 +0000)]
Dollar quoting broke sequenceSetValue().
Jan