pgpool1.git
18 years agoShow status via ps command like PostgreSQL
Tatsuo Ishii [Thu, 1 Feb 2007 13:33:26 +0000 (13:33 +0000)]
Show status via ps command like PostgreSQL
(ps_status.c and strlcpy.c are stolen from PostgreSQL)

18 years agoFixed SIGSEGV using DBD-Pg.
Yoshiyuki Asaba [Mon, 22 Jan 2007 11:36:51 +0000 (11:36 +0000)]
Fixed SIGSEGV using DBD-Pg.
Reported by Kenichi Sawada.

18 years agoFix auto-deallocation. If a client used PDO or DBD-pg interface,
Yoshiyuki Asaba [Sat, 13 Jan 2007 11:13:38 +0000 (11:13 +0000)]
Fix auto-deallocation. If a client used PDO or DBD-pg interface,
pgpool didn't clean prepared statement.

18 years agoUpdate copyright
Devrim GÜNDÜZ [Thu, 4 Jan 2007 17:01:36 +0000 (17:01 +0000)]
Update copyright

18 years agofixed a mistype in the define macro.
User yamaguti [Sun, 17 Dec 2006 11:20:22 +0000 (11:20 +0000)]
fixed a mistype in the define macro.

18 years agoFix typo
Devrim GÜNDÜZ [Wed, 13 Dec 2006 09:16:11 +0000 (09:16 +0000)]
Fix typo

18 years agoAdd cvs tag command. V3_1_2
Yoshiyuki Asaba [Mon, 11 Dec 2006 04:13:06 +0000 (04:13 +0000)]
Add cvs tag command.

18 years agoVersion 3.1.2
Yoshiyuki Asaba [Mon, 11 Dec 2006 04:06:43 +0000 (04:06 +0000)]
Version 3.1.2

18 years agoChange release date.
Yoshiyuki Asaba [Mon, 11 Dec 2006 04:05:30 +0000 (04:05 +0000)]
Change release date.

18 years agoOoops, fix version
Devrim GÜNDÜZ [Tue, 5 Dec 2006 13:05:58 +0000 (13:05 +0000)]
Ooops, fix version

18 years agoBetter fix for conf file problem, per bugzilla review
Devrim GÜNDÜZ [Tue, 5 Dec 2006 13:05:24 +0000 (13:05 +0000)]
Better fix for conf file problem, per bugzilla review

18 years agoVersion 3.1.2.
Yoshiyuki Asaba [Tue, 5 Dec 2006 07:12:35 +0000 (07:12 +0000)]
Version 3.1.2.

18 years agoUpdate to 3.1.2
Devrim GÜNDÜZ [Tue, 5 Dec 2006 05:10:20 +0000 (05:10 +0000)]
Update to 3.1.2

18 years agoFixed segmentation fault when a Parse message was failed.
Yoshiyuki Asaba [Fri, 1 Dec 2006 06:50:26 +0000 (06:50 +0000)]
Fixed segmentation fault when a Parse message was failed.

18 years agoRelease procedure document (Japanese)
Tatsuo Ishii [Fri, 1 Dec 2006 06:44:59 +0000 (06:44 +0000)]
Release procedure document (Japanese)

18 years agoupdate items implemented in pgpool-II
Tatsuo Ishii [Fri, 1 Dec 2006 06:26:44 +0000 (06:26 +0000)]
update items implemented in pgpool-II

18 years agoversion 3.1.2
Tatsuo Ishii [Fri, 1 Dec 2006 06:18:56 +0000 (06:18 +0000)]
version 3.1.2

18 years agoUpdates to spec, per bugzilla review.
Devrim GÜNDÜZ [Sun, 26 Nov 2006 17:58:43 +0000 (17:58 +0000)]
Updates to spec, per bugzilla review.

18 years agoRemove a restriction of an extended query protocol.
Yoshiyuki Asaba [Tue, 10 Oct 2006 04:34:32 +0000 (04:34 +0000)]
Remove a restriction of an extended query protocol.

18 years agoLoad balancing an extended query protocol.
Yoshiyuki Asaba [Tue, 10 Oct 2006 04:31:18 +0000 (04:31 +0000)]
Load balancing an extended query protocol.

18 years agoAdd pam authentication in supported authentication protocol list.
Yoshiyuki Asaba [Mon, 25 Sep 2006 02:50:43 +0000 (02:50 +0000)]
Add pam authentication in supported authentication protocol list.
Reported by Jeff Davis.

19 years agoFix kind mismatch error in COPY FROM STDIN.
Yoshiyuki Asaba [Wed, 13 Sep 2006 10:13:20 +0000 (10:13 +0000)]
Fix kind mismatch error in COPY FROM STDIN.

19 years agoRemove dependency for postgresql-server.
Devrim GÜNDÜZ [Fri, 8 Sep 2006 08:58:59 +0000 (08:58 +0000)]
Remove dependency for postgresql-server.

19 years agoImprove error message when a connection is rejected by postmaster with
Tatsuo Ishii [Wed, 30 Aug 2006 01:11:48 +0000 (01:11 +0000)]
Improve error message when a connection is rejected by postmaster with
no pg_hba.conf entries. Patches contributed by Kenji Kikuchi.
See [Pgpool-general] Small change for v3 formatted ErrorResponce
handling. on 2006/8/26 for more details.

19 years agoFix typos
Devrim GÜNDÜZ [Sun, 13 Aug 2006 22:36:06 +0000 (22:36 +0000)]
Fix typos

19 years agoallow 0 weight
Tatsuo Ishii [Wed, 2 Aug 2006 08:27:29 +0000 (08:27 +0000)]
allow 0 weight

19 years agoFix pool_close() to avoid free() not allocated
Tatsuo Ishii [Wed, 2 Aug 2006 08:00:56 +0000 (08:00 +0000)]
Fix pool_close() to avoid free() not allocated
memory. pool_discard_params() should be called only when
this is the backend connection.

