Answer the question
In order to leave comments, you need to log in
PostgreSQL and pgbouncer in RHEL 6?
pgsql and pgbouncer don't work on RHEL6. In debian5 everything worked.
Colleagues, tell me what's wrong.
If postgresql.conf is renamed, it swears at the lack of a config, but, despite the explicit indication of the port in the config, pgsql sits on 5432 after startup and does not allow pgbouncer to start.
/etc/init.d/postgresql listen_port = 5432
/var/lib/pgsql/data/postgresql.conf port = 7432
/etc/pgbouncer/pgbouncer.ini
monitor = host=127.0.0.1 port=7432 dbname=monitor<br/>
nondefaultdb = pool_size=50 reserve_pool=10<br/>
[pgbouncer]<br/>
logfile = /var/log/pgbouncer.log<br/>
pidfile = /tmp/pgbouncer.pid<br/>
listen_addr = *<br/>
listen_port = 5432<br/>
unix_socket_dir = /tmp/postgresql<br/>
auth_type = trust<br/>
#auth_file = 8.0/main/global/pg_auth<br/>
auth_file = /etc/pgbouncer/userlist.txt<br/>
admin_users = postgres<br/>
stats_users = stats, root<br/>
pool_mode = session<br/>
server_reset_query =<br/>
server_check_query = select 1<br/>
server_check_delay = 10<br/>
max_client_conn = 100<br/>
default_pool_size = 20<br/>
reserve_pool_size = 5<br/>
log_connections = 1<br/>
log_disconnections = 1<br/>
log_pooler_errors = 1
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question