Re: Libpq functions & string to obtain connection parameters

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(dot)klaver(at)aklaver(dot)com