|
Packit Service |
a2ae7a |
module Test_Pgbouncer =
|
|
Packit Service |
a2ae7a |
let pgconfig =";; database name = connect string
|
|
Packit Service |
a2ae7a |
;;
|
|
Packit Service |
a2ae7a |
;; connect string params:
|
|
Packit Service |
a2ae7a |
;; dbname= host= port= user= password=
|
|
Packit Service |
a2ae7a |
[databases]
|
|
Packit Service |
a2ae7a |
; foodb over unix socket
|
|
Packit Service |
a2ae7a |
foodb =
|
|
Packit Service |
a2ae7a |
|
|
Packit Service |
a2ae7a |
; redirect bardb to bazdb on localhost
|
|
Packit Service |
a2ae7a |
bardb = host=localhost dbname=bazdb
|
|
Packit Service |
a2ae7a |
|
|
Packit Service |
a2ae7a |
; acceess to dest database will go with single user
|
|
Packit Service |
a2ae7a |
forcedb = host=127.0.0.1 port=300 user=baz password=foo client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1'
|
|
Packit Service |
a2ae7a |
[pgbouncer]
|
|
Packit Service |
a2ae7a |
;;; Administrative settings
|
|
Packit Service |
a2ae7a |
logfile = /var/log/pgbouncer/pgbouncer.log
|
|
Packit Service |
a2ae7a |
pidfile = /var/run/pgbouncer/pgbouncer.pid
|
|
Packit Service |
a2ae7a |
; ip address or * which means all ip-s
|
|
Packit Service |
a2ae7a |
listen_addr = 127.0.0.1
|
|
Packit Service |
a2ae7a |
listen_port = 6432
|
|
Packit Service |
a2ae7a |
;auth_file = /8.0/main/global/pg_auth
|
|
Packit Service |
a2ae7a |
auth_file = /var/lib/pgsql/data/global/pg_auth
|
|
Packit Service |
a2ae7a |
admin_users = postgres
|
|
Packit Service |
a2ae7a |
server_reset_query = DISCARD ALL
|
|
Packit Service |
a2ae7a |
"
|
|
Packit Service |
a2ae7a |
|
|
Packit Service |
a2ae7a |
test Pgbouncer.lns get pgconfig =
|
|
Packit Service |
a2ae7a |
{ "#comment" = "; database name = connect string" }
|
|
Packit Service |
a2ae7a |
{ "#comment" = ";" }
|
|
Packit Service |
a2ae7a |
{ "#comment" = "; connect string params:" }
|
|
Packit Service |
a2ae7a |
{ "#comment" = "; dbname= host= port= user= password=" }
|
|
Packit Service |
a2ae7a |
{ "databases"
|
|
Packit Service |
a2ae7a |
{ "#comment" = "foodb over unix socket" }
|
|
Packit Service |
a2ae7a |
{ "foodb" }
|
|
Packit Service |
a2ae7a |
{ }
|
|
Packit Service |
a2ae7a |
{ "#comment" = "redirect bardb to bazdb on localhost" }
|
|
Packit Service |
a2ae7a |
{ "bardb" = "host=localhost dbname=bazdb" }
|
|
Packit Service |
a2ae7a |
{ }
|
|
Packit Service |
a2ae7a |
{ "#comment" = "acceess to dest database will go with single user" }
|
|
Packit Service |
a2ae7a |
{ "forcedb" = "host=127.0.0.1 port=300 user=baz password=foo client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1'" }
|
|
Packit Service |
a2ae7a |
}
|
|
Packit Service |
a2ae7a |
{ "pgbouncer"
|
|
Packit Service |
a2ae7a |
{ "#comment" = ";; Administrative settings" }
|
|
Packit Service |
a2ae7a |
{ "logfile" = "/var/log/pgbouncer/pgbouncer.log" }
|
|
Packit Service |
a2ae7a |
{ "pidfile" = "/var/run/pgbouncer/pgbouncer.pid" }
|
|
Packit Service |
a2ae7a |
{ "#comment" = "ip address or * which means all ip-s" }
|
|
Packit Service |
a2ae7a |
{ "listen_addr" = "127.0.0.1" }
|
|
Packit Service |
a2ae7a |
{ "listen_port" = "6432" }
|
|
Packit Service |
a2ae7a |
{ "#comment" = "auth_file = /8.0/main/global/pg_auth" }
|
|
Packit Service |
a2ae7a |
{ "auth_file" = "/var/lib/pgsql/data/global/pg_auth" }
|
|
Packit Service |
a2ae7a |
{ "admin_users" = "postgres" }
|
|
Packit Service |
a2ae7a |
{ "server_reset_query" = "DISCARD ALL" }
|
|
Packit Service |
a2ae7a |
}
|
|
Packit Service |
a2ae7a |
|