From: Tom Lane <tgl@sss.pgh.pa.us>
To: chris <psql-contact@citecs.de>
cc: "Subramanian,
    Ramachandran" <ramachandran.subramanian@alte-leipziger.de>,
        "pgsql-novice@lists.postgresql.org"
 <pgsql-novice@lists.postgresql.org>
Subject: Re: How to check completeness of installation
In-reply-to: <20260219094404.GA1707@app.citecs>
References: <628793fdc61e42df9b1cd945e2141a4d@alte-leipziger.de>
 <20260219094404.GA1707@app.citecs>
Comments: In-reply-to chris <psql-contact@citecs.de>
	message dated "Thu, 19 Feb 2026 10:44:04 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2398803.1771512855.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 19 Feb 2026 09:54:15 -0500
Message-ID: <2398804.1771512855@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2398804.1771512855%40sss.pgh.pa.us>
Precedence: bulk

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 p=
rivileges.

> 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