Re: Notes on implementing URI syntax for libpq

Поиск
Список
Период
Сортировка
От Dmitriy Igrishin
Тема Re: Notes on implementing URI syntax for libpq
Дата
Msg-id CAAfz9KM-vqLu5q5pUN2Xh2XEBnCpzostGV_Mf1EKxSrW9BrXqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Notes on implementing URI syntax for libpq  (Alexander Shulgin <ash@commandprompt.com>)
Список pgsql-hackers


2011/11/24 Alexander Shulgin <ash@commandprompt.com>

Excerpts from Dmitriy Igrishin's message of Thu Nov 24 09:19:02 +0200 2011:
>
> > If host part of the URI points to localhost, the UNIX domain socket would
> > be considered by libpq just as if you would pass "-h localhost -p 5433".
> >
> But what if the user wants to connect exactly via socket or
> TCP/IP ?
> And what if the user needs to specify a socket file name extension?

How do you achieve that with the current psql set of command line options (and, possibly environment variables?)
For psql(1) see -h option and -p option
http://www.postgresql.org/docs/9.1/static/app-psql.html
For the libpq see host option and port option of PQconnectdbparams()
http://www.postgresql.org/docs/9.1/static/libpq-connect.html
In both cases:
If the value of host begins with a slash, it is used as the directory for the Unix-domain socket.
Port specifies the TCP port or the local Unix-domain socket file extension.

I would think the same method will work with URI, as with the proposed approach the URI is just decomposed into host, port and dbname parts and the rest of the code works like if you've had specified "-h example.net -p 5433 -d mydb" instead of the URI parameter.
Thats great, but see above.



--
// Dmitriy.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Notes on implementing URI syntax for libpq
Следующее
От: Jan Urbański
Дата:
Сообщение: Re: PL/Python SQL error code pass-through