Can't find /var/lib/pgsql/9.3/data/global/pg_auth - Mailing list pgsql-general

From Alexander Farber
Subject Can't find /var/lib/pgsql/9.3/data/global/pg_auth
Date
Msg-id CAADeyWjJ07B-xyATsuJzy3M8ADD2cEc6_a5UXvtLxSBPXWEdgg@mail.gmail.com
Whole thread Raw
Responses Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth
List pgsql-general
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:

local   all   all    md5

The psql connection w/o pgbouncer works well.

Thank you
Alex

pgsql-general by date:

Previous
From: Torsten Förtsch
Date:
Subject: Partitioned table question
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth