Can anyone help setting up pgbouncer?

From: Nick <nboutelier(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can anyone help setting up pgbouncer?
Date: 2009-11-13 07:10:09
Message-ID: 07795964-f87c-40b0-9648-f9f907114614@u25g2000prh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Im trying to set up pgbouncer. Installation seemed to go well but when
I try...

$ pgbouncer -d pgbouncer.ini

I get an error...

2009-11-13 02:02:35.170 7245 ERROR broken auth file
2009-11-13 02:02:35.170 7245 LOG File descriptor limit: 1024 (H:1024),
max_client_conn: 100, max fds possible: 110

Here is my pgbouncer.ini file...

databases]
pgbouncer1 = host=127.0.0.1 port=5432 dbname=pgbouncer1
[pgbouncer]
listen_port = 6543
listen_addr = 127.0.0.1
auth_type = md5
auth_file = users.txt
logfile = pgbouncer.log
pidfile = pgbouncer.pid
admin_users = pguser1

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2009-11-13 07:32:20 Re: [GENERAL] CREATE TABLE LIKE and SERIAL
Previous Message Matt Sanchez 2009-11-13 06:34:14 Libpq binary mode SELECT ... WHERE ID IN ($1) Question