public inbox for pgsql-novice@postgresql.org  

help / color / mirror / Atom feed

From: Tom Lane <tgl@sss.pgh.pa.us>
To: chris <psql-contact@citecs.de>
Cc: Subramanian, Ramachandran <ramachandran.subramanian@alte-leipziger.de>
Cc: pgsql-novice@lists.postgresql.org <pgsql-novice@lists.postgresql.org>
Subject: Re: How to check completeness of installation
Date: Thu, 19 Feb 2026 09:54:15 -0500
Message-ID: <2398804.1771512855@sss.pgh.pa.us> (raw)
In-Reply-To: <20260219094404.GA1707@app.citecs>
References: <628793fdc61e42df9b1cd945e2141a4d@alte-leipziger.de>
	<20260219094404.GA1707@app.citecs>

chris <psql-contact@citecs.de> writes:
> On Thu, Feb 19, 2026 at 08:59:29AM +0000, Subramanian,Ramachandran wrote:
>> 2.  Is there any way with which we can install Postgress WITHOUT ROOT privileges.

> You really should not do this, for several reasons.

Why not?  People do that all the time if they are building from
source:

https://www.postgresql.org/docs/current/installation.html

I will grant that there's some security advantage to installing the
executables under an ownership account that's different from the
one used to run the server.  But it doesn't follow that the owning
account has to be root.

			regards, tom lane

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-novice@postgresql.org
  Cc: tgl@sss.pgh.pa.us, psql-contact@citecs.de, ramachandran.subramanian@alte-leipziger.de, pgsql-novice@lists.postgresql.org
  Subject: Re: How to check completeness of installation
  In-Reply-To: <2398804.1771512855@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox