]> granicus.if.org Git - pgbouncer/log
pgbouncer
9 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

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

9 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

9 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

9 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 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.

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

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

10 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

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

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

11 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.

11 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

11 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

11 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

11 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

11 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

11 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

11 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
11 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

11 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.
 */

11 years agoipv6: Set IPV6_V6ONLY on listen socket.
Marko Kreen [Mon, 18 Mar 2013 15:44:15 +0000 (17:44 +0200)]
ipv6: Set IPV6_V6ONLY on listen socket.

Otherwise it attempts to take over ipv4 port
which fails if the ipv4 was initialized previously.

Reported-by: Guillaume Lelarge
11 years agoAdd missing error checks
Marko Kreen [Wed, 9 Jan 2013 10:31:48 +0000 (12:31 +0200)]
Add missing error checks

11 years agoconfigurable arch for mingw build
Marko Kreen [Wed, 9 Jan 2013 10:28:31 +0000 (12:28 +0200)]
configurable arch for mingw build

11 years agoconfigure: mention dns config in the end
Marko Kreen [Wed, 9 Jan 2013 10:28:11 +0000 (12:28 +0200)]
configure: mention dns config in the end

11 years agowin32: use gnu-style for long args: --foo
Marko Kreen [Tue, 25 Dec 2012 20:09:33 +0000 (22:09 +0200)]
win32: use gnu-style for long args: --foo

11 years agoFix IPv6 address memcpy
Marko Kreen [Sat, 8 Dec 2012 11:09:10 +0000 (13:09 +0200)]
Fix IPv6 address memcpy

11 years agoMerge pull request #6 from mfenniak/master
Marko Kreen [Sat, 8 Dec 2012 11:03:23 +0000 (03:03 -0800)]
Merge pull request #6 from mfenniak/master

Fix cancellation of waiting clients

11 years agoFix cancellation of of waiting clients
Mathieu Fenniak [Fri, 7 Dec 2012 02:15:41 +0000 (19:15 -0700)]
Fix cancellation of of waiting clients

Search waiting_client_list for client to-be-cancelled, in addition
to active_client_list.

11 years agoMinor cleanups for ENABLE/DISABLE, add tests
Marko Kreen [Mon, 3 Dec 2012 16:27:03 +0000 (18:27 +0200)]
Minor cleanups for ENABLE/DISABLE, add tests

11 years agoMerge remote-tracking branch 'wgrant/disable'
Marko Kreen [Mon, 3 Dec 2012 16:19:27 +0000 (18:19 +0200)]
Merge remote-tracking branch 'wgrant/disable'

ENABLE/DISABLE <db> commands for disabling new connections.

11 years agoShow backend_pid in SHOW CLIENTS/SERVERS.
Marko Kreen [Mon, 3 Dec 2012 16:03:55 +0000 (18:03 +0200)]
Show backend_pid in SHOW CLIENTS/SERVERS.

It should help to track connections over unix socket.

11 years agoNew DNS backend: c-ares
Marko Kreen [Mon, 28 May 2012 22:08:11 +0000 (01:08 +0300)]
New DNS backend: c-ares

Supports all interesting features, unlike other backends:
- /etc/hosts with refresh
- SOA lookup
- Large replies (via TCP/EDNS+UDP)
- IPv6

11 years agov1.5.4 pgbouncer_1_5_4
Marko Kreen [Wed, 28 Nov 2012 10:55:18 +0000 (12:55 +0200)]
v1.5.4

11 years agoRefresh libusual
Marko Kreen [Wed, 28 Nov 2012 10:54:31 +0000 (12:54 +0200)]
Refresh libusual

- another fix for deb check
- fix win32 compilation

11 years agodnslookup: missing active count inc
Marko Kreen [Wed, 31 Oct 2012 11:29:29 +0000 (13:29 +0200)]
dnslookup: missing active count inc

11 years agodns: need to use statlist_remove() instead list_del()
Marko Kreen [Wed, 31 Oct 2012 08:51:23 +0000 (10:51 +0200)]
dns: need to use statlist_remove() instead list_del()

Otherwise host_list will have wrong count.

It does not look like the codepath is actually ever used,
but still...

11 years agogetaddrinfo_a: drop double-alloc
Marko Kreen [Mon, 29 Oct 2012 15:20:01 +0000 (17:20 +0200)]
getaddrinfo_a: drop double-alloc