Re: Installing Postgresql on Linux Friendlyarm

From: Abelard Hoffman <abelardhoffman(at)gmail(dot)com>
To:
Cc: Xiang Gan <XiangGan(at)santaitech(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Installing Postgresql on Linux Friendlyarm
Date: 2014-09-23 06:29:06
Message-ID: CACEJHMh4E_HMAa8rZhB3Crt0M92WKVd0duYneb+AV6OG=OMRUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 22, 2014 at 7:39 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Xiang Gan <XiangGan(at)santaitech(dot)com> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2014-09-23 06:56:28 Re: ALTER TEXT field to VARCHAR(1024)
Previous Message Sameer Kumar 2014-09-23 05:24:40 wide row insert via Postgres jdbc driver