回复: ident auth does not works as usual
| От | pan snowave |
|---|---|
| Тема | 回复: ident auth does not works as usual |
| Дата | |
| Msg-id | OS3P286MB1933DC61D588D95C768F1F2CD3FAA@OS3P286MB1933.JPNP286.PROD.OUTLOOK.COM обсуждение исходный текст |
| Ответ на | Re: ident auth does not works as usual ("David G. Johnston" <david.g.johnston@gmail.com>) |
| Список | pgsql-general |
HI
I've got the right meanng of pg_hba.conf and pg_ident.conf.
My previous understanding was incorrect. I thought pgserver would automatically handle the conversion between OS users and PostgreSQL roles.
Thanks all.
发件人: David G. Johnston <david.g.johnston@gmail.com>
发送时间: 2023年8月28日 14:44
收件人: pan snowave <windxp@live.cn>
抄送: Alban Hertroys <haramrae@gmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
主题: Re: ident auth does not works as usual
发送时间: 2023年8月28日 14:44
收件人: pan snowave <windxp@live.cn>
抄送: Alban Hertroys <haramrae@gmail.com>; pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
主题: Re: ident auth does not works as usual
On Mon, Aug 28, 2023 at 7:34 AM pan snowave <windxp@live.cn> wrote:
But when i connect to psserver by using os user root/usr/local/pgsql/bin/psql -p5432 -d db1 -h127.0.0.1
If you want to login as the cce role add " -U cce " to your command line (or one of the various other ways you can specify a db role name via the cli or libpq)
psql -U cce -h 127.0.0.1 -d db1
Keep in mind you could very well have two lines in your pg_ident.conf file:
test root cce
test root ddf
David J.
В списке pgsql-general по дате отправления: