Re: Libpq functions & string to obtain connection parameters

Поиск
Список
Период
Сортировка
От arnaud gaboury
Тема Re: Libpq functions & string to obtain connection parameters
Дата
Msg-id CAK1hC9vMYkDYv5VK8fHmHDCJADA6d-h5HQVwAL31jk4WsmQexw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Libpq functions & string to obtain connection parameters  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: Libpq functions & string to obtain connection parameters  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения


On Fri, Oct 7, 2016 at 3:56 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 10/07/2016 06:42 AM, arnaud gaboury wrote:
>
>

>
> Honestly not so much, as it is a nearly perfect Copy/past of postgresql
> official doc[0].
> My postgresql socket is in the usual place:
>  /run/postgresql/.s.PGSQL.5432=
> So no need to specify it. But for the rest, I am still not sure of my URI
>
> [0]https://www.postgresql.org/docs/9.5/static/libpq-connect.html
>
>

Aah, just remembered you wanted username and password, so:

psql postgresql://aklaver:pwd@/test?connect_timeout=10

It helps, but I must have something else misconfigured then:

-------------------------------------
 # su postgres
postgres@thetradinghall ➤➤ mattermost/bin % bash
bash-4.3$ psql postgresql:///mattermost?connect_timeout=10
psql (9.5.4)
Type "help" for help.

mattermost=# \q
=====> OK
-----------------------------------------
Now with the Unix user I want to use:

--------------------------------------------------------
% su mattermost
bash-4.3$ psql postgresql:///mattermost?connect_timeout=10
psql: FATAL:  no pg_hba.conf entry for host "[local]", user "mattermost", database "mattermost", SSL off
--------------------------------------------

As a reminder, I made an entry in pg_ident.conf this way:
 mattermap      mattermost              mmuser

and add this line in pg_hba.conf
local   mattermost          mmuser                      peer       map=mattermap

What is wromg in my  UNIX/postgresql user mapping?




4408 pts/1    S+     0:00 psql postgresql://aklaver:pwd@/test?connect_timeout=10
4409 ?        Ss     0:00 postgres: aklaver test [local] idle


--
Adrian Klaver
adrian.klaver@aklaver.com

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Libpq functions & string to obtain connection parameters
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Libpq functions & string to obtain connection parameters