Re: [GENERAL] PostgreSQL 9.2 and PGBOUNCER

2013-01-08 Thread a...@hsk.hk
On 8 Jan 2013, at 5:04 PM, Birta Levente wrote: > The pooler is between client and postgresql server. So, if you want to > connect through the pooler you need to connect on 6543. > > But I think you really need to read some documentation about pgbouncer. Thanks, I can connect to any testing D

Re: [GENERAL] PostgreSQL 9.2 and PGBOUNCER

2013-01-08 Thread Birta Levente
!! Please do not top post !! On 08/01/2013 10:21, a...@hsk.hk wrote: Hi, Thanks for your reply. Below is the pgbouncer.ini === [databases] ; use db:postgres for connection testing postgres = port=5432 dbname=postgres As I said before, with this you can only connect database postgres. Maybe

Re: [GENERAL] PostgreSQL 9.2 and PGBOUNCER

2013-01-08 Thread a...@hsk.hk
Hi, Thanks for your reply. Below is the pgbouncer.ini === [databases] ; use db:postgres for connection testing postgres = port=5432 dbname=postgres [pgbouncer] listen_port = 6543 listen_addr = 127.0.0.1 admin_users = postgres auth_type = md5 auth_file = users.txt server_reset_query = DISCARD AL

Re: [GENERAL] PostgreSQL 9.2 and PGBOUNCER

2013-01-07 Thread Birta Levente
On 08/01/2013 08:40, a...@hsk.hk wrote: Hi, My PostgreSQL is 9.2.1 in Ubuntu 12.04, I need to set up a connection pool by using pgbouncer. I used "apt-get install pgbouncer", after configuring it, I can now connect to pgbouncer and can use all pgbouncer SHOW commands, however: Q1) Is versi

[GENERAL] PostgreSQL 9.2 and PGBOUNCER

2013-01-07 Thread a...@hsk.hk
Hi, My PostgreSQL is 9.2.1 in Ubuntu 12.04, I need to set up a connection pool by using pgbouncer. I used "apt-get install pgbouncer", after configuring it, I can now connect to pgbouncer and can use all pgbouncer SHOW commands, however: Q1) Is version "1.4.2/bouncer" the right one for Pos