19 years ago- Fixed spec file, per bugzilla review (#199679)
Devrim GÜNDÜZ [Mon, 31 Jul 2006 12:16:36 +0000 (12:16 +0000)]
- Fixed spec file, per bugzilla review (#199679)

19 years ago- Fixed bogus char :(
Devrim GÜNDÜZ [Sun, 23 Jul 2006 14:01:03 +0000 (14:01 +0000)]
- Fixed bogus char :(

19 years ago- Fixed spec file, per bugzilla review (#199679)
Devrim GÜNDÜZ [Sun, 23 Jul 2006 13:51:36 +0000 (13:51 +0000)]
- Fixed spec file, per bugzilla review (#199679)

19 years agoUpdated version numbers
Devrim GÜNDÜZ [Sun, 23 Jul 2006 13:50:22 +0000 (13:50 +0000)]
Updated version numbers

19 years ago- Fixed spec file, per bugzilla review (#199679)
Devrim GÜNDÜZ [Sun, 23 Jul 2006 12:42:38 +0000 (12:42 +0000)]
- Fixed spec file, per bugzilla review (#199679)
- Update to 3.1.1

19 years agoVersion 3.1.1 V3_1_1
Tatsuo Ishii [Sun, 23 Jul 2006 11:41:51 +0000 (11:41 +0000)]
Version 3.1.1

19 years agoFix problem NOTIFY messages does arrive client.
Tatsuo Ishii [Fri, 21 Jul 2006 04:25:42 +0000 (04:25 +0000)]
Fix problem NOTIFY messages does arrive client.
Modify SimpleForwardToFrontend so that flush the client stream
immediatly if the packet kind is 'A' (notification response)
Per report from Michael Ulitskiy.
See

[Pgpool-general] Problem with LISTEN/NOTIFY through pgpool again
Date: Thu, 20 Jul 2006 14:13:09 -0400

for more problem details.

19 years agoAdd mail address V3_1
Tatsuo Ishii [Sat, 1 Jul 2006 11:49:00 +0000 (11:49 +0000)]
Add mail address

19 years agoFix release date
Tatsuo Ishii [Sat, 1 Jul 2006 11:48:08 +0000 (11:48 +0000)]
Fix release date

19 years agoAdd configure (accidently removed)
Tatsuo Ishii [Sat, 1 Jul 2006 11:45:26 +0000 (11:45 +0000)]
Add configure (accidently removed)

19 years agoV3.1
Tatsuo Ishii [Sat, 1 Jul 2006 11:44:09 +0000 (11:44 +0000)]
V3.1

19 years agoVersion 3.1
Tatsuo Ishii [Sat, 1 Jul 2006 11:22:34 +0000 (11:22 +0000)]
Version 3.1

19 years agoFix segfault problem in race conditions among connection_life_time,
Tatsuo Ishii [Mon, 26 Jun 2006 08:25:17 +0000 (08:25 +0000)]
Fix segfault problem in race conditions among connection_life_time,
child_life_time and child_max_connections.

19 years agoFix deadlock problem with extend query.
Yoshiyuki Asaba [Thu, 22 Jun 2006 08:17:16 +0000 (08:17 +0000)]
Fix deadlock problem with extend query.
Call synchronize() in Execute() if replication_strict is true.

19 years agoAdd comment
Tatsuo Ishii [Thu, 22 Jun 2006 06:34:21 +0000 (06:34 +0000)]
Add comment

19 years agoIn SimpleForwardToFrontend() do not send SYNC and wait for ready for
Tatsuo Ishii [Thu, 22 Jun 2006 05:04:31 +0000 (05:04 +0000)]
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.

19 years agoAdd log_statement option. patches contributed by Thomas E
Tatsuo Ishii [Sun, 4 Jun 2006 10:03:30 +0000 (10:03 +0000)]
Add log_statement option. patches contributed by Thomas E
 Lackey, modifications and documents by Tatsuo

19 years agoImprove documentation. patches contributed by Mark Stosberg .
Tatsuo Ishii [Tue, 30 May 2006 14:21:19 +0000 (14:21 +0000)]
Improve documentation. patches contributed by Mark Stosberg .

19 years agoFixes "kind is 0!" error in Execute().
Yoshiyuki Asaba [Mon, 22 May 2006 07:11:49 +0000 (07:11 +0000)]
Fixes "kind is 0!" error in Execute().

Reads messages until receiving CommandComplete, EmptyQuery,
ErrorResponse or PortalSuspend in Execute().

19 years agoversion 3.0.2 V3_0_2
Tatsuo Ishii [Wed, 17 May 2006 05:28:00 +0000 (05:28 +0000)]
version 3.0.2

19 years agoremove restrictions regarding prepared query.
Tatsuo Ishii [Wed, 17 May 2006 04:41:03 +0000 (04:41 +0000)]
remove restrictions regarding prepared query.
users now do not need to issue DEALLOCATE when exits

19 years agoIf configuration contents is wrong, pgpool should exit, but actually not...
Tatsuo Ishii [Fri, 12 May 2006 03:46:15 +0000 (03:46 +0000)]
If configuration contents is wrong, pgpool should exit, but actually not...

19 years agoFix buffer over-run in health_check().
Yoshiyuki Asaba [Thu, 11 May 2006 03:00:07 +0000 (03:00 +0000)]
Fix buffer over-run in health_check().

If helth_check_user length is greater than 32 byte, buffer over-run
was caused by strcpy(). It uses strncpy() instead of strcpy().

Patch contributed by Taiki Yamaguchi.

19 years agoFix miss use of pool_init_params in new_connection().
Tatsuo Ishii [Thu, 11 May 2006 02:15:55 +0000 (02:15 +0000)]
Fix miss use of pool_init_params in new_connection().
pool_init_params(&MASTER(p)->params) should be
pool_init_params(&SECONDARY(p)->params)

19 years agopool_send_error_message() didn't create null-terminated packet.
Yoshiyuki Asaba [Wed, 10 May 2006 10:15:17 +0000 (10:15 +0000)]
pool_send_error_message() didn't create null-terminated packet.
So, JDBC Driver raised ArrayIndexOutOfBoundsException.

Fix this problem.

19 years agoFix kind mismatch error in SimpleForwardToFrontend().
Yoshiyuki Asaba [Wed, 10 May 2006 04:48:57 +0000 (04:48 +0000)]
Fix kind mismatch error in SimpleForwardToFrontend().

19 years agoUsing BSD make, build process never finished.
Yoshiyuki Asaba [Sat, 6 May 2006 12:48:05 +0000 (12:48 +0000)]
Using BSD make, build process never finished.
BSD make can only use "$<" in an implicit rule. But '$<' is used in
the explicit rule.

pgpool.8: pgpool.8.in
        sed 's,@sysconfdir\@,$(sysconfdir),g' $< >$@

BSD make transforms '$<' to empty string in an explicit rule. So, it
uses '$?' instead of '$<'.

19 years agoAdd POOL_SETMASK2 macro. POOL_SETMASK2 returns previous signal mask.
Yoshiyuki Asaba [Fri, 28 Apr 2006 07:37:39 +0000 (07:37 +0000)]
Add POOL_SETMASK2 macro. POOL_SETMASK2 returns previous signal mask.

Error report functions(pool_error() etc.) save current signal mask and
set new signal mask(BlockSig). Then restore the signal mask before
returning.

19 years agoFix bug in del_prepared_list().
Yoshiyuki Asaba [Fri, 28 Apr 2006 07:08:01 +0000 (07:08 +0000)]
Fix bug in del_prepared_list().
Pgpool dumped core file when clients sends Close command.

19 years agoFix bug in SimpleForwardToBackend().
Tatsuo Ishii [Sat, 22 Apr 2006 12:14:56 +0000 (12:14 +0000)]
Fix bug in SimpleForwardToBackend().
consider following case:

> Describe(for 'S')
< ParameterDescription
< RowDescription or NoData

> Describe(for 'P')
< RowDescription or Nodata

19 years agoSend Flush('H') message to backends in SimpleForwardToBackend() when
Yoshiyuki Asaba [Tue, 18 Apr 2006 10:28:28 +0000 (10:28 +0000)]
Send Flush('H') message to backends in SimpleForwardToBackend() when
client sends Close('C') message.

19 years agoFix handling of ErrorResponse('E') messages in SimpleForwardToFrontend().
Yoshiyuki Asaba [Mon, 17 Apr 2006 08:37:50 +0000 (08:37 +0000)]
Fix handling of ErrorResponse('E') messages in SimpleForwardToFrontend().

19 years agoAdd some comments
Tatsuo Ishii [Mon, 17 Apr 2006 08:28:25 +0000 (08:28 +0000)]
Add some comments

19 years agoAdd signal blocking. signal handlers may call pool_error() etc.
Tatsuo Ishii [Mon, 17 Apr 2006 04:07:09 +0000 (04:07 +0000)]
Add signal blocking. signal handlers may call pool_error() etc.
while processing. This is not good for them. For example,
messages might be confused.

19 years agoAdd comment for 3.0.2
Tatsuo Ishii [Mon, 17 Apr 2006 04:05:40 +0000 (04:05 +0000)]
Add comment for 3.0.2

19 years agoFix bugs in extend mode
Tatsuo Ishii [Mon, 17 Apr 2006 04:05:09 +0000 (04:05 +0000)]
Fix bugs in extend mode

19 years agoFix typo.
Tatsuo Ishii [Mon, 17 Apr 2006 04:03:03 +0000 (04:03 +0000)]
Fix typo.

19 years agoModify pool_send_auth_ok so that it reports backend process id.
Tatsuo Ishii [Mon, 17 Apr 2006 03:59:25 +0000 (03:59 +0000)]
Modify pool_send_auth_ok so that it reports backend process id.
This will help debugging pgpool.

19 years agoAutomatically DEALLOCATE prepared statememt when client disconnects.
Tatsuo Ishii [Fri, 31 Mar 2006 02:13:21 +0000 (02:13 +0000)]
Automatically DEALLOCATE prepared statememt when client disconnects.
Patch contributed by Yoshiyuki Asaba.

19 years agoCheck startup packet is identical before reusing existing connection.
Tatsuo Ishii [Sat, 25 Mar 2006 08:43:52 +0000 (08:43 +0000)]
Check startup packet is identical before reusing existing connection.
even if user/database/major are same, OPTION and other data might be
different. One of such an example is, psql/JDBC 8.1 connects one and
another.

19 years agoFix SimpleForwardToFrontend() and SimpleForwardToBackend(). If
Tatsuo Ishii [Sat, 25 Mar 2006 08:15:30 +0000 (08:15 +0000)]
Fix SimpleForwardToFrontend() and SimpleForwardToBackend(). If
the packet length is 0 then do not forward the packet.

Fix pool_process_query(). If kind/kind1 from backends exists *and*
data coming from frontend, kind/kind1 will be lost.

19 years agoFix more double free bug.
Tatsuo Ishii [Sat, 25 Mar 2006 08:03:00 +0000 (08:03 +0000)]
Fix more double free bug.

19 years agoFix double free bug in the previous commit
Tatsuo Ishii [Fri, 24 Mar 2006 12:37:24 +0000 (12:37 +0000)]
Fix double free bug in the previous commit

19 years agoFix bug in do_child(). We should not reuse startup packet since some
Tatsuo Ishii [Thu, 23 Mar 2006 12:38:36 +0000 (12:38 +0000)]
Fix bug in do_child(). We should not reuse startup packet since some
values in the packet such as client_encoding might be changed.

19 years agoFix bug with insert_lock in following cases:
Tatsuo Ishii [Sun, 26 Feb 2006 10:36:53 +0000 (10:36 +0000)]
Fix bug with insert_lock in following cases:
- INSERT statement with multiple lines
- erroneous INSERT statement

19 years agoFix spelling. contributed by Peter Eisentraut
Tatsuo Ishii [Sat, 18 Feb 2006 13:13:37 +0000 (13:13 +0000)]
Fix spelling. contributed by Peter Eisentraut

19 years agoFix bug with call to select(2)
Tatsuo Ishii [Thu, 16 Feb 2006 14:32:01 +0000 (14:32 +0000)]
Fix bug with call to select(2)

19 years agoVersion 3.0.1 V3_0_1
Tatsuo Ishii [Tue, 14 Feb 2006 08:24:10 +0000 (08:24 +0000)]
Version 3.0.1

19 years agoFix master/slave mode breakage in 2.7.2
Tatsuo Ishii [Tue, 14 Feb 2006 08:19:06 +0000 (08:19 +0000)]
Fix master/slave mode breakage in 2.7.2

Fix bug with master/slave mode and prepared query

19 years agoinclude pgpool.spec and re-release 3.0.0 V3_0_0
Tatsuo Ishii [Sun, 5 Feb 2006 02:54:48 +0000 (02:54 +0000)]
include pgpool.spec and re-release 3.0.0

19 years agoversion 3.0
Tatsuo Ishii [Sun, 5 Feb 2006 02:29:09 +0000 (02:29 +0000)]
version 3.0

19 years ago * Version 3.0.0
Devrim GÜNDÜZ [Sun, 5 Feb 2006 01:59:27 +0000 (01:59 +0000)]
    * Version 3.0.0
        * Change copyright to PgPool Global Development Group
        * Fix a typo in man page

19 years agoOpps, commit the right spec file
Devrim GÜNDÜZ [Fri, 3 Feb 2006 02:02:33 +0000 (02:02 +0000)]
Opps, commit the right spec file

19 years ago2.7.2 Spec file
Devrim GÜNDÜZ [Fri, 3 Feb 2006 01:59:17 +0000 (01:59 +0000)]
2.7.2 Spec file

19 years agoFix wording, per Peter.
User madness [Thu, 2 Feb 2006 21:34:29 +0000 (21:34 +0000)]
Fix wording, per Peter.

19 years agopgpool 2.7.2 V2_7_2
Tatsuo Ishii [Thu, 2 Feb 2006 08:43:34 +0000 (08:43 +0000)]
pgpool 2.7.2

19 years agoAdd pgpool's man page. contributed by Peter Eisentra.
Tatsuo Ishii [Fri, 27 Jan 2006 23:42:38 +0000 (23:42 +0000)]
Add pgpool's man page. contributed by Peter Eisentra.

19 years agoFix but master/slave mode and LISTEN/NOTIFY
Tatsuo Ishii [Wed, 25 Jan 2006 12:29:58 +0000 (12:29 +0000)]
Fix but master/slave mode and LISTEN/NOTIFY

19 years agoVersion 2.7.1 V2_7_1
Tatsuo Ishii [Mon, 16 Jan 2006 05:19:12 +0000 (05:19 +0000)]
Version 2.7.1

19 years agoFix version info.
Tatsuo Ishii [Mon, 16 Jan 2006 05:11:03 +0000 (05:11 +0000)]
Fix version info.

19 years agoFix typo in docs
Tatsuo Ishii [Thu, 12 Jan 2006 00:16:31 +0000 (00:16 +0000)]
Fix typo in docs

19 years agoFix pool_status to show correct value for ignore_leading_whitespace
Tatsuo Ishii [Thu, 5 Jan 2006 13:08:44 +0000 (13:08 +0000)]
Fix pool_status to show correct value for ignore_leading_whitespace

19 years agoversion 2.7 V2_7
Tatsuo Ishii [Tue, 3 Jan 2006 03:33:10 +0000 (03:33 +0000)]
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

19 years agoAdd PostgreSQL 8.1 as a working PostgreSQL version
Tatsuo Ishii [Mon, 21 Nov 2005 10:07:09 +0000 (10:07 +0000)]
Add PostgreSQL 8.1 as a working PostgreSQL version

19 years agoversion 2.6.5 V2_6_5
Tatsuo Ishii [Fri, 11 Nov 2005 11:59:28 +0000 (11:59 +0000)]
version 2.6.5

19 years agoFix bug introduced in v2.6.4.
Tatsuo Ishii [Fri, 11 Nov 2005 11:51:04 +0000 (11:51 +0000)]
Fix bug introduced in v2.6.4.
V2 protocol/trust auth/first time connection causes error on
connection.

19 years agoexperimental support for DROP DATABASE problem
Tatsuo Ishii [Wed, 9 Nov 2005 14:12:21 +0000 (14:12 +0000)]
experimental support for DROP DATABASE problem
fix smart shutdown case handling. missing "break;" statement cause
unconditionaly exit().

19 years agoAdd notes to run multiple instances of pgpool on the same server
Tatsuo Ishii [Sun, 23 Oct 2005 12:27:55 +0000 (12:27 +0000)]
Add notes to run multiple instances of pgpool on the same server
simultaneously. Contributed by Thomas F. O'Connell.
Japanese translation by Tatsuo Ishii.

19 years agoversion 2.6.4 V2_6_4
Tatsuo Ishii [Sat, 22 Oct 2005 12:59:46 +0000 (12:59 +0000)]
version 2.6.4

19 years agoFix connection error when client_min_message is verbose (V2 case)
Tatsuo Ishii [Sat, 22 Oct 2005 12:57:57 +0000 (12:57 +0000)]
Fix connection error when client_min_message is verbose (V2 case)

19 years agoFix error message typo
Tatsuo Ishii [Wed, 19 Oct 2005 03:58:48 +0000 (03:58 +0000)]
Fix error message typo

pool_auth fails if client_min_messages is verbose. pool_auth should
processes NOTICE etc. while waiting for backendkeydata

19 years agoSync with pool_config.l
Tatsuo Ishii [Wed, 19 Oct 2005 03:56:31 +0000 (03:56 +0000)]
Sync with pool_config.l

20 years agoVersion 2.6.3 V2_6_3
Tatsuo Ishii [Fri, 2 Sep 2005 14:32:34 +0000 (14:32 +0000)]
Version 2.6.3