Can't find /var/lib/pgsql/9.3/data/global/pg_auth

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Can't find /var/lib/pgsql/9.3/data/global/pg_auth
Date: 2013-11-13 11:28:49
Message-ID: CAADeyWjJ07B-xyATsuJzy3M8ADD2cEc6_a5UXvtLxSBPXWEdgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GÜNDÜZ 2013-11-13 11:43:23 Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth
Previous Message Torsten Förtsch 2013-11-13 11:22:27 Partitioned table question