Re: What are best practices wrt passwords?

Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>

From: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
To: pgsql-general@lists.postgresql.org
Date: 2024-10-16T18:29:20Z
Lists: pgsql-general
Στις 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
>
>