On Sat, Apr 14, 2012 at 6:35 PM, Clodoaldo Neto < clodoaldo.pinto.n...@gmail.com> wrote:
> Em 14 de abril de 2012 09:39, raghu ram <raghuchenn...@gmail.com>escreveu: > >> >> >> On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto < >> clodoaldo.pinto.n...@gmail.com> wrote: >> >>> Em 12 de abril de 2012 14:12, Phoenix Kiula >>> <phoenix.ki...@gmail.com>escreveu: >>> >>>> I had pgbouncer working somehow, but we have switched servers recently >>>> and now I cannot for the life of me figure out again how to set it up. >>>> >>>> Online guides say things like "create a user ID". Well, where? Inside >>>> PG the database? Or in my CentOS system? >>>> >>>> Here's my "/etc/pgbouncer.ini": >>>> >>>> [databases] >>>> * = port = 5432 >>>> >>>> [pgbouncer] >>>> listen_port = 6543 >>>> listen_addr = 127.0.0.1 >>>> auth_type = trust >>>> auth_file = /var/lib/pgsql/pgbouncer.txt >>>> logfile = pgbouncer.log >>>> pidfile = pgbouncer.pid >>>> admin_users = postgres,MYSITE_pgbouncer >>>> pool_mode = transaction >>>> server_reset_query = DISCARD ALL; >>>> server_check_query = select 1 >>>> server_check_delay = 10 >>>> max_client_conn = 1000 >>>> default_pool_size = 20 >>>> log_connections = 0 >>>> log_disconnections = 0 >>>> log_pooler_errors = 1 >>>> >>>> >>>> And here's my authfile, "/var/lib/pgsql/pgbouncer.txt" -- >>>> >>>> "MYSITE_pgbouncer" "" >>>> >>>> Is there something else I need to do? What steps am I missing? When I >>>> start pgbouncer at the command line, I see this error: >>>> >>>> WARNING: password file "/root/.pgpass" has group or world access; >>>> permissions should be u=rw (0600) or less >>>> psql: ERROR: No such user: MYSITE_pgbouncer >>>> >>>> >>> I had this error in the pgbouncer log file after updating to the last >>> version, 1.5, in Centos 6. For me the fix was to set the ownership of the >>> auth_file to pgbouncer. In the previous version, 1.4, it was working with >>> postgres as the owner of that file. >>> >>> Regards, Clodoaldo >>> >> >> Could you please share stats_users information in pgbouncer.ini file ? >> >> > That is the default: > > stats_users = stats, root > Could you please modify and below parameters in pgbouncer.ini file: admin_users = postgres,MYSITE_pgbouncer stats_users = postgres,MYSITE_pgbouncer, stats, root and then Restart the pgbouncer. -- Thanks & Regards, Raghu Ram EnterpriseDB: http://www.enterprisedb.com
