From: | "ac(at)hsk(dot)hk" <ac(at)hsk(dot)hk> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org general" <pgsql-general(at)postgresql(dot)org> |
Cc: | ac(at)hsk(dot)hk |
Subject: | PostgreSQL 9.2 and PGBOUNCER |
Date: | 2013-01-08 06:40:34 |
Message-ID: | F2E26156-F0FE-40CD-A386-E304A1401889@hsk.hk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 PostgreSQL 9.2?
$ psql -U postgres -p 6543 pgbouncer
psql.bin (9.2.1, server 1.4.2/bouncer)
WARNING: psql.bin version 9.2, server version 1.4.
Some psql features might not work.
Type "help" for help.
No entry for terminal type "xterm-color";
using dumb terminal settings.
Q2) if I try the general psql commands, I got errors
for example:
$ psql -U postgres -p 6543 pgbouncer
pgbouncer=# \l
ERROR: invalid command 'SELECT d.datname as "Name",
pg_catalog.pg_get_userbyid(d.datdba) as "Owner",
pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding",
pg_catalog.array_to_string(d.datacl, '\n') AS "Access privileges"
FROM pg_catalog.pg_database d
ORDER BY 1;', use SHOW HELP;
Q3) I can connect to pgbouncer by using "psql -U postgres -p 6543 pgbouncer", however if I try to use "-d postgres", I got error:
$ psql -U postgres -p 6543 pgbouncer -d postgres
psql.bin: warning: extra command-line argument "pgbouncer" ignored
psql.bin: ERROR: no working server connection
Q4) Which port should I use in my application in order to connect to PostgreSQL via pgbouncer, port 6543 or port 5432?
the port value in pgbounce.ini:
postgres = port=5432 dbname=postgres
listen_port = 6543
the port value in postgresql.conf:
port=5432
Please help!
Thanks
From | Date | Subject | |
---|---|---|---|
Next Message | Birta Levente | 2013-01-08 07:13:46 | Re: PostgreSQL 9.2 and PGBOUNCER |
Previous Message | Jackie Zhang | 2013-01-08 06:02:43 | Why the default data range for "pre_auth_delay" and "post_auth_delay" is different? |