![]() ![]() This considers the PgBouncer database that theĬlient has connected to, not the PostgreSQL database of the outgoing ĭo not allow more than this many server connections per database Use additional connections from the reserve pool. If a client has not been serviced in this time, 0 disables.ĭefault: 0 (disabled) reserve_pool_timeout How many additional connections to allow to a pool (see reserve_pool_timeout). The value is effectively capped at the pool size. Improves behavior when the normal load suddently comes back after a period Can be overridden inĪdd more server connections to pool if below this number. How many server connections to allow per user/database pair. Note: ulimit does not apply in a Windows environment. Search for ulimit in your favorite shell man page. Still, it means you should set the number ofįile descriptors to a safely high number. The theoretical maximum should never be reached, unless somebody deliberatelyĬrafts a special load for it. ![]() ![]() Max_client_conn + (max pool_size * total databases) The server, the theoretical maximum used is: If each user connects under its own user name to Number of file descriptors potentially used is more than Operating system might also have to be increased. When this setting is increased, then the file descriptor limits in the Maximum number of client connections allowed. Spanning multiple statements are disallowed in this mode. statement Server is released back to pool after query finishes. transaction Server is released back to pool after transaction finishes. session Server is released back to pool after client disconnects. Specifies when a server connection can be reused by other clients. PgBouncer is started as root or if it’s already running as the given user. If set, specifies the Unix user to change to after startup. Ignored for sockets in the abstract namespace. If set to an empty string, Unix sockets are disabled.Ī value that starts with specifies that a Unix socket in theĪbstract namespace should be created (currently supported on Linux andįor online reboot ( -R) to work, a Unix socket needs to beĬonfigured, and it needs to be in the file-system namespace.ĭefault: /tmp (empty on Windows) unix_socket_mode Applies to both the listening socket and to Only Unix socket connections are accepted.Īddresses can be specified numerically (IPv4/IPv6) or by name. You may also use * meaning “listen on all addresses”. Specifies a list (comma-separated) of addresses where to listen for TCP connections. Without pidfile set, daemonization ( -d) is not allowed. Use the command-line option -q or -d for that. Note that setting logfile does not by itself turn off logging to On Windows, the service must be stopped and started. The log file is kept open, so after rotation, kill -HUP The characters “ ”Īnd “#” are not recognized as special when they appear later in the line. Starting with “ ” or “#” are taken as comments and ignored. The configuration file is in “ini” format. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |