]> granicus.if.org Git - pgbouncer/log
pgbouncer
13 years agov1.4-0rc1.1
Marko Kreen [Wed, 17 Nov 2010 12:10:52 +0000 (14:10 +0200)]
v1.4-0rc1.1

13 years agoSync syslog handling with libusual
Marko Kreen [Wed, 17 Nov 2010 12:00:42 +0000 (14:00 +0200)]
Sync syslog handling with libusual

13 years agoFix web upload, remove old wiki refs
Marko Kreen [Wed, 10 Nov 2010 14:52:50 +0000 (16:52 +0200)]
Fix web upload, remove old wiki refs

13 years agoFix JDBC vs transaction pooling FAQ
Marko Kreen [Wed, 10 Nov 2010 14:51:36 +0000 (16:51 +0200)]
Fix JDBC vs transaction pooling FAQ

13 years agov1.4rc1
Marko Kreen [Mon, 8 Nov 2010 09:04:03 +0000 (11:04 +0200)]
v1.4rc1

13 years agodns: fix failed lookup reporting.
Marko Kreen [Mon, 8 Nov 2010 08:59:09 +0000 (10:59 +0200)]
dns: fix failed lookup reporting.

13 years agov1.4rc0
Marko Kreen [Wed, 3 Nov 2010 13:40:42 +0000 (15:40 +0200)]
v1.4rc0

13 years agoDisplay warning when activating reserve_pool
Marko Kreen [Tue, 2 Nov 2010 14:11:30 +0000 (16:11 +0200)]
Display warning when activating reserve_pool

13 years agodnslookup: minor cleanups
Marko Kreen [Tue, 2 Nov 2010 14:10:43 +0000 (16:10 +0200)]
dnslookup: minor cleanups

13 years agodns reorg: use struct addrinfo as main storage unit
Marko Kreen [Wed, 13 Oct 2010 15:38:14 +0000 (18:38 +0300)]
dns reorg: use struct addrinfo as main storage unit

13 years agoquickly list of connect string params
Marko Kreen [Wed, 13 Oct 2010 15:36:34 +0000 (18:36 +0300)]
quickly list of connect string params

13 years agodoc: seems like recent asciidoc/docbook does not need manual fixing
Marko Kreen [Wed, 13 Oct 2010 15:35:34 +0000 (18:35 +0300)]
doc: seems like recent asciidoc/docbook does not need manual fixing

13 years agodnslookup - forgot to strdup host name
Marko Kreen [Tue, 12 Oct 2010 07:29:24 +0000 (10:29 +0300)]
dnslookup - forgot to strdup host name

the original host name will be freed during reload.

also remove unnecessary list_del(), as list_pop() is used above.

13 years agoMore compact libusual distro
Marko Kreen [Sat, 9 Oct 2010 07:15:42 +0000 (10:15 +0300)]
More compact libusual distro

13 years agoclient_login_timeout: check wait_for_welcome
Marko Kreen [Thu, 7 Oct 2010 10:30:47 +0000 (13:30 +0300)]
client_login_timeout: check wait_for_welcome

When rebooting, then pool->welcome_msg_ready=0 does not mean
that ->waiting_client_list will contain only new connections.

13 years agoMove 'new connection' message to connect_server()
Marko Kreen [Thu, 7 Oct 2010 09:01:34 +0000 (12:01 +0300)]
Move 'new connection' message to connect_server()

The actual address is not known before, thus log message
was 0.0.0.0.  Now it logs actual address.

14 years agoDon't disable getaddrinfo_a()...
Marko Kreen [Thu, 30 Sep 2010 04:28:18 +0000 (21:28 -0700)]
Don't disable getaddrinfo_a()...

14 years agozip generation for win32
Marko Kreen [Wed, 29 Sep 2010 21:47:32 +0000 (14:47 -0700)]
zip generation for win32

14 years agoAvoid fatal() in tune_socket()
Marko Kreen [Wed, 29 Sep 2010 16:41:20 +0000 (09:41 -0700)]
Avoid fatal() in tune_socket()

This allows to survive broken fds send during reboot from old pooler.

14 years agoUse PRIu64 instead of llu as it seems not portable enough
Marko Kreen [Wed, 29 Sep 2010 16:40:10 +0000 (09:40 -0700)]
Use PRIu64 instead of llu as it seems not portable enough

14 years agoconnect_server: store port in host order
Marko Kreen [Wed, 29 Sep 2010 16:37:36 +0000 (09:37 -0700)]
connect_server: store port in host order

14 years agorefresh libusual
Marko Kreen [Tue, 28 Sep 2010 19:09:38 +0000 (12:09 -0700)]
refresh libusual

14 years agoAnother try at async DNS - getaddrinfo_a()
Marko Kreen [Tue, 28 Sep 2010 18:05:20 +0000 (11:05 -0700)]
Another try at async DNS - getaddrinfo_a()

The libevent's evdns seems not ready for serious use:

- proper random req id is available only in 2.0.x
- it does not use random source port for different reqs
- it does not check if req id conflicts with another one

14 years agoMantion pgbouncer and libevent version on startup
Marko Kreen [Fri, 24 Sep 2010 16:05:20 +0000 (09:05 -0700)]
Mantion pgbouncer and libevent version on startup

14 years agodeb: create -dbg exe with less optimizations
Marko Kreen [Tue, 21 Sep 2010 23:18:05 +0000 (16:18 -0700)]
deb: create -dbg exe with less optimizations

14 years agoAdd Guillaume to contributors
Marko Kreen [Tue, 21 Sep 2010 23:17:40 +0000 (16:17 -0700)]
Add Guillaume to contributors

14 years agoBetter param comparision in case of missing params
Marko Kreen [Tue, 21 Sep 2010 13:16:48 +0000 (06:16 -0700)]
Better param comparision in case of missing params

14 years agoFix broken check for emtpy param value.
Marko Kreen [Tue, 21 Sep 2010 12:56:21 +0000 (05:56 -0700)]
Fix broken check for emtpy param value.

14 years agoPackaging update
Marko Kreen [Mon, 20 Sep 2010 20:37:50 +0000 (13:37 -0700)]
Packaging update

install 2 binaries:
 - pgbouncer     - without asserts
 - pgbouncer-dbg - with asserts

bump ver to 1.4 alpha

14 years agoRefresh libusual
Marko Kreen [Wed, 15 Sep 2010 13:14:40 +0000 (16:14 +0300)]
Refresh libusual

14 years agodns_connect: remove double salen
Marko Kreen [Wed, 15 Sep 2010 13:12:54 +0000 (16:12 +0300)]
dns_connect: remove double salen

14 years agoSome doc updates.
Marko Kreen [Sat, 11 Sep 2010 09:23:23 +0000 (12:23 +0300)]
Some doc updates.

14 years agoDowngrade dns log messages.
Marko Kreen [Sat, 11 Sep 2010 09:18:12 +0000 (12:18 +0300)]
Downgrade dns log messages.

14 years agoAsync DNS lookup support via libevent DNS module.
Marko Kreen [Fri, 10 Sep 2010 08:34:38 +0000 (11:34 +0300)]
Async DNS lookup support via libevent DNS module.

With libevent 1.x we use evdns_base_resolve_ipv4() API,
which does not use /etc/hosts, but returns TTL.

With libevent 2.x we use evdns_getaddrinfo() API, which uses /etc/hosts
but does not return TTL.

As we need to have our own TTL handling anyway, the TTL is ignored
on libevent 1.x too, to be consistent.

New config variable 'dns_max_ttl', which sets time how long result
can be reused.

14 years agoDraft tgz generation.
Marko Kreen [Fri, 10 Sep 2010 10:54:35 +0000 (13:54 +0300)]
Draft tgz generation.

14 years agodraft notes for 1.4
Marko Kreen [Fri, 10 Sep 2010 09:55:54 +0000 (12:55 +0300)]
draft notes for 1.4

14 years agorefresh libusual
Marko Kreen [Fri, 10 Sep 2010 09:54:39 +0000 (12:54 +0300)]
refresh libusual

14 years agodoc/config.txt: Fix minor typo.
Marko Kreen [Thu, 9 Sep 2010 11:40:50 +0000 (11:40 +0000)]
doc/config.txt: Fix minor typo.

Reported by Peter Eisentraut

14 years agoFix the quoting fix.
Marko Kreen [Thu, 9 Sep 2010 11:10:31 +0000 (11:10 +0000)]
Fix the quoting fix.

If we treat "" as special, we need to know
whether we are in quoted string or not.

Otherwise empty field ("") throws the parser off.

