F
F
FreeLSD2011-08-08 15:41:17
PostgreSQL
FreeLSD, 2011-08-08 15:41:17

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 question

Ask a Question

731 491 924 answers to any question