Postgres Pro
Downloads
Home   >   mailing lists

Re: Can anyone help setting up pgbouncer? - Mailing list pgsql-general

From Sam Jas
Subject Re: Can anyone help setting up pgbouncer?
Date
Msg-id 722101.83170.qm@web95005.mail.in2.yahoo.com
Whole thread Raw
In response to Can anyone help setting up pgbouncer?  (Nick <nboutelier@gmail.com>)
List pgsql-general
Tree view
Below is sample pgbouncer.ini file.

postgres = host=127.0.0.1 port=5432 dbname=postgres
postgres = host=127.0.0.1 dbname=postgres
postgres = host=127.0.0.1 port=5432 user=sam password=jas client_encoding=UNICODE datestyle=ISO connect_query='SELECT 1'

logfile = pgbouncer.log
pidfile = pgbouncer.pid
listen_addr = *
listen_port = 6000
unix_socket_dir = /tmp
auth_type = trust
auth_file = /usr/local/pg8.3/userlist.txt
admin_users = postgres
stats_users = stats, root
pool_mode = transaction
server_reset_query =
server_check_query = select 1
server_check_delay = 10
max_client_conn = 100
default_pool_size = 500
log_connections = 1
log_disconnections = 1
log_pooler_errors = 1
server_idle_timeout = 60
client_idle_timeout = 60
client_login_timeout = 60


sample of auth_file::  /usr/local/pg8.3/userlist.txt
"postgres" "postgres"


& then try with below command.

pgbouncer -d -v pgbouncer.ini


Hope above info. may help you.


--
Thanks
Sam Jas



--- On Fri, 13/11/09, Nick <nboutelier@gmail.com> wrote:

From: Nick <nboutelier@gmail.com>
Subject: [GENERAL] Can anyone help setting up pgbouncer?
To: pgsql-general@postgresql.org
Date: Friday, 13 November, 2009, 7:10 AM

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Try the new Yahoo! India Homepage. Click here.

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Can anyone help setting up pgbouncer?
Next
From: Ozgun Erdogan
Date:
Subject: XLOG's implementation details