| From: | "Gilberto Castillo" <gilberto(dot)castillo(at)etecsa(dot)cu> |
|---|---|
| To: | "anthony" <asotolongo(at)uci(dot)cu> |
| Cc: | "Ayuda" <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: problema con pgbouncer |
| Date: | 2013-12-17 17:37:42 |
| Message-ID: | 57009.192.168.207.54.1387301862.squirrel@webmail.etecsa.cu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
> Hola, ando configurando pgboucer con la version:
> pgbouncer version 1.4.2 (compiled by <buildd(at)roseapple> at 2012-12-08
> 02:21:31)
>
> y postgresql :
> PostgreSQL 9.1.9 on i686-pc-linux-gnu, compiled by gcc (Ubuntu/Linaro
> 4.6.3-1ubuntu5) 4.6.3, 32-bit
>
> la configuración de pgbouncer es la siguiente:
>
>
> [databases]
> postgres = port=5432 dbname=postgres
> aimel = port=6432 dbname=aimel
> [pgbouncer]
> listen_port = 6543
> listen_addr = 127.0.0.1
> admin_users = anthony
> stats_users = anthony
> auth_type = trust
>
> auth_file = users.txt
> logfile = pgbouncer.log
> pidfile = pgbouncer.pid
>
>
> ignore_startup_parameters = application_name
> server_reset_query = DISCARD ALL;
>
> pool_mode = session
> default_pool_size = 10
> log_pooler_errors = 0
>
> max_client_conn = 200
>
>
> en el usert.txt:
>
>
> "anthony"
>
Si te jifas en el manual de pgbouncer en el auth_file, debe ir una pareja
Nombre password (en MD5)
Saludos,
Gilberto Castillo
La Habana, Cuba
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/plain | 179 bytes |
| unknown_filename | text/plain | 157 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maximi89 | 2013-12-17 18:59:36 | Re: Saludos |
| Previous Message | anthony | 2013-12-17 16:37:44 | problema con pgbouncer |