14 years agoUse pg_quote_literal from libusual.
Marko Kreen [Wed, 8 Sep 2010 17:11:03 +0000 (20:11 +0300)]
Use pg_quote_literal from libusual.

14 years agowin32: remove code that is moved to libusual
Marko Kreen [Mon, 6 Sep 2010 05:51:10 +0000 (08:51 +0300)]
win32: remove code that is moved to libusual

14 years agoLost <sys/resource.h> include.
Marko Kreen [Mon, 6 Sep 2010 05:49:24 +0000 (08:49 +0300)]
Lost <sys/resource.h> include.

14 years agorefresh libusual
Marko Kreen [Mon, 6 Sep 2010 14:04:25 +0000 (17:04 +0300)]
refresh libusual

14 years agonew config var: disable_pqexec
Marko Kreen [Mon, 6 Sep 2010 14:00:32 +0000 (17:00 +0300)]
new config var: disable_pqexec

14 years agoconsole: central syntax error handling
Marko Kreen [Tue, 3 Aug 2010 15:43:20 +0000 (15:43 +0000)]
console: central syntax error handling

always show full query back to user

14 years agoDon't tag automatically generated dbs as killable on reload.
Marko Kreen [Tue, 3 Aug 2010 15:00:18 +0000 (15:00 +0000)]
Don't tag automatically generated dbs as killable on reload.

14 years agoApply fast-fail at connect time.
Marko Kreen [Mon, 19 Jul 2010 07:30:15 +0000 (07:30 +0000)]
Apply fast-fail at connect time.

If server is failing, the clients get error when connecting.

14 years agoMove some portability goo over to libusual.
Marko Kreen [Wed, 16 Jun 2010 10:35:12 +0000 (13:35 +0300)]
Move some portability goo over to libusual.

14 years agoSample script for generating users file from database
Marko Kreen [Fri, 11 Jun 2010 13:11:47 +0000 (16:11 +0300)]
Sample script for generating users file from database

14 years agoWarning flags are now in WFLAGS
Marko Kreen [Fri, 11 Jun 2010 09:45:42 +0000 (12:45 +0300)]
Warning flags are now in WFLAGS

14 years agoSupport for application_name parameter.
Marko Kreen [Thu, 10 Jun 2010 14:10:48 +0000 (17:10 +0300)]
Support for application_name parameter.

It is accepted on client startup, database connection string
in config, and ParamStatus packet from server.

14 years agoconvert few remaining sprintf() uses to snprintf()
Marko Kreen [Sun, 23 May 2010 08:06:40 +0000 (11:06 +0300)]
convert few remaining sprintf() uses to snprintf()

14 years agoconvert few static buffers into pktbuf
Marko Kreen [Sun, 23 May 2010 08:04:11 +0000 (11:04 +0300)]
convert few static buffers into pktbuf

14 years agoFix pg_auth quoting.
Marko Kreen [Thu, 20 May 2010 20:42:46 +0000 (16:42 -0400)]
Fix pg_auth quoting.

Postgres does not use \ there, only "" -> "

14 years agoAllow a user to use long options, instead of short ones.
Guillaume Lelarge [Thu, 20 May 2010 20:40:26 +0000 (16:40 -0400)]
Allow a user to use long options, instead of short ones.

--help and --version are quite standard.  If you only use short options,
you never know which short option you should use (-v or -V).

14 years ago<usual/strpool.h>
Marko Kreen [Tue, 4 May 2010 13:56:33 +0000 (16:56 +0300)]
<usual/strpool.h>

Removes fixed-length limit from parameter values.

14 years ago<usual/regex.h>
Marko Kreen [Tue, 4 May 2010 11:45:22 +0000 (14:45 +0300)]
<usual/regex.h>

14 years ago<usual/signal.h>
Marko Kreen [Mon, 11 Jan 2010 17:10:19 +0000 (19:10 +0200)]
<usual/signal.h>

14 years ago<usual/event.h>
Marko Kreen [Mon, 11 Jan 2010 17:05:14 +0000 (19:05 +0200)]
<usual/event.h>

14 years ago<usual/mbuf.h>
Marko Kreen [Mon, 11 Jan 2010 16:50:39 +0000 (18:50 +0200)]
<usual/mbuf.h>

14 years ago<usual/fileutil.h>
Marko Kreen [Mon, 11 Jan 2010 06:11:02 +0000 (08:11 +0200)]
<usual/fileutil.h>

