Re: Libpq functions & string to obtain connection parameters

On 10/07/2016 07:58 AM, arnaud gaboury wrote:
>
>

>
> GGGrrrhhhhh
>
> -------------------------------
> # systemctl restart postgresql
> # su mattermost
> bash-4.3$ psql postgresql://mmuser:XXXYYYY@/mattermost?
> psql (9.5.4)
> Type "help" for help.
>
> mattermost=> \q
> -----------------------------------------
>
> OK. Now I know unix user mattermost can connect to mattermost Db via
> unix socket. BUT when trying to write this in my URI:
>
> postgresql://mmuser:MyPwd@/mattermost?connect_timeout=10

So what app/framework/code is processing the above?

>
> I get this from my app :
> Failed to ping db err:pq: SSL is not enabled on the server

That does not look like something coming from Postgres, but from
whatever is initiating the connection.

>
> Is it normal to still have this error ? Adding sslmode param will not
> change anything as it is ignored for Unix domain socket communication.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com