Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1t193H-00Ev2X-GG
	for pgsql-general@arkaria.postgresql.org; Wed, 16 Oct 2024 18:47:19 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1t193F-008CTm-FP
	for pgsql-general@arkaria.postgresql.org; Wed, 16 Oct 2024 18:47:17 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1t193F-008CTd-4Z
	for pgsql-general@lists.postgresql.org; Wed, 16 Oct 2024 18:47:17 +0000
Received: from sss.pgh.pa.us ([68.162.161.243])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1t193D-001P0o-BR
	for pgsql-general@lists.postgresql.org; Wed, 16 Oct 2024 18:47:16 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 49GIl5wx208346;
	Wed, 16 Oct 2024 14:47:05 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
cc: pgsql-general@lists.postgresql.org
Subject: Re: What are best practices wrt passwords?
In-reply-to: <e5adbf63-1872-40b1-9e64-fbf39f4be428@cloud.gatewaynet.com>
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> <e5adbf63-1872-40b1-9e64-fbf39f4be428@cloud.gatewaynet.com>
Comments: In-reply-to Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com>
	message dated "Wed, 16 Oct 2024 21:29:20 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <208344.1729104425.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Wed, 16 Oct 2024 14:47:05 -0400
Message-ID: <208345.1729104425@sss.pgh.pa.us>
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/208345.1729104425%40sss.pgh.pa.us>
Precedence: bulk

Achilleas Mantzios <a.mantzios@cloud.gatewaynet.com> writes:
> Στις 16/10/24 19:47, ο/η Tom Lane έγραψε:
>> 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.

NetBSD 10 seems to behave the same.  I don't have a recent OpenBSD
installation to try.

			regards, tom lane