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
!! 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
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
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
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