module Test_Pgbouncer =

    let pgconfig =";; database name = connect string

;;

;; connect string params:

;;   dbname= host= port= user= password=

[databases]

; foodb over unix socket

foodb =

; redirect bardb to bazdb on localhost

bardb = host=localhost dbname=bazdb

; acceess to dest database will go with single user

forcedb = host=127.0.0.1 port=300 user=baz password=foo client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1'

[pgbouncer]

;;; Administrative settings

logfile = /var/log/pgbouncer/pgbouncer.log

pidfile = /var/run/pgbouncer/pgbouncer.pid

; ip address or * which means all ip-s

listen_addr = 127.0.0.1

listen_port = 6432

;auth_file = /8.0/main/global/pg_auth

auth_file = /var/lib/pgsql/data/global/pg_auth

admin_users = postgres

server_reset_query = DISCARD ALL

"

test Pgbouncer.lns get pgconfig =

    { "#comment" = "; database name = connect string" }

    { "#comment" = ";" }

    { "#comment" = "; connect string params:" }

    { "#comment" = ";   dbname= host= port= user= password=" }

    { "databases"

        { "#comment" = "foodb over unix socket" }

        { "foodb" }

        { }

        { "#comment" = "redirect bardb to bazdb on localhost" }

        { "bardb" = "host=localhost dbname=bazdb" }

        { }

        { "#comment" = "acceess to dest database will go with single user" }

        { "forcedb" = "host=127.0.0.1 port=300 user=baz password=foo client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1'" }

    }

    { "pgbouncer"

        { "#comment" = ";; Administrative settings" }

        { "logfile" = "/var/log/pgbouncer/pgbouncer.log" }

        { "pidfile" = "/var/run/pgbouncer/pgbouncer.pid" }

        { "#comment" = "ip address or * which means all ip-s" }

        { "listen_addr" = "127.0.0.1" }

        { "listen_port" = "6432" }

        { "#comment" = "auth_file = /8.0/main/global/pg_auth" }

        { "auth_file" = "/var/lib/pgsql/data/global/pg_auth" }

        { "admin_users" = "postgres" }

        { "server_reset_query" = "DISCARD ALL" }

    }