Re: changing port numbers so pgbouncer can read geoserver and postgres - Mailing list pgsql-general

From si24
Subject Re: changing port numbers so pgbouncer can read geoserver and postgres
Date
Msg-id 1383901704730-5777453.post@n5.nabble.com
Whole thread Raw
In response to Re: Re: changing port numbers so pgbouncer can read geoserver and postgres  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: changing port numbers so pgbouncer can read geoserver and postgres
List pgsql-general
would any of this help make it more clear on what I seem to be doing wrong?

pgbouncer=# show config;
            key            |                      value
| changeable
---------------------------+-------------------------------------------------+------------
 job_name                  | pgbouncer
| no
 service_name              | pgbouncer
| no
 conffile                  | C:\Program Files\PostgreSQL\share\pgbouncer.ini
| yes
 logfile                   | C:\Program Files\PostgreSQL\log\pgbouncer.log
| yes
 pidfile                   | C:\Program Files\PostgreSQL\log\pgbouncer.pid
| no
 listen_addr               | *
| no
 listen_port               | 5432
| no
 listen_backlog            | 128
| no
 auth_type                 | md5
| yes
 auth_file                 | C:\Program Files\PostgreSQL\etc\userlist.txt
| yes
 pool_mode                 | transaction
| yes
 max_client_conn           | 400
| yes
 default_pool_size         | 100
| yes
 min_pool_size             | 0
| yes
 reserve_pool_size         | 0
| yes
 reserve_pool_timeout      | 5
| yes
 syslog                    | 0
| yes
 syslog_facility           | daemon
| yes
 syslog_ident              | pgbouncer
| yes
 autodb_idle_timeout       | 3600
| yes
 server_reset_query        | DISCARD ALL
| yes
 server_check_query        | select 1
| yes
 server_check_delay        | 30
| yes
 query_timeout             | 0
| yes
 query_wait_timeout        | 0
| yes
 client_idle_timeout       | 0
| yes
 client_login_timeout      | 60
| yes
 idle_transaction_timeout  | 0
| yes
 server_lifetime           | 1200
| yes
 server_idle_timeout       | 60
| yes
 server_connect_timeout    | 15
| yes
 server_login_retry        | 15
| yes
 server_round_robin        | 0
| yes
 suspend_timeout           | 10
| yes
 ignore_startup_parameters | application_name,extra_float_digits
| yes
 disable_pqexec            | 0
| no
 dns_max_ttl               | 15
| yes
 dns_zone_check_period     | 0
| yes
 max_packet_size           | 2147483647
| yes
 pkt_buf                   | 2048
| no
 sbuf_loopcnt              | 5
| yes
 tcp_defer_accept          | 0
| yes
 tcp_socket_buffer         | 0
| yes
 tcp_keepalive             | 1
| yes
 tcp_keepcnt               | 0
| yes
 tcp_keepidle              | 0
| yes
 tcp_keepintvl             | 0
| yes
 verbose                   | 0
| yes
 admin_users               | postgres
| yes
 stats_users               | postgres
| yes
 stats_period              | 60
| yes
 log_connections           | 1
| yes
 log_disconnections        | 1
| yes
 log_pooler_errors         | 1
| yes
(54 rows)



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/changing-port-numbers-so-pgbouncer-can-read-geoserver-and-postgres-tp5776631p5777453.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Victor Hooi
Date:
Subject: Re: Breaking up a PostgreSQL COPY command into chunks?
Next
From: Marc Mamin
Date:
Subject: pg_upgrade / Checking for presence of required libraries