]> granicus.if.org Git - pgbouncer/log
pgbouncer
8 years agov1.6 pgbouncer_1_6
Petr Jelinek [Sat, 1 Aug 2015 10:35:11 +0000 (12:35 +0200)]
v1.6

8 years agoUpdate AUTHORS - remove myself from contributors.
Petr Jelinek [Sat, 1 Aug 2015 10:32:54 +0000 (12:32 +0200)]
Update AUTHORS - remove myself from contributors.

Maintainers don't belong to contributors list.

8 years agoDocument the include directive
Petr Jelinek [Sat, 1 Aug 2015 10:26:19 +0000 (12:26 +0200)]
Document the include directive

8 years agoUpdate NEWS again
Marko Kreen [Fri, 31 Jul 2015 13:13:18 +0000 (16:13 +0300)]
Update NEWS again

8 years agoDisable server_idle_timeout when server count gets below min_pool (#60)
Marko Kreen [Fri, 31 Jul 2015 13:08:29 +0000 (16:08 +0300)]
Disable server_idle_timeout when server count gets below min_pool (#60)

8 years agoChange application_name_add_host default to 'off'
Marko Kreen [Fri, 31 Jul 2015 12:11:55 +0000 (15:11 +0300)]
Change application_name_add_host default to 'off'

It can have effect on performance, so it seems it should not
be on by default, especially as it applies to all connections,
not only those that do use application_name from client.

8 years agoNews update again
Marko Kreen [Fri, 31 Jul 2015 11:51:29 +0000 (14:51 +0300)]
News update again

8 years agoMerge pull request #49 from eulerto/coverity
Marko Kreen [Fri, 31 Jul 2015 11:32:20 +0000 (14:32 +0300)]
Merge pull request #49 from eulerto/coverity

Fix errors detected by Coverity.

8 years agoUpdate AUTHORS, new maintainer: Petr Jelinek
Marko Kreen [Fri, 31 Jul 2015 10:45:07 +0000 (13:45 +0300)]
Update AUTHORS, new maintainer: Petr Jelinek

Big cheer to Petr who agreed to help maintain PgBouncer!

8 years agoUpdate NEWS
Marko Kreen [Fri, 31 Jul 2015 10:44:54 +0000 (13:44 +0300)]
Update NEWS

8 years agoUpgrade libusual
Marko Kreen [Fri, 31 Jul 2015 10:34:16 +0000 (13:34 +0300)]
Upgrade libusual

8 years agotest.sh; sync with 9.4, make more robust
Marko Kreen [Fri, 31 Jul 2015 09:55:44 +0000 (12:55 +0300)]
test.sh; sync with 9.4, make more robust

8 years agoWait for client header during login (#53)
Marko Kreen [Fri, 31 Jul 2015 10:08:03 +0000 (13:08 +0300)]
Wait for client header during login (#53)

It's bit complicated as during login there are both
V2 (8-byte) and V3 (5-byte) headers.  And it's possible
for V3 packet to be smaller than 8 bytes.

To keep things becoming too messy, avoid looking at state
and just accept both headers always.  Like get_header()
does already.

For consistency, apply same logic to server connections too.

8 years agoc-style: More consistent brace usage
Marko Kreen [Mon, 27 Jul 2015 11:50:47 +0000 (14:50 +0300)]
c-style: More consistent brace usage

Use more braces in places where statement boundaries are
not obvious at glance.

8 years agodoc: add missing options to sample config
Marko Kreen [Fri, 31 Jul 2015 09:10:31 +0000 (12:10 +0300)]
doc: add missing options to sample config

8 years agodoc: missing vars
Marko Kreen [Mon, 27 Jul 2015 08:57:24 +0000 (11:57 +0300)]
doc: missing vars

8 years agoetc/optscan.sh - show undocumented options
Marko Kreen [Mon, 27 Jul 2015 08:34:26 +0000 (11:34 +0300)]
etc/optscan.sh - show undocumented options

8 years agoMerge pull request #47 from olshevskiy87/t.1
PJMODOS [Sun, 14 Jun 2015 00:58:20 +0000 (02:58 +0200)]
Merge pull request #47 from olshevskiy87/t.1

Fix spelling mistakes, part 2

8 years agoMerge pull request #45 from olshevskiy87/patch-1
PJMODOS [Sun, 14 Jun 2015 00:57:35 +0000 (02:57 +0200)]
Merge pull request #45 from olshevskiy87/patch-1

Fix spelling mistake

9 years agoThere is a typo while checking for error.
Euler Taveira [Thu, 30 Apr 2015 15:21:21 +0000 (12:21 -0300)]
There is a typo while checking for error.

Spotted by Coverity.

9 years agoFix some unchecked return values.
Euler Taveira [Thu, 30 Apr 2015 15:20:20 +0000 (12:20 -0300)]
Fix some unchecked return values.

Some event_add() return value were not checked. Either test the output
or ignore it with (void). Adopt the former because it give us a chance
to expose a bug.

While in it, be consistent with the log messages.

Spotted by Coverity.

9 years agoMissing varargs cleanup.
Euler Taveira [Thu, 30 Apr 2015 15:16:25 +0000 (12:16 -0300)]
Missing varargs cleanup.

Spotted by Coverity.

9 years agofix spelling mistakes, part 2
Dmitriy Olshevskiy [Wed, 22 Apr 2015 19:13:57 +0000 (15:13 -0400)]
fix spelling mistakes, part 2

9 years agofix spelling mistake
olshevskiy87 [Sun, 19 Apr 2015 14:46:43 +0000 (18:46 +0400)]
fix spelling mistake

9 years agoUpdate links in README
PJMODOS [Fri, 10 Apr 2015 22:17:50 +0000 (00:17 +0200)]
Update links in README

9 years agoSlightly better auth_user fix.
Marko Kreen [Wed, 8 Apr 2015 10:48:25 +0000 (13:48 +0300)]
Slightly better auth_user fix.

9 years agoRemove use of HOST_NAME_MAX, not portable (#40)
Marko Kreen [Wed, 8 Apr 2015 10:27:12 +0000 (13:27 +0300)]
Remove use of HOST_NAME_MAX, not portable (#40)

9 years agoCheck if auth_user is set.
Marko Kreen [Wed, 8 Apr 2015 06:22:55 +0000 (09:22 +0300)]
Check if auth_user is set.

Fixes a crash if password packet appears before startup packet (#42).

9 years agoUpdate libusual
Marko Kreen [Mon, 9 Mar 2015 21:05:32 +0000 (23:05 +0200)]
Update libusual

9 years agoMerge pull request #35 from PJMODOS/master
Marko Kreen [Thu, 29 Jan 2015 07:24:54 +0000 (09:24 +0200)]
Merge pull request #35 from PJMODOS/master

Don't allow newserver connections when PAUSE <db> was issued.

9 years agoDon't allow newserver connections when PAUSE <db> was issued.
Petr Jelinek [Wed, 28 Jan 2015 21:20:38 +0000 (22:20 +0100)]
Don't allow newserver connections when PAUSE <db> was issued.

9 years agov1.6rc1 pgbouncer_1_6_rc1
Marko Kreen [Tue, 30 Dec 2014 14:27:21 +0000 (16:27 +0200)]
v1.6rc1

9 years agoUpdate docs
Marko Kreen [Tue, 30 Dec 2014 14:20:24 +0000 (16:20 +0200)]
Update docs

9 years agoUpgrade libusual
Marko Kreen [Tue, 30 Dec 2014 14:18:44 +0000 (16:18 +0200)]
Upgrade libusual

9 years agoUse csrandom for secure randomness
Marko Kreen [Tue, 30 Dec 2014 14:31:12 +0000 (16:31 +0200)]
Use csrandom for secure randomness

9 years agoc-ares: force IPv4 on c-ares <= v1.10
Marko Kreen [Tue, 30 Dec 2014 13:13:45 +0000 (15:13 +0200)]
c-ares: force IPv4 on c-ares <= v1.10

It does not resolve CNAME with AF_UNSPEC.
Fixed in GIT, still unreleased.

9 years agoSkip adns_per_loop if adns is not initialized.
Marko Kreen [Sun, 23 Nov 2014 09:06:23 +0000 (11:06 +0200)]
Skip adns_per_loop if adns is not initialized.

Fixes crash with c-ares + takeover.

9 years agoUpgrade libusual
Marko Kreen [Thu, 7 Aug 2014 19:59:10 +0000 (22:59 +0300)]
Upgrade libusual

9 years agoEdit news.
Marko Kreen [Thu, 12 Jun 2014 20:35:21 +0000 (23:35 +0300)]
Edit news.

9 years agoUpdate libusual
Marko Kreen [Thu, 12 Jun 2014 18:54:18 +0000 (21:54 +0300)]
Update libusual

10 years agoMerge pull request #26 from guillaumeaubert/master
Marko Kreen [Mon, 26 May 2014 06:26:31 +0000 (09:26 +0300)]
Merge pull request #26 from guillaumeaubert/master

Allow comments in PgBouncer's auth files

10 years agoTest that commented out lines are ignored.
Guillaume Aubert [Thu, 15 May 2014 22:59:23 +0000 (15:59 -0700)]
Test that commented out lines are ignored.

10 years agoSkip commented out lines in auth file.
Guillaume Aubert [Thu, 15 May 2014 22:59:01 +0000 (15:59 -0700)]
Skip commented out lines in auth file.

10 years agomax_user_connections implementation - a limit of connected users.
Pavel Stehule [Tue, 4 Mar 2014 17:32:04 +0000 (18:32 +0100)]
max_user_connections implementation - a limit of connected users.

It is similar to max_db_connections. It is designed for a usage, where databases on server are "unlimited"

10 years agoMerge pull request #24 from pgexperts/master
Marko Kreen [Sat, 17 May 2014 15:57:29 +0000 (18:57 +0300)]
Merge pull request #24 from pgexperts/master

Updated readme with "look below for git compile instructions", as well a...

10 years agoMake application_name_add_host work also with unix sockets.
Marko Kreen [Sat, 17 May 2014 15:53:04 +0000 (18:53 +0300)]
Make application_name_add_host work also with unix sockets.

10 years agoUpgrade libusual
Marko Kreen [Sat, 17 May 2014 15:50:04 +0000 (18:50 +0300)]
Upgrade libusual

10 years agoMerge pull request #23 from pgexperts/appname-hostport
Marko Kreen [Sat, 17 May 2014 15:09:29 +0000 (18:09 +0300)]
Merge pull request #23 from pgexperts/appname-hostport

Add the client host IP address and port to application_name.

10 years agoUpdated readme with "look below for git compile instructions", as well as missing...
Josh Berkus [Mon, 5 May 2014 23:43:00 +0000 (16:43 -0700)]
Updated readme with "look below for git compile instructions", as well as missing dependancy.

10 years agoAdd the client host IP address and port to application_name.
Andrew Dunstan [Tue, 8 Apr 2014 15:28:43 +0000 (11:28 -0400)]
Add the client host IP address and port to application_name.

This is enabled by a config parameter which defaults to 'on'

If the client subsequently overwrites the application_name parameter
during the session then this won't be sticky, but it does let you see
(and log) where queries are actually coming from instead of just seeing
pgbouncer as the source address and port.

10 years agoMerge pull request #20 from eulerto/master
Marko Kreen [Thu, 19 Dec 2013 09:24:17 +0000 (01:24 -0800)]
Merge pull request #20 from eulerto/master

Trivial fixes

10 years agoFix a bunch of typos.
Euler Taveira de Oliveira [Wed, 18 Dec 2013 23:38:33 +0000 (20:38 -0300)]
Fix a bunch of typos.

10 years agoUse uppercase in TODO/FIXME.
Euler Taveira de Oliveira [Wed, 18 Dec 2013 23:36:19 +0000 (20:36 -0300)]
Use uppercase in TODO/FIXME.

Some popular editors (like Vim) highlight uppercase keywords like TODO,
FIXME, and XXX.

10 years agoReplace C++ comments.
Euler Taveira de Oliveira [Wed, 18 Dec 2013 23:33:31 +0000 (20:33 -0300)]
Replace C++ comments.

10 years agoDraft news, unedited
Marko Kreen [Mon, 18 Nov 2013 00:14:31 +0000 (02:14 +0200)]
Draft news, unedited

10 years agoAllow numbers in hostname, always try to parse with inet_pton
Marko Kreen [Sat, 16 Nov 2013 19:43:24 +0000 (21:43 +0200)]
Allow numbers in hostname, always try to parse with inet_pton

10 years agoauth_query: make password loading query configurable
Marko Kreen [Sat, 16 Nov 2013 19:21:55 +0000 (21:21 +0200)]
auth_query: make password loading query configurable

10 years agogitignore: add more stuff
Marko Kreen [Sat, 16 Nov 2013 18:31:05 +0000 (20:31 +0200)]
gitignore: add more stuff

10 years agoMerge remote-tracking branch 'ccutrer/dev/max_db_connections'
Marko Kreen [Sat, 16 Nov 2013 18:18:09 +0000 (20:18 +0200)]
Merge remote-tracking branch 'ccutrer/dev/max_db_connections'

10 years agoMerge remote-tracking branch 'ccutrer/dev/auth_user'
Marko Kreen [Sat, 16 Nov 2013 18:17:58 +0000 (20:17 +0200)]
Merge remote-tracking branch 'ccutrer/dev/auth_user'

10 years agoconfig.txt: update auth_file about 9.0+ situation.
Marko Kreen [Fri, 15 Nov 2013 16:35:05 +0000 (18:35 +0200)]
config.txt: update auth_file about 9.0+ situation.

Requested-by: Alexander Farber
10 years agoSmall bug fix, must check calloc result
Heikki Linnakangas [Fri, 15 Nov 2013 16:31:25 +0000 (18:31 +0200)]
Small bug fix, must check calloc result

10 years agoProper invalidation for autodbs
Marko Kreen [Fri, 15 Nov 2013 16:18:44 +0000 (18:18 +0200)]
Proper invalidation for autodbs

As autodb database entries are generated on the fly,
old invalidation code skipped them, so new config
was ignored.  This will hopefully fix it.

Reported-by: Moshe Jacobson
10 years agoBump version to 1.6dev
Marko Kreen [Mon, 7 Oct 2013 21:50:53 +0000 (00:50 +0300)]
Bump version to 1.6dev

10 years agokeep track of connection count during online restart
Cody Cutrer [Wed, 28 Aug 2013 01:59:58 +0000 (19:59 -0600)]
keep track of connection count during online restart

10 years agosimplify oldest connection logic
Cody Cutrer [Wed, 28 Aug 2013 00:27:55 +0000 (18:27 -0600)]
simplify oldest connection logic

10 years agoevict old connections when needed (if possible) for max_db_connections
Cody Cutrer [Tue, 27 Aug 2013 22:29:46 +0000 (16:29 -0600)]
evict old connections when needed (if possible) for max_db_connections

10 years agoimplement database-wide connection limit
Cody Cutrer [Mon, 4 Feb 2013 23:58:05 +0000 (16:58 -0700)]
implement database-wide connection limit

10 years agodetect server close due to synchronous callbacks
Cody Cutrer [Thu, 5 Sep 2013 22:05:52 +0000 (16:05 -0600)]
detect server close due to synchronous callbacks

10 years agofix crash when using auth_conn and something times out during login
Cody Cutrer [Thu, 29 Aug 2013 14:39:26 +0000 (08:39 -0600)]
fix crash when using auth_conn and something times out during login

a client can be linked when in CL_LOGIN due to doing the auth query,
so be prepared to close the associated server as well.

10 years agofix reconnects of auth_user dbs after online restart
Cody Cutrer [Wed, 28 Aug 2013 02:47:44 +0000 (20:47 -0600)]
fix reconnects of auth_user dbs after online restart

if the user was a dynamic user, the only way the bouncer knows the
password was from a new client connection. if an existing client
starts a transaction before a new client connects, it will not know
the correct password. so pass that info along in the online restart
data.

note that this is backwards compatible - old bouncers just won't send
the password, and it's stuck until the client tries to connect

10 years agofix takeover of auth_user when dynamic user is connected to server
Cody Cutrer [Wed, 28 Aug 2013 02:08:00 +0000 (20:08 -0600)]
fix takeover of auth_user when dynamic user is connected to server

10 years agofix auth_user with session pooling
Cody Cutrer [Thu, 28 Feb 2013 15:54:04 +0000 (08:54 -0700)]
fix auth_user with session pooling

the auth_user pool wasn't releasing the server conn, so the
client would end up connected to the db as the auth_user

10 years agoauth_user support
Cody Cutrer [Wed, 18 Jan 2012 17:32:01 +0000 (10:32 -0700)]
auth_user support

query the database's pg_shadow table for user information,
instead of using a local userlist.txt.  Brings transparent support
for Postgres 9.0+ which no longer has a compatible file format.

Tested with trust and md5 auth_types only.

10 years agodoc: Expand server_reset_query a bit.
Marko Kreen [Mon, 7 Oct 2013 21:28:53 +0000 (00:28 +0300)]
doc: Expand server_reset_query a bit.

10 years agoMove comment to make it less wrong.
Marko Kreen [Mon, 7 Oct 2013 21:26:15 +0000 (00:26 +0300)]
Move comment to make it less wrong.

10 years agoMerge remote-tracking branch 'ccutrer/dev/per_object_pool_modes'
Marko Kreen [Mon, 7 Oct 2013 21:07:15 +0000 (00:07 +0300)]
Merge remote-tracking branch 'ccutrer/dev/per_object_pool_modes'

10 years agoMerge remote-tracking branch 'ccutrer/dev/nxdomain_ttl'
Marko Kreen [Mon, 7 Oct 2013 21:02:44 +0000 (00:02 +0300)]
Merge remote-tracking branch 'ccutrer/dev/nxdomain_ttl'

10 years agoMerge remote-tracking branch 'ccutrer/dev/latency_fix'
Marko Kreen [Mon, 7 Oct 2013 20:55:47 +0000 (23:55 +0300)]
Merge remote-tracking branch 'ccutrer/dev/latency_fix'

10 years agoMerge pull request #15 from ccutrer/dev/config_load_cleanup
Marko Kreen [Mon, 7 Oct 2013 20:53:31 +0000 (13:53 -0700)]
Merge pull request #15 from ccutrer/dev/config_load_cleanup

Dev/config load cleanup

10 years agoadd per-user pool_mode
Cody Cutrer [Thu, 19 Jan 2012 23:01:30 +0000 (16:01 -0700)]
add per-user pool_mode

10 years agoimplement per-database pool_mode
Cody Cutrer [Wed, 18 Jan 2012 16:55:14 +0000 (09:55 -0700)]
implement per-database pool_mode

10 years agofix launching new connections during maintenance
Cody Cutrer [Mon, 26 Aug 2013 20:30:27 +0000 (14:30 -0600)]
fix launching new connections during maintenance

match up waiting connections with tested/used until we run out.
launches new connection if there are more waiting than could be
fulfilled by refreshing current connections. this situation can
happen if you have high churn on client connections (i.e. with
transaction pooling), such that there is *always* at least one
connection in sv_tested or sv_used.

10 years agodon't load auth file twice at boot
Cody Cutrer [Wed, 28 Aug 2013 18:57:12 +0000 (12:57 -0600)]
don't load auth file twice at boot

the stat wasn't getting cached on the initial load, so immediately
after booting the janitor would notice it "changed", and reload it

10 years agodon't overwrite pgbouncer user on startup if it already exists
Cody Cutrer [Wed, 28 Aug 2013 18:29:54 +0000 (12:29 -0600)]
don't overwrite pgbouncer user on startup if it already exists

10 years agoadd a separate config for controlling negative dns caching
Cody Cutrer [Thu, 19 Sep 2013 19:31:37 +0000 (13:31 -0600)]
add a separate config for controlling negative dns caching

10 years agoMerge branch 'master' of git://github.com/markokr/pgbouncer-dev
Marko Kreen [Tue, 20 Aug 2013 16:58:53 +0000 (19:58 +0300)]
Merge branch 'master' of git://github.com/markokr/pgbouncer-dev

10 years agoMerge pull request #14 from mhagander/typofix
Marko Kreen [Tue, 20 Aug 2013 13:43:57 +0000 (06:43 -0700)]
Merge pull request #14 from mhagander/typofix

Fix incorrect keyword in example config file

10 years agoFix incorrect keyword in example config file
Magnus Hagander [Tue, 20 Aug 2013 13:07:20 +0000 (15:07 +0200)]
Fix incorrect keyword in example config file

10 years agoFix deallocate_all() in FAQ
Marko Kreen [Thu, 1 Aug 2013 20:15:31 +0000 (23:15 +0300)]
Fix deallocate_all() in FAQ

8.1 requires loop var to be record.

Reported-by: Christopher Causer
10 years agoMerge pull request #13 from petere/pidfile-newline
Marko Kreen [Sat, 15 Jun 2013 11:16:55 +0000 (04:16 -0700)]
Merge pull request #13 from petere/pidfile-newline

Add newline at the end of the PID file

10 years agoAdd newline at the end of the PID file
Peter Eisentraut [Fri, 14 Jun 2013 18:47:30 +0000 (14:47 -0400)]
Add newline at the end of the PID file

This is standard for PID files elsewhere, and makes it behave better
when inspecting the file manually.

11 years agoconsole: rename backend_pid to remote_pid
Marko Kreen [Wed, 17 Apr 2013 16:07:28 +0000 (19:07 +0300)]
console: rename backend_pid to remote_pid

This corresponds better to current implementation,
as now client pid is also shown correctly.

11 years agolog: wrap ipv6 address with []
Marko Kreen [Mon, 8 Apr 2013 19:24:35 +0000 (22:24 +0300)]
log: wrap ipv6 address with []

11 years agotune_socket: use libusual for socket flags
Marko Kreen [Mon, 8 Apr 2013 19:11:37 +0000 (22:11 +0300)]
tune_socket: use libusual for socket flags

11 years agoOn connect to server, show local ip and port
Marko Kreen [Tue, 2 Apr 2013 21:25:51 +0000 (00:25 +0300)]
On connect to server, show local ip and port

11 years agoShow remote pid of unix socket
Marko Kreen [Tue, 2 Apr 2013 20:46:40 +0000 (23:46 +0300)]
Show remote pid of unix socket

11 years agoRefresh libusual
Marko Kreen [Tue, 2 Apr 2013 20:46:29 +0000 (23:46 +0300)]
Refresh libusual

11 years agoRefresh libusual
Marko Kreen [Tue, 19 Mar 2013 20:05:34 +0000 (22:05 +0200)]
Refresh libusual

11 years agowin32: Don't set SO_REUSEADDR on listen socket.
Marko Kreen [Mon, 18 Mar 2013 16:01:52 +0000 (18:01 +0200)]
win32: Don't set SO_REUSEADDR on listen socket.

According to Postgres src/backend/libpq/pqcomm.c:

/*
 * Without the SO_REUSEADDR flag, a new postmaster can't be started
 * right away after a stop or crash, giving "address already in use"
 * error on TCP ports.
 *
 * On win32, however, this behavior only happens if the
 * SO_EXLUSIVEADDRUSE is set. With SO_REUSEADDR, win32 allows multiple
 * servers to listen on the same address, resulting in unpredictable
 * behavior. With no flags at all, win32 behaves as Unix with
 * SO_REUSEADDR.
 */