Re: Libpq functions & string to obtain connection parameters - Mailing list pgsql-general

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@aklaver.com