Re: pg_ctl and port number detection - Mailing list pgsql-hackers

From Florian Pflug
Subject Re: pg_ctl and port number detection
Date
Msg-id 6BD573B4-2DB4-4C15-A75C-75BD151B8FE3@phlo.org
Whole thread Raw
In response to Re: pg_ctl and port number detection  (Bruce Momjian <bruce@momjian.us>)
Responses Re: pg_ctl and port number detection  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
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.

best regards,
Florian Pflug


pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: serializable lock consistency
Next
From: Tomas Vondra
Date:
Subject: Re: keeping a timestamp of the last stats reset (for a db, table and function)