Re: pg_ctl and port number detection

Поиск
Список
Период
Сортировка
От Florian Pflug
Тема Re: pg_ctl and port number detection
Дата
Msg-id B9FF11C0-6DFA-409B-AE5D-91D78C651B47@phlo.org
обсуждение исходный текст
Ответ на Re: pg_ctl and port number detection  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-hackers
On Dec19, 2010, at 21:10 , Magnus Hagander wrote:
> On Sun, Dec 19, 2010 at 20:16, Florian Pflug <fgp@phlo.org> wrote:
>> On Dec19, 2010, at 00:54 , Bruce Momjian wrote:
>>> I wonder if we should write the port number as the 4th line in
>>> postmaster.pid and return in a few major releases and use that.  We
>>> could fall back and use our existing code if there is no 4th line.
>> 
>> What if the postmaster instead created a second unix socket in its
>> data directory? For security reason, it'd probably need to set
>> the permissions to 0600, but it'd still allow maintenance tools to
>> connect reliably if they only knew the data directory.
>> 
>> Don't know if that'd work on windows, though - I have no idea if
>> we even support something similar to unix sockets there, and if so,
>> it it lives in the filesystem.
> 
> We don't, and AFAIK there's nothing that lives in the filesystem. You
> have named pipes that live in the namespace, but not within
> directories in the filesystem.


Hm, OK, that pretty much kills the idea. Having to special-case
windows seems less appealing than the other options.

best regards,
Florian Pflug



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

Предыдущее
От: Itagaki Takahiro
Дата:
Сообщение: Re: Extensions, patch v20 (bitrot fixes)
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: keeping a timestamp of the last stats reset (for a db, table and function)