Steve Singer [Thu, 3 Nov 2022 13:12:31 +0000 (09:12 -0400)]
Remove second unsupported warning for PG 15
Steve Singer [Mon, 31 Oct 2022 15:45:24 +0000 (11:45 -0400)]
Add PostgreSQL trademark notice
Steve Singer [Wed, 2 Nov 2022 20:42:36 +0000 (16:42 -0400)]
Update Unsupported warning to PG 15
Steve Singer [Sun, 9 Oct 2022 19:51:25 +0000 (15:51 -0400)]
Fix test SQL
Steve Singer [Sun, 9 Oct 2022 19:50:50 +0000 (15:50 -0400)]
Remove standard_conforming_strings autoconf check.
It is not actually used for anythign
Steve Singer [Sun, 9 Oct 2022 19:49:54 +0000 (15:49 -0400)]
utils/int8.h is not present in PG 15 but is required in PG 9.6
Make the include conditional
Steve Singer [Mon, 9 May 2022 11:52:48 +0000 (07:52 -0400)]
Fix typo in admin guide
Patch by Pierre FICHET<pierre.fichet@aplanet.org>
Steve Singer [Sun, 22 Nov 2020 16:59:28 +0000 (11:59 -0500)]
Remove unsupported warning on PG13
Bump version to 2.2.9
Patch by Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>
Steve Singer [Sun, 29 Nov 2020 03:20:34 +0000 (22:20 -0500)]
'dash' the sh shell on debian systems does not respect/support
echo -e. The escape sequence was not putting \end into the document.
To avoid compatibility issues between 'dash' and a real 'sh'
we will use printf
Steve Singer [Sun, 29 Nov 2020 03:20:00 +0000 (22:20 -0500)]
fix error(typo?) in reference to the table sl-log-script
Steve Singer [Sun, 29 Nov 2020 03:19:19 +0000 (22:19 -0500)]
Fix some SGML markup
Steve Singer [Sun, 23 Aug 2020 02:38:11 +0000 (22:38 -0400)]
Fix https://github.com/ssinger/slony1-engine/issues/19
slonik_build_env was failing on PG11+ because the relhaspkey column
no longer exists
Conflicts:
RELEASE
Steve Singer [Sun, 24 May 2020 00:35:03 +0000 (20:35 -0400)]
move variable declarations to the .c file
headers should only include extern declarations.
Add -fno-common to the default compiler options.
This is now standard with GCC 10+
compilers with -fno-common will error out on the duplicate
definitions.
Steve Singer [Fri, 21 Jun 2019 02:27:03 +0000 (22:27 -0400)]
fix test error
Steve Singer [Sun, 16 Jun 2019 02:09:38 +0000 (22:09 -0400)]
Postgresql 12 has replaced the DirectFunctionCallXXXX series
of functions with ones that take the collation to use.
PG 12 provides "compatability macro's" that use an
InvalidCollation. This causes nameeq function to fail.
We pass in an explicit collation when running against PG12+
Christoph Berg [Fri, 7 Jun 2019 16:30:44 +0000 (18:30 +0200)]
src/backend/Makefile: Add -I. to make enable vpath builds
Debian is building the backend module for several PostgreSQL versions in
parallel, using different build directories. This fix enables this "out
of tree" vpath build.
Christoph Berg [Fri, 7 Jun 2019 16:29:45 +0000 (18:29 +0200)]
src/parsestatements/Makefile: Add missing CPPFLAGS and LDFLAGS
Spotted by blhc, build log hardening check.
Christoph Berg [Fri, 7 Jun 2019 16:27:29 +0000 (18:27 +0200)]
Don't include timestamps in doc to make build binary reproducible
Steve Singer [Mon, 17 Dec 2018 18:45:11 +0000 (13:45 -0500)]
Fix some of the documented defaults for slon configuration values
Patch from Richard Yen <richard.yen@enterprisedb.com>
Steve Singer [Thu, 18 Oct 2018 02:12:46 +0000 (22:12 -0400)]
Fix win32 build issues with PG11
David Fetter [Sun, 9 Sep 2018 22:45:37 +0000 (15:45 -0700)]
Stop referring to 8.4 as though it were current
In passing, clear up some comments.
Steve Singer [Sun, 13 Aug 2017 02:48:38 +0000 (22:48 -0400)]
Fix issue where DDL issued against a non-origin node
can be duplicated.
The code intended to only use the provider that the
event was received from when querying sl_log_script but
not sets however the old queries in the provider structure
from previous syncs were not blanked and those queries were
being issued against the other providers.
Blank the provider query for providers we won't be using and
ignore those providers.
Steve Singer [Wed, 8 Aug 2018 15:18:10 +0000 (11:18 -0400)]
Documentation update for SLONY_SHARE_DIR
Steve Singer [Wed, 8 Aug 2018 15:15:11 +0000 (11:15 -0400)]
Have the slony share directory come from the
environment variable SLONY_SHARE_DIR not PGHOME.
Also make this happen with or without PGPORT
Steve Singer [Wed, 1 Aug 2018 19:22:15 +0000 (15:22 -0400)]
update example in the docs (set add sequence)
Steve Singer [Wed, 1 Aug 2018 19:13:46 +0000 (15:13 -0400)]
Fix bug in set add sequence(set id=1, sequences='test\\.seq*');
where the regex esacping for sequences was not working like
it did for tables in 'set add table'.
Steve Singer [Mon, 21 May 2018 14:13:21 +0000 (10:13 -0400)]
1. Add an option to slonik to disable the version check
against the slony schema
2. Add an option to make the remote listener use a
READ COMMITTED instead of a serialized deferrable
transaction
3. If slonik was not compiled with pgport then allow
PG_HOME to override/set the location of the share directory
containing the slony .sql files
Patches from Tom Tignor<ttignor@akamai.com>.
Steve Singer [Mon, 11 Jun 2018 22:29:24 +0000 (18:29 -0400)]
fix awk expression so flex 2.6.x or higher is supported
Steve Singer [Thu, 7 Jun 2018 00:47:00 +0000 (20:47 -0400)]
alter slony1_funcs so they can compile on PG11
Steve Singer [Sat, 24 Mar 2018 02:34:55 +0000 (22:34 -0400)]
fix version check so it doesn't warn about
unsupported PG versions for PG < 11
Thanks Jehan-Guillaume de Rorthais
Steve Singer [Sun, 27 Aug 2017 15:10:56 +0000 (11:10 -0400)]
Fix the version string for PG10
Steve Singer [Sat, 29 Jul 2017 01:56:40 +0000 (21:56 -0400)]
postgesql 10
Steve Singer [Thu, 22 Feb 2018 23:08:17 +0000 (18:08 -0500)]
Merge pull request #10 from markstos/remove-summersault
remove typo'ed, expired copyright.
Mark Stosberg [Wed, 31 Jan 2018 19:20:21 +0000 (14:20 -0500)]
remove typo'ed, expired copyright.
I wrote these utilities back in 2006-2008.
There was a typo in the company name, which should have been "Summersault, LLC".
However, that company no longer exists: http://www.summersault.com
To simplify any future copyright concerns for the project, I'm just
removing the copyright statement rather than fix the typo.
Steve Singer [Mon, 10 Jul 2017 02:00:12 +0000 (22:00 -0400)]
Add support for PG10
PostgreSQL 10 does away with the old convention of $MAJOR.$MINOR.$PATCH
The existing version detection parsing code does not deal with the new
convention. Update the configure check, the slonik check and the slon check
to work with the new convention and continue to work with the old one.
Steve Singer [Tue, 25 Apr 2017 12:16:19 +0000 (08:16 -0400)]
failover unit test improvements
Steve Singer [Tue, 25 Apr 2017 12:14:50 +0000 (08:14 -0400)]
Fix segfault introduced by the previous failover
fixes
Steve Singer [Sat, 15 Apr 2017 00:28:58 +0000 (20:28 -0400)]
Further changes related to 'Explicitly disallow createEvent and data changes in the same transaction'
Add in support where the logApply trigger inserst data into a table that has trigger
,which runs on the replica,that then inserts data into another replicated table.
The logApply trigger might have already been called in this transaction but the
logTrigger is then called in the same transaction. We then need to setup
the plans for inserting data into sl_log_1 or sl_log_2
Steve Singer [Mon, 10 Apr 2017 13:40:41 +0000 (09:40 -0400)]
Add unit test for multi-node failover (cascaded) issues
Steve Singer [Mon, 10 Apr 2017 13:38:15 +0000 (09:38 -0400)]
Fix issues with FAILOVER
In particular it is possible when doing a multi-node failover
with a cascaded node for the result after the failover to
have nodes with a self subscription, a row in sl_subscribe
with the provider and receiver equal.
In fixing that issue we also discovered that slon was not
reloading the set origin's into memory following a FAILOVER
command. This could mean that we were processing SYNC events
from a node which without realizing that node now is the origin
for a set.
Steve Singer [Sun, 26 Mar 2017 16:54:46 +0000 (12:54 -0400)]
Explicitly disallow createEvent and data changes in the same transaction.
The same transaction should not have both a row in sl_event and log data
to sl_log_1 or sl_log_2 with the logTrigger. This is not something slonik
would ever do, and the data changes that the logTrigger logs might not get
replicated as part of the event processing(ie for many non SYNC events).
it is also unclear what order the data should be applied in with respect to
the actions of the non-SYNC event.
Steve Singer [Sat, 10 Dec 2016 15:53:40 +0000 (10:53 -0500)]
add release notes for slonik_build_env now supporting
multiple -schema options.
Thanks Marc Cousin <marc.cousin@dalibo.com>
Marc Cousin [Mon, 5 Dec 2016 13:37:02 +0000 (14:37 +0100)]
Support multi-schema in slonik_build_env
Christopher Browne [Tue, 26 Jul 2016 20:05:51 +0000 (16:05 -0400)]
Bug 341 - suppress log trigger/deny when running in 'local' mode
Jan Wieck [Sun, 17 Jul 2016 05:24:47 +0000 (01:24 -0400)]
Adding a 4-node pgbench based tutorial to the docs.
Steve Singer [Sat, 28 May 2016 21:41:42 +0000 (17:41 -0400)]
add supported compatibility for PG 9.5
Steve Singer [Sat, 28 May 2016 16:32:57 +0000 (12:32 -0400)]
Fix GETCONFIGOPTIONBYNAME checking for PG9.6+
Also add the define to config.h.in so it actually gets set
Steve Singer [Mon, 23 May 2016 20:59:11 +0000 (16:59 -0400)]
Add win32/msvc support for 3 argument GetConfigOptionByName
Steve Singer [Sat, 21 May 2016 22:33:50 +0000 (18:33 -0400)]
Fix compile errors against PG 9.6+
The file parser/keywords.h moved to common/keywords.h
but is not actually needed
Christopher Browne [Mon, 30 Nov 2015 16:35:08 +0000 (11:35 -0500)]
Bug #363 - missing WAIT ON in sample script in docs
Christopher Browne [Mon, 30 Nov 2015 16:32:47 +0000 (11:32 -0500)]
Merge branch 'master' of ssh://git.postgresql.org/slony1-engine
Steve Singer [Mon, 9 Nov 2015 21:10:34 +0000 (16:10 -0500)]
Doc sample command change:
exclude the slony schema from the pg_dump for adding a new node
Christopher Browne [Fri, 6 Nov 2015 22:45:53 +0000 (17:45 -0500)]
Merge branch 'master' of ssh://git.postgresql.org/slony1-engine
Steve Singer [Mon, 31 Aug 2015 22:44:11 +0000 (18:44 -0400)]
Add win32 makefile/config support for PG 9.5
Patch by sandeep.thakkar@enterprisedb.com
Christopher Browne [Mon, 13 Jul 2015 19:16:07 +0000 (15:16 -0400)]
PostgreSQL HEAD has added a 3-parameter version of GetConfigOptionByName().
Have autoconf detect this, and pass 3 parms if needful.
Christopher Browne [Mon, 13 Apr 2015 19:21:10 +0000 (15:21 -0400)]
Merge branch 'master' of ssh://git.postgresql.org/slony1-engine
Christopher Browne [Mon, 13 Apr 2015 19:19:22 +0000 (15:19 -0400)]
Add to DDL docs
Steve Singer [Fri, 13 Feb 2015 19:42:09 +0000 (14:42 -0500)]
fix merge error
Steve Singer [Mon, 19 Jan 2015 01:28:48 +0000 (20:28 -0500)]
win32 uses strtok_s not strtok_r
Steve Singer [Sun, 18 Jan 2015 18:22:28 +0000 (13:22 -0500)]
Fix the patch for bug352 so it compiles against PG 8.3
Steve Singer [Thu, 15 Jan 2015 22:56:05 +0000 (17:56 -0500)]
remove unsupported for PG 9.4 since it has ben released
Steve Singer [Mon, 27 Oct 2014 21:01:29 +0000 (17:01 -0400)]
Bug 354
The RebuildListenEntries for a failed node
that provides no subscriptions deletes all listen
entries from that node. The remaining nodes
might still need to listen for these events
if the failover target has them. Otherwise
the FAILOVER_NODE event will wait for this event
but it will never come.
Leave in the listen paths for failed nodes
that don't provide any sets
Steve Singer [Thu, 18 Dec 2014 20:38:08 +0000 (15:38 -0500)]
Bug 356
Apply truncate on replica's as TRUNCATE ONLY.
If the original truncate was a TRUNCATE ONLY then
we also want to just truncate the parent table.
If the original command was an un-restricted truncate
then the truncate trigger will be invoked for each child
table anyway.
Steve Singer [Thu, 15 Jan 2015 20:30:21 +0000 (15:30 -0500)]
add disorder test for cleanup interval(bug 350)
Rose Nancy [Thu, 15 Jan 2015 20:29:25 +0000 (15:29 -0500)]
Bug 350
Make the cleanup_interval argument in the parameter file actually do
what one thinks it does, that is set how many seconds between cleanupEvent
runs.
Christopher Browne [Wed, 17 Dec 2014 22:04:44 +0000 (17:04 -0500)]
Merge branch 'master' of ssh://git.postgresql.org/slony1-engine
Christopher Browne [Tue, 16 Dec 2014 20:30:40 +0000 (15:30 -0500)]
Bug #349 - case insensitivity with cluster name when processing DDL
Cluster name wasn't properly quoted when processing sequence update, this logic only runs when doing DDL.
Added config change to regression tests to have StudlyCase names to ensure this is noticed in future
Conflicts:
RELEASE
Christopher Browne [Tue, 16 Dec 2014 17:45:16 +0000 (12:45 -0500)]
Merge branch 'master' of ssh://git.postgresql.org/slony1-engine
Conflicts:
RELEASE
Christopher Browne [Mon, 15 Dec 2014 23:21:30 +0000 (18:21 -0500)]
Bug #352 - PostgreSQL "head" issues
- INT64_FORMAT refactered out of pg_config.h
- set_config_options() has added another parameter
Christopher Browne [Mon, 15 Dec 2014 23:19:34 +0000 (18:19 -0500)]
Empty out RELEASE notes on master to collect afresh for next version
Christopher Browne [Fri, 12 Dec 2014 23:42:29 +0000 (18:42 -0500)]
Merge branch 'master' of ssh://git.postgresql.org/slony1-engine
Steve Singer [Tue, 9 Dec 2014 02:48:06 +0000 (21:48 -0500)]
Fix comment and log message so it no longer
refers to helper threads(which were removed in 2.2)
Steve Singer [Tue, 9 Dec 2014 02:41:18 +0000 (21:41 -0500)]
Fix comment to reflect the actual default value
Patch by Kazuki Uehara <uehara.kazuki@lab.ntt.co.jp>
Steve Singer [Fri, 25 Jul 2014 15:35:59 +0000 (11:35 -0400)]
Bug 345
The strtok_r on the node list was adding replacing the comma
with a NULL causing only 1 node to get inserted into sl_event.
This mean any nodes that where cascaded only saw 1 of the nodes
in the drop node list.
Call strtok_r on a copy of the list so it can safely be munged.
Also add in a DropNode cluster test to demonstrate test this issue
Steve Singer [Thu, 21 Aug 2014 12:01:03 +0000 (08:01 -0400)]
Include alloca.h
Fix build problems on Solaris/SPARC in slonik due to an
undefined alloca symbol.
Report and fix from Venkata Balaji N
Jan Wieck [Tue, 12 Aug 2014 17:30:04 +0000 (13:30 -0400)]
Remove warning message for possible unsupported version up to 9.4.
Christopher Browne [Thu, 17 Jul 2014 20:26:20 +0000 (16:26 -0400)]
Reset RELEASE notes to be empty, as new development begins on a new branch
Jan Wieck [Mon, 30 Jun 2014 14:34:29 +0000 (10:34 -0400)]
Continue setting options even if a non-existing one
was encountered. Fixes bug 343.
Steve Singer [Tue, 13 May 2014 13:49:37 +0000 (09:49 -0400)]
fixing generate load origin node parameter mismatch
Steve Singer [Mon, 12 May 2014 01:37:45 +0000 (21:37 -0400)]
Bug 342 - Fix various failover issues
This commit fixes some related failover issues
1. The query slonik used to get a node list during failover
was ignoring non-failover targets. This meant that we
would never call preFailover on a node that wasn't a failover
target. This node might then still be trying to use
a failed provider.
2. A node (say node 3) might process a FAILOVER_NODE
event from node 2 (the new-origin) but might not
have yet processed the last event from node 1, the
failed node. We need to make sure that the
subscription paths and listen networks are updated
so we don't only listen for events and data from
failed nodes.
Steve Singer [Mon, 30 Jun 2014 12:37:54 +0000 (08:37 -0400)]
Remove HAVE_POSIX_SIGNALS from config.h
Compiling slony against PG 9.4 gives compiler warnings because the
definition of HAVE_POSIX_SIGNALS has changed. This is defined in pg_config
so we do not really need to redefine it in the config.h slony provides.
We leave the configure check in place to we just don't include it in
the header
Steve Singer [Fri, 2 May 2014 18:27:33 +0000 (14:27 -0400)]
add another multi-node failover configuration to the test
David Christensen [Fri, 25 Apr 2014 18:36:32 +0000 (13:36 -0500)]
Fix typo in preamble for regression tests
Jan Wieck [Sat, 26 Apr 2014 02:41:25 +0000 (22:41 -0400)]
Changing version number of master to 2.3.0
Steve Singer [Thu, 17 Apr 2014 13:54:14 +0000 (09:54 -0400)]
Document the EXECUTE ONLY ON list of nodes syntax
Also add a regression test to test this
Steve Singer [Tue, 8 Apr 2014 01:52:19 +0000 (21:52 -0400)]
Bug 338 - Have ddlScript return a bigint since the action_seq is a bigint
Rose Nancy [Tue, 11 Mar 2014 14:37:00 +0000 (10:37 -0400)]
fixing Deadlock with application during minor version slony upgrade
Rose Nancy [Tue, 11 Mar 2014 14:10:36 +0000 (10:10 -0400)]
fixing Deadlock with application during minor version slony upgrade
Christopher Browne [Wed, 5 Mar 2014 21:48:05 +0000 (16:48 -0500)]
Merge branch 'master' of ssh://git.postgresql.org/slony1-engine
Jan Wieck [Wed, 29 Jan 2014 17:11:57 +0000 (12:11 -0500)]
logApply trigger free()s data from wrong cache entry on evict.
Steve Singer [Wed, 5 Feb 2014 23:33:49 +0000 (18:33 -0500)]
Fixing typo in docs
Thanks Jeff Frost
Rose Nancy [Wed, 29 Jan 2014 17:21:34 +0000 (12:21 -0500)]
Clarify namespace setup in documentation
Steve Singer [Wed, 25 Dec 2013 21:04:06 +0000 (16:04 -0500)]
Bug 326 Run perl tidy on the altperl tools
Formatting changes (perltidy) on the altperl tools
Patch by David Fetter
Steve Singer [Wed, 25 Dec 2013 20:58:46 +0000 (15:58 -0500)]
Bug 325 Make perltool pass level 5 of perlcrit
Patch from David Fetter
Christopher Browne [Thu, 2 Jan 2014 21:15:29 +0000 (16:15 -0500)]
Fix SGML tagging of man page volnum - bug #328
Steve Singer [Thu, 12 Dec 2013 14:26:04 +0000 (09:26 -0500)]
Use server includes for pgport when building slonik
When building with --with-pgport slonik needs to include port.h
port.h is normally found under the server include directory but
some distributions (ie debian libpq-dev) also include it in
/usr/include/postgresql
The fix for bug 315 removed the server include paths from
all client programs including slonik. This went too far,
the actual issue with bug 315 was src/backend failing because
it pulled in the client headers.
If we are building with pgport we will pull in the server
include directories for slonik
Christopher Browne [Mon, 18 Nov 2013 17:02:34 +0000 (12:02 -0500)]
Merge branch 'master' of ssh://git.postgresql.org/slony1-engine
Jan Wieck [Wed, 30 Oct 2013 16:12:11 +0000 (12:12 -0400)]
Disable the "known failing" disorder tests.
Jan Wieck [Tue, 29 Oct 2013 22:48:25 +0000 (18:48 -0400)]
Folding slon.stop() and coordinator.join(slon) into one loop.
Stopping the slons and joining their processes in separate
loops apparently can cause the regression test to hang under
some rare race conditions.
Steve Singer [Thu, 31 Oct 2013 13:05:20 +0000 (09:05 -0400)]
bug 321 - fix to the previous patch for when we have multiple real providers
If the provider list contains multiple providers that actually provide
a set (set_head != NULL) then we want to use those providers and
not skip them