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 12:07:04
Message-ID: 1384344424.9994.33.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:58 +0100, Alexander Farber wrote:

> The "man 5 pgbouncer" is slightly outdated then,
> it doesn't explain the auth_file format in detail:
>
> auth_file
> The name of the file to load user names and passwords from. The
> file format is the same as the PostgreSQL
> pg_auth/pg_pwd file, so this setting can be pointed directly to
> one of those backend files.
>
> What is the 3rd column of the file used for?
> (the 1st being username and
> the 2nd being md5 hashed password)

There are two columns actually -- pgbouncer ignores the rest:

http://pgbouncer.projects.pgfoundry.org/doc/config.html#_authentication_file_format

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

Browse pgsql-general by date

  From Date Subject
Next Message Gabriel Sánchez-Martínez 2013-11-13 12:45:23 Re: Partitioned table question
Previous Message Alexander Farber 2013-11-13 11:58:36 Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth