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

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth
Дата
Msg-id CAADeyWjtcU7JbTRvXo0iQMdS2GAPRV=D5HTC7bu2rfe3i_OeUw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Ответы Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Список pgsql-general
Дерево обсуждения
Thank you Devrim!

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)

Regards
Alex


On Wed, Nov 13, 2013 at 12:43 PM, Devrim GÜNDÜZ <devrim@gunduz.org> wrote:
On Wed, 2013-11-13 at 12:28 +0100, Alexander Farber wrote:
> 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/

В списке pgsql-general по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth
Следующее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Can't find /var/lib/pgsql/9.3/data/global/pg_auth