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