設定好PgBouncer環境之後，
使用psql連線，都沒有問題
C:\Documents and Settings\Administrator>edb-psql -h 10.10.10.2 -p 6432 -U enterprisedb -d edb
用戶 enterprisedb 密碼：
edb-psql (8.4.4.10)
Type "help" for help.
edb=# select sysdate from dual;
sysdate
--------------------
07-SEP-10 10:51:51
(1 row)
但是使用Execute Query連線時，卻會出現錯誤而無法連線，
連線遭拒：ERROR: Unknown startup parameter
Error Code: 0
SQL State Code: 08004
而在pgbouncer.log中，錯誤內容則為：
2010-09-07 11:01:35.567 20339 WARNING C-0x8813108: (nodb)/(nouser)@10.10.10.1:3560 unsupported startup parameter: extra_float_digits=2
2010-09-07 11:01:35.567 20339 LOG C-0x8813108: (nodb)/(nouser)@10.10.10.1:3560 closing because: Unknown startup parameter (age=0)
2010-09-07 11:01:35.567 20339 WARNING C-0x8813108: (nodb)/(nouser)@10.10.10.1:3560 Pooler Error: Unknown startup parameter
2010-09-07 11:03:09.911 20339 WARNING C-0x8813108: (nodb)/(nouser)@10.10.10.1:3580 unsupported startup parameter: extra_float_digits=2
2010-09-07 11:03:09.912 20339 LOG C-0x8813108: (nodb)/(nouser)@10.10.10.1:3580 closing because: Unknown startup parameter (age=0)
2010-09-07 11:03:09.912 20339 WARNING C-0x8813108: (nodb)/(nouser)@10.10.10.1:3580 Pooler Error: Unknown startup parameter
這時，修改pgbouncer.ini內容，將starup parameter的檢查功能停用，
| ignore_startup_parameters By default, PgBouncer allows only parameters it can keep track of in startup packets - client_encoding, datestyle, timezone and standard_conforming_strings. All others parameters will raise an error. To allow others parameters, they can be specified here, so that pgbouncer knows that they are handled by admin and it can ignore them. Default: empty |
; Comma-separated list of parameters to ignore when given
; in startup packet. Newer JDBC versions require the
; extra_float_digits here.
;
ignore_startup_parameters = extra_float_digits
再連線一次，就連線成功了！
留言列表
ESB (2)