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
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
|
2007-09-14 <y-asaba@sraoss.co.jp>
* Version 3.4.1
* Fix handling failover when health_check was disabled. (Yoshiyuki)
- The bug was introduced in 3.4.
* Fix deadlock while processing Parse message. (Yoshiyuki)
2007-08-01 <y-asaba@sraoss.co.jp>
* Version 3.4
* Add new "replicate_select" directive, being the default value to
be false. (Yoshiyuki)
- If it is true, SELECT query is replicated. This behavior is
same as V3.2 or earlier.
* Improve signal handling. (Yoshiyuki)
- Occasionaly, zombie processes were remained. Or processes were
unstable.
* Fix hang up when SELECT was error inside a transaction
block. The bug was introduced in V3.3. (Yoshiyuki)
* Fix PREPARE/EXECUTE handling in master slave mode. (Yoshiyuki)
* Fix "kind mismatch error" when deadlock error
* Fix hang up and SEGV in extended query protocol when a warning
SQL like "SELECT '\'';" executed. (Yoshiyuki)
* Fix memory leak when connection cache was full. (Yoshiyuki)
2007-05-18 <yamaguchi@sraoss.co.jp>
* Version 3.3
* Improve replication. SELECT nextval() and SELECT setval() are
now replicated. (Yoshiyuki)
* Change SELECT query is only sent to the master node. (Yoshiyuki)
- Use /*REPLICATION*/ comment to repliate a SELECT query.
* Fix unexpected failover error due to receiving an interrupt
signal while connecting to the backend. (Yoshiyuki)
* Fix "ps" output to follow PostgreSQL's output. (Taiki)
* Change the default value for enable_pool_hba to true. (Taiki)
* Add "pgpool.pam" file, for PAM configuration file, to be
installed under "$PREFIX/share/". (Taiki)
2007-02-10 <ishii@sraoss.co.jp>
* Version 3.2
* Support HBA authentication(Taiki)
* Support log_connections(Taiki)
* Support log_hostname(Tatsuo)
* Show pgpool status in ps command(Tatsuo)
* Fix bug with prepared query(Yoshiyuki)
* Detach secondary server when "kind mismatch error" is detected(Tatsuo)
* Re-open socket if it was closed by backend while reusing
connection(Yoshiyuki)
2006-12-12 <y-asaba@sraoss.co.jp>
* Version 3.1.2
* Allow 0 weight(Tatsuo)
* Return correct error messaes when pg_hba.conf auth fails. Patch
contributed by Kenji Kikuchi
* Fix kind mismatch errors with COPY FROM STDIN(Yoshiyuki)
* Allow load balancing with extended protocol(Yoshiyuki)
2006-07-23 <ishii@sraoss.co.jp>
* Version 3.1.1
* Fix LISTEN/NOTIFY bug in master/slave mode reported by Michael
Ulitskiy (Tatsuo)
2006-07-01 <ishii@sraoss.co.jp>
* Version 3.1
* Improve documentation. patches contributed by Mark Stosberg
* Fix "kind is 0!" error in Execute(). Reads messages until
receiving CommandComplete, EmptyQuery, ErrorResponse or
PortalSuspend in Execute() (Yoshiyuki)
* Add log_statement option. patches contributed by Thomas E
Lackey, modifications and documents by Tatsuo
* In SimpleForwardToFrontend() do not send SYNC and wait for ready for
query when PANIC or FATAL error occurs. In this case the backend
closes the communication channel immediately which will cause unwanted
failover/degeneration by, for example, trying to connect to
invalid database (Tatsuo)
* Fix dealock problem in extended modd by calling synchronize() in
Execute if replication_strict is enabled (Yoshiyuki)
* Fix segfault problem in race conditions among
connection_life_time, child_life_time and child_max_connections (Tatsuo)
2006-05-17 <ishii@sraoss.co.jp>
* Version 3.0.2
* pgpool does not exit even if pgpool.conf contents is wrong(Tatsuo)
* Fix buffer overrun bug with long health_check_user name(Taiki)
* Fix occasional segfault with replication and load balance
enabled(bug id #1000548)(Tatsuo)
* Fix pool_send_error_message to send properly NULL terminated
string(Yoshiyuki)
* Fix kind mismatch error in SimpleFowardFrontend(Yoshiyuki)
* Enable to build with BSD make(Yoshiyuki)
* Fix pool_debug and friends to block signals while
executing(Tatsuo)
* Fix numerous bugs with extended query(Yoshiyuki)
* Fix INSERT LOCK(Yoshiyuki)
* Do not reuse startup packet(Tatsuo)
* Automatically DEALLOCTE prepared queries when client
disconnects(Yoshiyuki)
* Do not forward packets when length = 0 in
SimpleForwardToFrontend/SimpleForwardToBackend(Tatsuo)
* Fix lost of kind info(Tatsuo)
2006-02-14 <ishii@sraoss.co.jp>
* Version 3.0.1
* Fix bugs with master/slave mode introduced in 2.7.2. per report
from David Boreham (Tatsuo)
* Fix bugs with master/slave and prepared quries. per report
from David Boreham (Tatsuo)
2006-02-03 <devrim@commandprompt.com>
* Version 3.0.0
* Changed Copyright to PgPool Global Development Group
* Fix a typo in man page
2006-02-02 <ishii@sraoss.co.jp>
* version 2.7.2
* PQnotifes() does not receive immediate responses from LISTEN
* NOTIFY emits packet kind does not agree errors in master/slave
mode
* add pgpool man pages(Peter Eisentra)
2006-01-16 <ishii@sraoss.co.jp>
* version 2.7.1
* Fix bug in show pool_status for ignore_leading_white_space
2006-01-03 <ishii@sraoss.co.jp>
* version 2.7
* add child_max_connections. contributed by Pomarede Nicolas with
minor changes by Tatsuo
* add ignore_leading_white_space
* fix problem with copy on V2 protocol
* fix master/slave handling
* fix extended query
2005-11-11 <ishii@sraoss.co.jp>
* version 2.6.5
* fix bug introduced in v2.6.4. V2 protocol/trust auth/first time
connection causes error on connection.
* fix problem with DROP DATABASE. if pgpool has connected to the
database which is about to dropped, the command fails.
2005-10-22 <ishii@sraoss.co.jp>
* version 2.6.4
* fix connection error when client_min_message is verbose
* resync pool_config.c with pool_config.l
2005-09-02 <t-ishii@sra.co.jp>
* version 2.6.3
* if invalid non-switch args are given (for example, pgpool -f
pgpool.conf foobar), pgpool silently deleted pgpool.pid even if
it's a valid one. Per report from Brad Nicholson.
* fix show pool_status command bug. Sometimes secondary host is
showed "unused" even it is actually used.
* fix bug in health_check(). It made wrong reports if secondary
goes down. Per report from Bunji Nagahasi.
2005-07-30 <t-ishii@sra.co.jp>
* version 2.6.2
* fix file descriptor leak bug
2005-07-18 <t-ishii@sra.co.jp>
* version 2.6.1
* set non blocking to sockets for frontend.
* remove stdio usage from pool_write/pool_flush. Stdio libs have
fundanmental problems with non blocking sockets
* do not raise failover when read() read encounters EOF. It seems it
is a oversight. Backend crush may cause that but it does not
immediately mean postmaster crush
* retries with EINTR or EAGAIN in pool_stream modules
2005-06-25 <t-ishii@sra.co.jp>
* version 2.6
* fix memory leak in pool_error()
* allow replication between servers which have different time zone
etc.
* fix bug in pgpool -m f stop if pgpool stop has already issued
but pgpool cannot stop.
* add new "insert_lock" directive which automatically insert table
locks to allow SERIAL data type replication
* allow new "/*NO STRICT*/ comment to turn off the strict mode
temporary
* add a row to pool_staus to display server status
2005-03-12 <t-ishii@sra.co.jp>
* version 2.5.2
* fix bug in health checking
* strict mode is applied to non SELECT query only
* add -D_GNU_SOURCE to CPP flag
2005-02-20 <t-ishii@sra.co.jp>
* version 2.5.1
* fix bug in heal checking
- sometimes health checking period drifts
- if health checking is intrrupted by SIGCHILD (this could
happen, for exmaple, if child_life_time expires), unwanted
failover happens
* accept fast/immediate shutdown request while blocking in smart
shutdown
* use asprintf to avoid log output confusion (thanks to Jacques Caron)
* use sttok rather than strsep
* emit log when starting up
* make some logs from log level to debug level
2005-02-02 <t-ishii@sra.co.jp>
* version 2.5
* add health checking
* add switch over
* add following to pgpool.conf
- print_time_stamp
- master_slave_mode
- connection_cache
- health_check_timeout
- health_check_period
- health_check_user
2005-01-05 <t-ishii@sra.co.jp>
* version 2.4
* add reset_query_list so that SQL commands to be issued at the
end of sessions configurable
* update copyright years
2004-12-14 <t-ishii@sra.co.jp>
* version 2.3.3
* make signal handling more portable
* add health check when kind does match between master and secondary
2004-12-08 <t-ishii@sra.co.jp>
* version 2.3.2
* fix bug in degeneration when session is continued
2004-11-12 <t-ishii@sra.co.jp>
* version 2.3.1
* fix bug after degeneration
* fix bug in child expires its life time
* fix bug when envoked with -n and sent kill signal
2004-11-05 <t-ishii@sra.co.jp>
* version 2.3
* fix memory leak in handling startup packets
* implement child_life_time
* add -m option to pgpool stop mode to terminate pgpool in safe manner
2004-10-28 <t-ishii@sra.co.jp>
* version 2.2.1
* restart child process if one of them detects backend errors in
single/connection pool mode. This will avoid annoying errors in
case of postmaster restarting.
* fix bug in setting select()'s timeout parameter
* fix enbug in 2.2
* fix mishandling select()'s timeout parameters in emitting ERROR
when select() fails
* fix comments in pgpool.conf.sample
2004-09-30 <t-ishii@sra.co.jp>
* version 2.2
* fix unexpected block when master or secondary receives shutdown request
* allow listen address and add new listen_address
directive. contributed by Peter Eisentraut
2004-09-13 <t-ishii@sra.co.jp>
* version 2.1
* new conf param weight_master and weight_secondary
* use recent version of autoconf and automake
2004-09-02 <t-ishii@sra.co.jp>
* version 2.0.9
* use non block read() to be more reliable on heavy load
* fix compilar warning on Solaris
2004-08-18 <t-ishii@sra.co.jp>
* version 2.0.8
* fix segfault when connection pool timer expires (Thanks matsuu!)
2004-08-13 <t-ishii@sra.co.jp>
* version 2.0.7
* fix compiler warning on PPC architecutre (thanks Peter!)
* no need flex anymore while building pgpool
(workaround is fix configure by hand. this is due to
AM_PROG_LEX macro bug).
* fix compiler warning and segfault on FreeBSD 5.2.1+AMD64 (thanks Martin!)
* fix sigint handler in child
2004-07-22 <t-ishii@sra.co.jp>
* version 2.0.6
* workaorund with buggy 6.5's libpq
* fix enbug in 2.0.5(pool_read -> pool_read2)
2004-07-19 <t-ishii@sra.co.jp>
* version 2.0.5
* do not check NULLMAP when no replication mode
* fix lots of compiler warnings
* change pool_read to pool_read2
* consider the case NULLMAP is different among master and
secondary in BinaryRow
2004-07-17 <t-ishii@sra.co.jp>
* version 2.0.4
* accept more connections than max_pool
* consider the case NULLMAP is different among master and secondary
2004-07-12 <t-ishii@sra.co.jp>
* version 2.0.3
* fix segfault when connection is reused (enbug in 2.0.2)
* fix wording in pgpool.conf.sample
* fix flat file password authentication on V3 and relication is true
2004-07-04 <t-ishii@sra.co.jp>
* version 2.0.2
* enhance error handling when frontend or backend failed
* change "log" -> "LOG" in pool_log()
2004-07-01 <t-ishii@sra.co.jp>
* version 2.0.1
* fix bug when backend_host_name is ''
* relax message length check in SimpleForwardToFrontend so that it
allows rows order is physically different
2004-06-22 <t-ishii@sra.co.jp>
* version 2.0
* add load balancing capability
* prevent unwanted degeneration (V1.2 behavior can be possible
using replication_stop_on_mismatch directive)
2004-05-16 <t-ishii@sra.co.jp>
* version 1.2.3
* fix bug in FunctionCall in replication mode
2004-05-11 <t-ishii@sra.co.jp>
* version 1.2.2
* fix slowness when client is connected to pgpool via TCP
2004-05-08 <t-ishii@sra.co.jp>
* version 1.2.1
* fix a bug when pool_read_string() reads large string
* remove unnecessary pool_write_and_flush() from AsciiRow() and BinaryRow()
2004-05-06 <t-ishii@sra.co.jp>
* version 1.2
* fix a bug introduced by v1.1 which close listen fds accidently
* prevent buffer overflow by checking password string length
* do authentication even when connected by pooled connection
* send an end packet("X") before closing a connection to backend
2004-04-28 <t-ishii@sra.co.jp>
* version 1.1
* fix segfault when connection pool timer is expired
* support clear text password, crypt, md5 authentication method. note that in
repication mode, only clear text password authenticaton is supported.
2004-04-23 <t-ishii@sra.co.jp>
* pgpool 1.0 released
|