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

From: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth
Date: 2013-11-13 11:43:23
Message-ID: 1384343003.9994.27.camel@lenovo01-laptop03.gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

On Wed, 2013-11-13 at 12:28 +0100, Alexander Farber wrote:
> 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?

It was removed about 4 years before. You can use mkauth.py to generate
the auth file. Here is a blog post about how to do it:

http://www.depesz.com/2010/12/04/auto-refreshing-password-file-for-pgbouncer/

Regards,

--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2013-11-13 11:58:36 Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth
Previous Message Alexander Farber 2013-11-13 11:28:49 Can't find /var/lib/pgsql/9.3/data/global/pg_auth