Re: Libpq functions & string to obtain connection parameters

[arnaud gaboury <arnaud.gaboury@xxxxxxxxx>]

On Fri, Oct 7, 2016 at 3:56 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxx