Re: pg_primary_conninfo

Поиск
Список
Период
Сортировка
Искать
От
Gurjeet Singh
Тема
Re: pg_primary_conninfo
Дата
Msg-id
AANLkTimz7Y32SfkKKb-zWGytsuXPyv4NYyf0oEKTLFAK@mail.gmail.com
Ответ на
Список
Дерево обсуждения
pg_primary_conninfo Magnus Hagander <magnus@hagander.net>
Re: pg_primary_conninfo Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_primary_conninfo Magnus Hagander <magnus@hagander.net>
Re: pg_primary_conninfo Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_primary_conninfo Guillaume Lelarge <guillaume@lelarge.info>
Re: pg_primary_conninfo Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_primary_conninfo Guillaume Lelarge <guillaume@lelarge.info>
Re: pg_primary_conninfo Magnus Hagander <magnus@hagander.net>
Re: pg_primary_conninfo Gurjeet Singh <singh.gurjeet@gmail.com>
Re: pg_primary_conninfo Guillaume Lelarge <guillaume@lelarge.info>
Re: pg_primary_conninfo Robert Haas <robertmhaas@gmail.com>
Re: pg_primary_conninfo Guillaume Lelarge <guillaume@lelarge.info>
Re: pg_primary_conninfo Magnus Hagander <magnus@hagander.net>
Re: pg_primary_conninfo Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: pg_primary_conninfo Fujii Masao <masao.fujii@gmail.com>
Re: pg_primary_conninfo Robert Haas <robertmhaas@gmail.com>
Re: pg_primary_conninfo Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: pg_primary_conninfo Gurjeet Singh <singh.gurjeet@gmail.com>
Re: pg_primary_conninfo Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_primary_conninfo Guillaume Lelarge <guillaume@lelarge.info>
Re: pg_primary_conninfo Gurjeet Singh <singh.gurjeet@gmail.com>
Re: pg_primary_conninfo Robert Haas <robertmhaas@gmail.com>
Re: pg_primary_conninfo Magnus Hagander <magnus@hagander.net>
On Tue, Dec 28, 2010 at 11:36 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

I can see the point of, say, a primary_host_address() function returning
inet, which would be way better on both those dimensions than the
current proposal.  But I'm not sure what else would be needed.


+1, since it bypasses security risks associated with exposing username/password.

Ability to see port number will be a useful addition.

Another case to consider is what if slave is connected to a local server over unix-domain sockets? Returning NULL might make it ambiguous with the case where the instance has been promoted out of standby.

Regards,
--
gurjeet.singh
@ EnterpriseDB - The Enterprise Postgres Company
http://www.EnterpriseDB.com

singh.gurjeet@{ gmail | yahoo }.com
Twitter/Skype: singh_gurjeet

Mail sent from my BlackLaptop device
В списке pgsql-hackers по дате отправления
От: Guillaume Lelarge
Дата:
Сообщение: Re: pg_primary_conninfo
От: Tom Lane
Дата:
Сообщение: Re: pg_dump --split patch
FAQ