Message-ID: <e5adbf63-1872-40b1-9e64-fbf39f4be428@cloud.gatewaynet.com>
Date: Wed, 16 Oct 2024 21:29:20 +0300
MIME-Version: 1.0
Subject: Re: What are best practices wrt passwords?
To: pgsql-general@lists.postgresql.org
References: <87o73kgzkd.fsf@mbork.pl>
 <CAFCRh-8dM4bLGTKcv1v5wC9guhY_b5G=6w-ivHM4UJGwMUyWaA@mail.gmail.com>
 <87frowggzq.fsf@mbork.pl> <Zw_qvUHTC98XcGa6@momjian.us>
 <186766.1729097245@sss.pgh.pa.us>
Content-Language: en-US
From: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
In-Reply-To: <186766.1729097245@sss.pgh.pa.us>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/e5adbf63-1872-40b1-9e64-fbf39f4be428%40cloud.gatewaynet.com>
Precedence: bulk


Στις 16/10/24 19:47, ο/η Tom Lane έγραψε:
> Bruce Momjian <bruce@momjian.us> writes:
>> On Wed, Oct 16, 2024 at 06:16:57PM +0200, mbork@mbork.pl wrote:
>>> `ps auxe` shows all processes with their environments, no?
>> I think that only shows for super-user.
> I believe it depends on your platform --- some BSDen are pretty
> permissive about this, if memory serves.  On a Linux box it seems


As of FreeBSD smadevnu 14.1-RELEASE-p5 , only the user and root can view 
the env, such as PGPASSWORD of a user. Other users can't.


> to work for processes owned by yourself even if you're not superuser.
>
> 			regards, tom lane
>
>