14 years ago<usual/safeio.h>
Marko Kreen [Mon, 11 Jan 2010 06:08:30 +0000 (08:08 +0200)]
<usual/safeio.h>

14 years ago<usual/socket.h>
Marko Kreen [Mon, 11 Jan 2010 06:07:30 +0000 (08:07 +0200)]
<usual/socket.h>

14 years ago<usual/slab.h>
Marko Kreen [Mon, 11 Jan 2010 05:59:41 +0000 (07:59 +0200)]
<usual/slab.h>

14 years ago<usual/lookup3.h>
Marko Kreen [Mon, 11 Jan 2010 05:50:20 +0000 (07:50 +0200)]
<usual/lookup3.h>

14 years ago<usual/aatree.h>
Marko Kreen [Mon, 11 Jan 2010 05:47:58 +0000 (07:47 +0200)]
<usual/aatree.h>

14 years ago<usual/string.h>
Marko Kreen [Mon, 11 Jan 2010 05:45:07 +0000 (07:45 +0200)]
<usual/string.h>

14 years ago<usual/logging.h>
Marko Kreen [Mon, 11 Jan 2010 05:44:16 +0000 (07:44 +0200)]
<usual/logging.h>

14 years ago<usual/string.h>
Marko Kreen [Mon, 11 Jan 2010 05:37:05 +0000 (07:37 +0200)]
<usual/string.h>

14 years ago<usual/list.h>, <usual/statlist.h>
Marko Kreen [Mon, 11 Jan 2010 05:27:09 +0000 (07:27 +0200)]
<usual/list.h>, <usual/statlist.h>

14 years ago<usual/time.h>
Marko Kreen [Mon, 11 Jan 2010 05:01:41 +0000 (07:01 +0200)]
<usual/time.h>

14 years agolibusual: include into build system
Marko Kreen [Mon, 11 Jan 2010 04:55:44 +0000 (06:55 +0200)]
libusual: include into build system

14 years agoForgot to change second listen() call also to cf_listen_backlog.
Marko Kreen [Tue, 4 May 2010 10:33:12 +0000 (10:33 +0000)]
Forgot to change second listen() call also to cf_listen_backlog.

14 years agov1.3.3rc1
Marko Kreen [Fri, 23 Apr 2010 14:44:54 +0000 (14:44 +0000)]
v1.3.3rc1

14 years agoNow actually improve few disconnect messages.
Marko Kreen [Fri, 23 Apr 2010 13:51:48 +0000 (13:51 +0000)]
Now actually improve few disconnect messages.

14 years agoLet disconnect_server/client() take printf style args.
Marko Kreen [Fri, 23 Apr 2010 13:50:49 +0000 (13:50 +0000)]
Let disconnect_server/client() take printf style args.

14 years agogcc braindamage: -Wformat-security is not turned on by -Wall -Wextra -Wformat
Marko Kreen [Fri, 23 Apr 2010 13:49:43 +0000 (13:49 +0000)]
gcc braindamage: -Wformat-security is not turned on by -Wall -Wextra -Wformat

14 years agoIncrease size of various startup-related buffers.
Marko Kreen [Fri, 23 Apr 2010 13:48:13 +0000 (13:48 +0000)]
Increase size of various startup-related buffers.

Also bring them under single define.

14 years agoMake listen(2) backlog argument configurable.
Marko Kreen [Wed, 21 Apr 2010 10:08:57 +0000 (10:08 +0000)]
Make listen(2) backlog argument configurable.

14 years agoDont let logging change errno.
Marko Kreen [Mon, 19 Apr 2010 07:08:31 +0000 (07:08 +0000)]
Dont let logging change errno.

With badly configured logging and higher logging levels, the code can
see wrong errno from syscalls.  So always retore original errno when logging.

14 years agoIncrease room for DateStyle storage.
Marko Kreen [Mon, 19 Apr 2010 07:05:45 +0000 (07:05 +0000)]
Increase room for DateStyle storage.

If value is larger than buffer, it stays empty and libpq will drop connection.

14 years agoExplicitly detect V2 protocol request and close it with proper msg.
Marko Kreen [Wed, 14 Apr 2010 08:09:47 +0000 (08:09 +0000)]
Explicitly detect V2 protocol request and close it with proper msg.

14 years agoMove fast-fail relaunch logic around.
Marko Kreen [Wed, 14 Apr 2010 08:08:27 +0000 (08:08 +0000)]
Move fast-fail relaunch logic around.

Do it together with fast-fail disconnect.  When kept separately
it can launch even if there are no new clients coming.
This causes problem with permanently dead dbs/users, as the
retry will not stop if all clients are gone.

14 years agov1.3.2 pgbouncer_1_3_2
Marko Kreen [Mon, 15 Mar 2010 14:44:28 +0000 (14:44 +0000)]
v1.3.2

14 years agoLog pooler-sent errors as warnings not plain info, as they signify problems.
Marko Kreen [Mon, 15 Mar 2010 13:53:58 +0000 (13:53 +0000)]
Log pooler-sent errors as warnings not plain info, as they signify problems.

14 years agolog message: statement timeout -> query timeout, to match config var
Marko Kreen [Fri, 12 Feb 2010 19:13:07 +0000 (19:13 +0000)]
log message: statement timeout -> query timeout, to match config var

14 years agoDon't let clients queue in case no servers and connections fail.
Marko Kreen [Fri, 12 Feb 2010 19:09:02 +0000 (19:09 +0000)]
Don't let clients queue in case no servers and connections fail.

That allows to avoid unnecessary delays in hopeless situations.

14 years agoIntroduce a new configuration setting: query_wait_timeout
Marko Kreen [Fri, 12 Feb 2010 19:05:04 +0000 (19:05 +0000)]
Introduce a new configuration setting: query_wait_timeout

If a query spends more than query_wait_timeout seconds waiting
it is disconnected. This prevents unresponsive servers from
wasting resources.

Patch by Martin Pihlak

14 years agodoc/confix.txt: uncoonfuse newer asciidoc
Marko Kreen [Fri, 15 Jan 2010 16:39:25 +0000 (16:39 +0000)]
doc/confix.txt: uncoonfuse newer asciidoc

14 years agoCheck error from event_init() to eliminate warning on strict build
Marko Kreen [Wed, 13 Jan 2010 07:24:00 +0000 (07:24 +0000)]
Check error from event_init() to eliminate warning on strict build

14 years agoAdd new patches to NEWS
Marko Kreen [Tue, 12 Jan 2010 10:24:18 +0000 (10:24 +0000)]
Add new patches to NEWS

14 years agosbuf: track exact wait state to avoid double event_del()
Marko Kreen [Tue, 12 Jan 2010 10:19:31 +0000 (10:19 +0000)]
sbuf: track exact wait state to avoid double event_del()

14 years agoIn case of invalid state, show value in error msg
Marko Kreen [Tue, 12 Jan 2010 10:17:46 +0000 (10:17 +0000)]
In case of invalid state, show value in error msg

14 years agotest/test.ini: turn off query_timeout by default
Marko Kreen [Tue, 12 Jan 2010 10:16:36 +0000 (10:16 +0000)]
test/test.ini: turn off query_timeout by default

14 years agoprepare for 1.3.2rc1
Marko Kreen [Fri, 4 Dec 2009 11:19:34 +0000 (11:19 +0000)]
prepare for 1.3.2rc1

14 years agotodo update
Marko Kreen [Fri, 4 Dec 2009 11:15:18 +0000 (11:15 +0000)]
todo update

14 years agoApply client_login_timeout to clients waiting for welcome pkt
Marko Kreen [Fri, 4 Dec 2009 10:28:46 +0000 (10:28 +0000)]
Apply client_login_timeout to clients waiting for welcome pkt

Otherwise the clients stay waiting infinitely, unless there is query_timeout set.

This only applies for servers that have never been up.  If server has
been connected once, the query_timeout is only thing that kills clients,
as clients are let freely log in after first connect to server.

14 years agowin32: allow user to override service account
Marko Kreen [Fri, 13 Nov 2009 14:59:11 +0000 (14:59 +0000)]
win32: allow user to override service account

The automatic decision between Local System and Local Service
was not reliable enough.  And anyway, it's better to let user
pick proper account.

14 years agoClarify few login-related log messages
Marko Kreen [Fri, 13 Nov 2009 13:57:04 +0000 (13:57 +0000)]
Clarify few login-related log messages

14 years agoDisable maintenance during SUSPEND
Marko Kreen [Fri, 13 Nov 2009 13:55:59 +0000 (13:55 +0000)]
Disable maintenance during SUSPEND

Otherwise some timeout may activate and close connection
that is already reported to other side;