Re: ident auth does not works as usual

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: ident auth does not works as usual
Дата
Msg-id CAKFQuwa4WC6LUXwRxxAkxAyqPOeLhxKBQfDkeUBxgkDZi++urw@mail.gmail.com
обсуждение исходный текст
Ответ на 回复: ident auth does not works as usual  (pan snowave <windxp@live.cn>)
Ответы 回复: ident auth does not works as usual
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Joseph Kennedy
Дата:
Сообщение: Re: PostgreSQL 12 reindex
Следующее
От: Mike Roest
Дата:
Сообщение: pg_visible_in_snapshot clarification