forked from ssinger/slony1-engine
-
Notifications
You must be signed in to change notification settings - Fork 0
/
RELEASE
257 lines (168 loc) · 9.57 KB
/
RELEASE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
#+OPTIONS: ^:{}
* Slony-I Release Notes
** 2.1.5
- Bug 315 :: Fixes to the compile time include directories
- Remove HAVE_POSIX_SIGNALS from config.h
** 2.1.4
- Bug #299 :: Fix race condition in MOVE SET where a third node could pull data from the old origin using
SYNC/snapshot values from the new origin
- No bug :: Make log_truncate() SECURITY DEFINER.
- No bug :: WIN32 makefile fixes
- No bug :: List PostgreSQL 9.3 as a supported version
** 2.1.3
- Bug #285 :: Fix race condition with MOVE SET where a third node could get updated to the wrong SYNC number
- Bug #276 :: Fixed duplicate key detection on sl_nodelock
- Bug #278 :: assorted spelling fixes
- No bug :: Add in explicit support to recognize PostgreSQL 9.2, rather than warning that it may not be supported
- No bug :: add --with-pgport option to configure and when set to yes let slonik use these functions to determine
the PGSHARE directory at runtime. This defaults to no
** 2.1.2
- Bug #275 :: Fixed memory leak in monitor thread
- Bug #272 :: Fix memory overwrite in slonik parsing
- Bug #268 :: PostgreSQL 9.2 has changed pg_stat_activity.procpid to pid
- Bug #263 :: CPPFLAGS and LDFLAGS get passed from configure
- Bug #274 :: Include schemadoc.xml as part of the distribution tar(again)
- Bug #264 :: Add an ORDER BY to the log selection query so the xid's get compressed
- Bug #258 :: The cleanup thread should no longer block waiting on a lock
** 2.1.1
- Bug #260 :: Fixed issue when with FAILOVER command when the failed node has
multiple sets.
Release Candidate 1
- Bug #246 :: Include path order changes
- Bug #161 :: fix memory overrun in EXECUTE SCRIPT parser
- Bug #247 :: slony_logshipper to handle TRUNCATE commands
- Bug #249 :: Add parentheses to txid_current() in function for
TRUNCATE logging
- slonik_drop_table and slonik_drop_sequence no longer attempt to
return -1 on an error (invalid as a slonik exit code in 2.1)
- Bug #244 :: The CREATE SET command now requires a set id to be specified.
- Bug #255 :: Fix serialization conflict issues when using PostgreSQL 9.1.
- Bug #256 :: set_conf_option() has an extra elevel parameter on PG 9.2
- Bug #259 :: Fix TRUNCATE logging so it works with mixed case slony clusters.
** 2.1.0
** 2.1.0 RC 2
** 2.2.0
- Bug #250 :: Log shipper does not report application name - add in setting of GUC
- Bug #236 :: Fix default formatting of timestamp in logs
- Add support for PostgreSQL 9.1. Simply marking it a supported version
- Bug #237 :: Drop set did not remove truncate triggers.
** 2.1.0 RC 1
- Bug #226 :: Cleanup thread needed change to expected PQResultStatus
- Bug #229 :: Fix to set add table so it won't implicitly wait for an event
inside of a transaction block.
- Bug #230 :: log_timestamps was always treated as false
- Bug #231 :: Fix to regex in tools/start_slon.sh
- Bug #227 :: Do not try to add views to a set with regular expressions in
set add table. Also fixes for escape characters in the regex
- Clearer error message on 'create set' when no origin is specified.
- Clearer error message on 'lock set' when no origin is specified.
- Bug #218 :: Additional fixes, obtain sl_event_lock before sl_config_lock
to prevent deadlock.
- Include additional C headers required for Postgresql 9.2(master)
** 2.1.0 (beta 3)
- Bug #159 :: distclean deletes the slony_logshipper flex/bison generated files.
- Bug #204 :: Additional fixes for failover to a non-direct subscriber
where circular paths in sl_subscribe could happen
- Bug #214 :: Add slonikconfdump.sh back into tools
- Bug #216 :: Use EPOCH for the timestamp in the monitor thread
to avoid differences in how Win32 handles timezones.
- Bug #218 :: Acquire lock on sl_config_lock in much the same fashion as
with sl_event_lock (bug #196)
- Bug #219 :: Default to PostgreSQL 8.4 support if the version of PG is newer
than what slony recognizes.
- Bug #220 :: Fix issue where changing the provider of an existing
subscriber passed parameters in the wrong order to the
stored procedure.
- Bug #222 :: Fixing issue where new connections that call the
logtrigger for the first time might block until an
in progress cleanupEvent finishes.
- Bug #223 :: Clear out the last saved event number when uninstalling
a node. This prevents slonik from waiting for a node it just
uninstalled.
- Bug #224 :: altperl code misspelled "PKEYDTABLES"
*** Some items without bug numbers:
- Fixed slonik memory corruption when it tries to get the last known
event_id from a node that doesn't yet have slony installed.
- Remove rules for building PDFs for the original design docs, in
favor of having the built docs stored in a new "historical
documentation" directory.
** 2.1.0 (beta 2)
- Bug 219 :: Default to PostgreSQL 8.4 support if the version of PG is newer than
what slony recognizes.
- Fix threading issue in monitor_thread where slon_init can be called
without the mutex being locked. This function was written to assume
the mutex lock exists.
- datarootdir warning from autoconf fixed
- Bug #36 - (Reapplied) don't link with pgport on non-Win32 platforms
- Misc compiler warnings including no longer calling get_share_dir from
Postgres if PGSHARE is not defined. Configure should define it.
- Regenerated complexenv.png diagram
- Obtain a lock on sl_event_lock during MOVE_SET
processing in remote_worker.
** 2.1.0 (beta 2)
- Bug #204 :: Upgrade from 2.0.x fails under PostgreSQL 8.3, fixing
issues with failover and non-direct subscribers
- Bug #205 :: Upgrade fails from 2.0.0, return type from cloneNode changes
- Bug #206 :: Do not perform an accidental rollback in a try block
- Bug #208 :: Fixing issues with bulk adding of tables.
- Bug #209 :: Default table ID problem
- Bug #210 :: merge set should wait for both sets to be subscribed
before submitting the merge event.
- Bug #211 :: Modify the altperl tools so they don't enclose statements
that wait for events inside of a 'try' block.
** 2.1.0 (beta 1)
*** Some items without bug numbers:
- Introduced tests using the clustertest framework, consisting of two
sets of tests:
- clustertest/regression - port of the old tests in the tests directory
- clustertest/disorder - new simulated order entry system with a fair bit of concurrency
- Configure and Makefile cleanups and improvements, including
- Configure looks in common locations for some of the DocBook
tooling, so it is less likely to require manual intervention on
some common distributions
- Pick up Groff automagically
- Script to do virtually all the work documented in the [[http://slony.info/documentation/2.0/releasechecklist.html][Release Checklist]]
- Documentation updates
- Reorganized sections
- Trend towards having version-specific documentation, rather than
trying to have it document all versions at once
- Git changes
- Numerous .gitignore files set up to ignore generated files
- Add a resetSession function that will reset the session state
cached in the C stored functions.
*** Changes from 2.0 branch that were also applied to HEAD:
Bugs 40, 42, 75, 78, 102, 104, 115, 117, 121, 122, 124, 127, 132,
136, 138, 139, 141, 144, 147, 148, 149, 154, 162
*** Items tracked from Bugzilla
- Bug #79 :: --prefix and --exec-prefix options don't function as expected
- Bug #90 :: Builds On Solaris with Sun C Studio fail. This also addresses
issues building with Microsoft Visual Studio.
- Bug #126 :: TCP KEEP alives can now be used from slon to postgresql(on by default)
- Bug #134 :: TRUNCATE trigger usage
- Bug #142 :: better document minimal security profile
- Bug #146 :: Removed option to use DELETE to trim sl_log_* tables - only support TRUNCATE
- Bug #152 :: eliminate debugging statements from DDL processing
- Bug #156 :: add health check at slon startup time
- Bug #163 :: change Slony-I tables to use TIMESTAMP WITH TIME ZONE rather than WITHOUT TIME ZONE
- Bug #167 :: change queries against sl_log_* tables to avert slowdown when large backlog
- Bug #170 :: remove SNMP support
- Bug #172 :: add support for application_name GUC (in recent PG such as 9.0)
- Bug #175 :: add monitoring thread which stows activity information in sl_components
- Bug #179 :: Implicit/Automatic wait for. Slonik will now often perform an automatic
'wait for event' when required to avoid race conditions.
- Bug #180 :: Created a slonik DATE command
- Bug #181 :: Support for bulk adding of tables and sequences and automatically finding
the next available table or sequence id.
- Bug #185 :: change functions to use named parameters
- Bug #187 :: add newline to slon PID files
- Bug #188 :: test harness query had subquery returning multiple tuples
- Bug #189 :: add slonik EXIT check for exit values 0..255, as that's all that Unix accepts
- Bug #193 :: add back reset of vac_count so vacuums only done every few cleanup thread iterations
- Bug #195 :: change slon_quote_* functions to IMMUTABLE
- Bug #196 :: add guard lock on sl_event_lock to protect against events with XID going backwards
- Bug #198 :: subscribeset() should verify that provider node exists
- Bug #201 :: Allow command-line options to be configured from slon_tools.conf
- Bug #204 :: Fix issue with FAILOVER to a non-direct subscriber introduced in 2.0.5
- Bug #206 :: Do not perform an accidental rollback in a try block
** RELEASE 2.0.6
- Bug #162 :: typenameTypeId() changes signatures in 9.1