Hello,
on CentOS 6.4 I'm moving from 8.4 to 9.3, but can not find the file /var/lib/pgsql/9.3/data/global/pg_auth which I need for the pg_bouncer.
Does anybody please know where to find that file?
My packages:
postgresql93-9.3.1-1PGDG.rhel6.x86_64
pgdg-centos93-9.3-1.noarch
postgresql93-libs-9.3.1-1PGDG.rhel6.x86_64
postgresql93-server-9.3.1-1PGDG.rhel6.x86_64
My /etc/pgbouncer/pgbouncer.ini:
[databases]
balkan = host=/tmp user=XXX password=XXX dbname=balkan
bukvy = host=/tmp user=XXX password=XXX dbname=bukvy
[pgbouncer]
logfile = /var/log/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
listen_port = 6432
unix_socket_dir = /tmp
auth_type = md5
auth_file = /var/lib/pgsql/9.3/data/global/pg_auth
pool_mode = session
server_reset_query = DISCARD ALL
server_check_delay = 10
max_client_conn = 600
default_pool_size = 50
log_connections = 0
log_disconnections = 0
log_pooler_errors = 1
admin_users = postgres
My /var/lib/pgsql/9.3/data/pg_hba.conf:
The psql connection w/o pgbouncer works well.
Thank you
Alex