blob: 9b75b40e9114698744719ed1baf6bd3800fccf48 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
|
;; database name = connect string
[databases]
p0 = port=6666 host=localhost dbname=p0 user=bouncer pool_size=2
p1 = port=6666 host=localhost dbname=p1 user=bouncer
p2 = port=6668 host=localhost dbname=p2 user=bouncer
;; Configuation section
[pgbouncer]
;;;
;;; Administrative settings
;;;
logfile = tmp/test.log
pidfile = tmp/test.pid
;;;
;;; Where to wait for clients
;;;
; ip address or * which means all ip-s
listen_addr = 127.0.0.1
listen_port = 6667
unix_socket_dir = /tmp
;;;
;;; Authentication settings
;;;
; any, trust, plain, crypt, md5
;auth_type = trust
auth_file = tmp/userlist.txt
;;;
;;; Pooler personality questions
;;;
; When server connection is released back to pool:
; session - after client disconnects
; transaction - after transaction finishes
; statement - after statement finishes
pool_mode = statement
; When taking idle server into use, this query is ran first.
;
; Query for session pooling:
; ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT
; Query for statement/transaction pooling:
; SELECT 1
; Empty query disables the functionality
server_check_query = select 1
; If server was used more recently that this many seconds ago,
; skip the check query. If 0, the check query is always ran.
server_check_delay = 10
;;;
;;; Connection limits
;;;
; total number of clients that can connect
max_client_conn = 10
default_pool_size = 5
;;;
;;; Timeouts
;;;
; Close server connection if its been connected longer.
server_lifetime = 120
; Close server connection if its not been used in this time.
; Allows to clean unneccessary connections from pool after peak.
server_idle_timeout = 60
; Cancel connection attepmt if server does not answer takes longer.
server_connect_timeout = 15
; If server login failed (server_connect_timeout or auth failure)
; then wait this many second.
server_login_retry = 15
; Dangerous. Server connection is closed if query does not return
; in this time. Should be used to survive network problems,
; _not_ as statement_timeout. (default: 0)
query_timeout = 0
; Dangerous. Client connection is closed if no activity in this time.
; Should be used to survive network problems. (default: 0)
client_idle_timeout = 0
|
