Re: Libpq functions & string to obtain connection parameters

Adrian Klaver <adrian.klaver@xxxxxxxxxxx> · Fri, 7 Oct 2016 06:48:43 -0700

On 10/07/2016 06:42 AM, arnaud gaboury wrote:

    does that help?

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

Something like:

psql postgresql:///test?connect_timeout=10

From ps:

4228 pts/1    S+     0:00 psql postgresql:///test?connect_timeout=10
4229 ?        Ss     0:00 postgres: aklaver test [local] idle

[0]https://www.postgresql.org/docs/9.5/static/libpq-connect.html

    (Copy&Paste from
    http://stackoverflow.com/questions/27037990/connecting-to-postgres-via-database-url-and-unix-socket-in-rails)

    Regards, Andreas Kretschmer
    --
    Andreas Kretschmer
    http://www.2ndQuadrant.com/
    PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general