Re: What are best practices wrt passwords?

From: Achilleas Mantzios <a(dot)mantzios(at)cloud(dot)gatewaynet(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: What are best practices wrt passwords?
Date: 2024-10-16 18:29:20
Message-ID: e5adbf63-1872-40b1-9e64-fbf39f4be428@cloud.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Στις 16/10/24 19:47, ο/η Tom Lane έγραψε:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
>> On Wed, Oct 16, 2024 at 06:16:57PM +0200, mbork(at)mbork(dot)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
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-10-16 18:47:05 Re: What are best practices wrt passwords?
Previous Message Adrian Klaver 2024-10-16 18:03:10 Re: Query performance issue