Re: Installing Postgresql on Linux Friendlyarm

[Abelard Hoffman <abelardhoffman@xxxxxxxxx>]

On Mon, Sep 22, 2014 at 7:39 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Xiang Gan <XiangGan@xxxxxxxxxxxxxx> writes:
> OK. So a stupid question, whether there is any possibility to run Postgresql as root? (I know this is forbidden generally. But what I find out is that in Linux FriendlyArm environment, root could create socket while non-root user does not have such privilege)

Typically, applications open the port as root and then change to low privilege for the actual service.

See also this thread:

http://stackoverflow.com/questions/413807/is-there-a-way-for-non-root-processes-to-bind-to-privileged-ports-1024-on-l