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
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
|
;; database name = connect string
[databases]
p0 = port=6666 host=127.0.0.1 dbname=p0 user=bouncer pool_size=2
p1 = port=6666 host=127.0.0.1 dbname=p1 user=bouncer
p2 = port=6668 host=127.0.0.1 dbname=p2 user=bouncer
;; Configuation section
[pgbouncer]
;;;
;;; Administrative settings
;;;
logfile = test.log
pidfile = 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 = 8.0/main/global/pg_auth
auth_file = 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
;;;
;;; Low-level tuning options
;;;
; buffer for streaming packets
pkt_buf = 2048
;;;
;;; networking options, for info: man 7 tcp
;;;
; linux: notify program about new connection only if there
; is also data received. (Seconds to wait.)
tcp_defer_accept = 0
;; following options are reloadable, but apply only to
;; new connections.
; in-kernel buffer size (linux default: 4096)
tcp_socket_buffer = 0
; whether tcp keepalive should be turned on (0/1)
tcp_keepalive = 0
;; following options are linux-specific.
;; they also require tcp_keepalive=1
; count of keepaliva packets
tcp_keepcnt = 0
; how long the connection can be idle,
; before sending keepalive packets
tcp_keepidle = 0
; The time between individual keepalive probes.
tcp_keepintvl = 0
|
