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.96)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1vLM7J-00DgxC-2t
	for pgsql-admin@arkaria.postgresql.org;
	Tue, 18 Nov 2025 13:51:33 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1vLM7I-0069qU-0W
	for pgsql-admin@arkaria.postgresql.org;
	Tue, 18 Nov 2025 13:51:32 +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.96)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1vLM7H-0069qH-2Z
	for pgsql-admin@lists.postgresql.org;
	Tue, 18 Nov 2025 13:51:32 +0000
Received: from mail-oo1-xc30.google.com ([2607:f8b0:4864:20::c30])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1vLM7G-000BMV-0c
	for pgsql-admin@lists.postgresql.org;
	Tue, 18 Nov 2025 13:51:31 +0000
Received: by mail-oo1-xc30.google.com with SMTP id
 006d021491bc7-6542eb6dae0so2318186eaf.3
        for <pgsql-admin@lists.postgresql.org>;
 Tue, 18 Nov 2025 05:51:29 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1763473886; x=1764078686;
 darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:references:in-reply-to
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=Vq8R5fVrCWWsxPITJFpGsqhGs2X2RHGvi5ruwna9ENs=;
        b=nR3tsvkKbm6Bxfz+iwjZpZo++8+9i018abmzpr8JoL8uQDzzMex1MNPqQeRGfbFz5v
         mslmAtTO6OACwVejylwhtTDIxctOsYGm0h5d2fLjWaTvHlsfMRu32Z77FtXA9rXNN3uQ
         L+na5zOPIjjRnbFZaN67kkaQYiTCwqU1JFLn04d8io6WVbHCtsUCzW3NKziGSeW9Eipa
         nr4Y7+t8PJboir3VkXP7ZtvsrC7jpu2BuDgi1dg0jHuSqyd4JTGC8t2mibOYlLXgBtaa
         3422KVU05NVJbRVmJ3KM3mPFMFQl2dce+c3gEi6PNzYpMDAdosS9Qp02zVLuJ4JT680y
         iToA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1763473886; x=1764078686;
        h=cc:to:subject:message-id:date:from:references:in-reply-to
         :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date
         :message-id:reply-to;
        bh=Vq8R5fVrCWWsxPITJFpGsqhGs2X2RHGvi5ruwna9ENs=;
        b=mfaSw2qwby4cmLE8PbscwOMZU6GshwtRA+NbsDrOa0BkQ/Lyw0y2U/NSUHOQIBbdSS
         ttxq4A89zmMGFKSIdvuVjviBZfKXjccJ2vD+4DHkqk4B+iE3Wa8vyYNFBef1ci3GOrpI
         FK6vKOgQIAqG3N/V4asagueEZRyoiXGBKu7ec72QX/8qE2Foze9Ul6Mo5Ckya5bJUl9J
         4ShfWmX/064Mh1fCeSVtyPhO7TZQ7IKlXFcyLRtRV29r36VC/E57RiEdMEfwX9hHqdEX
         drOyH2UTUaK+txEHT/0085XJlDjhDtCsEGxbfdYinWJ6nMbu/TiOkwktJfdlIRm4ZgDr
         z/AA==
X-Gm-Message-State: AOJu0YyAb4uqTtJSFTf72MCg00k10lpz2KvIyZvBII05FaiHfvNqq9FS
	9V4ztNkKpU8b72cGB89FwjHzz2l+bCoj/7v3dMwbmzB3Wpy21SfByDuVNp64dKNkkHgfJSMZ+SR
	wVfL8dsY1Wfh1qDbTCF+GQDv/VVTJlak=
X-Gm-Gg: ASbGncvqENK0zBe6pdcgi4q7vgmRIOKgmgbQ2Ne91EnX7ZObr180DAaZISJqKqae2U5
	ixMzFHdVzwdb1cDfQBNXQIPXu8jis4B/wCoBJflBBin37EujsYDvYBMus6nUs04P2QwZfMl7AyX
	NetWRL4Ux/830KzXIrFmakxj/LG4uCWrbLk8v+sfpBEwQu2iEgMnMlfGOMV4cddbokjrSV66BH2
	rwi11AUJ1pGrsB0RLUpdZ5G3B61ZnQkgfFBkYB1zvS2vWHcJCMkMya0ovA=
X-Google-Smtp-Source: 
 AGHT+IEF5ZcL+T7QEGYAVSX87uYhMgJbfTLJJjrtwjB+HqL+ztZh8PhXqZ3hwLvWo7haW3KvldwTVu1fxsV1C0agHSk=
X-Received: by 2002:a05:6820:c8f:b0:657:4f2:97b2 with SMTP id
 006d021491bc7-65733b40056mr6955808eaf.0.1763473886576; Tue, 18 Nov 2025
 05:51:26 -0800 (PST)
MIME-Version: 1.0
Received: by 2002:a05:6802:6051:20b0:605:7105:9e6e with HTTP; Tue, 18 Nov 2025
 05:51:25 -0800 (PST)
In-Reply-To: 
 <CAMdfv4U7VhoyfpK2C2oQD-EZsoCGvwWXzfm+BVF3rktDhnC=HQ@mail.gmail.com>
References: 
 <CAMdfv4U7VhoyfpK2C2oQD-EZsoCGvwWXzfm+BVF3rktDhnC=HQ@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Tue, 18 Nov 2025 07:51:25 -0600
X-Gm-Features: AWmQ_bnupf33HCkhJ31bBD_imLBxHfgXt7FDxOcilr_wrrL7wpXf_gaqFU9ISf0
Message-ID: 
 <CAKFQuwZS_kfLXPi7d0BztS2m9CqMpu_xVtZ2NW=Qt+VRLc1RFQ@mail.gmail.com>
Subject: Re: Hide psql passwords
To: Mauricio Fernandez <mmauricio.fernandez@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000009486cb0643dec2d4"
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZS_kfLXPi7d0BztS2m9CqMpu_xVtZ2NW%3DQt%2BVRLc1RFQ%40mail.gmail.com>
Precedence: bulk

--0000000000009486cb0643dec2d4
Content-Type: text/plain; charset="UTF-8"

On Tuesday, November 18, 2025, Mauricio Fernandez <
mmauricio.fernandez@gmail.com> wrote:

> Hi admins, I'm wondering if there is any other way the password in a psql
> session besides .pgpass file??
>

That, or an environment variable.

David J.

--0000000000009486cb0643dec2d4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tuesday, November 18, 2025, Mauricio Fernandez &lt;<a href=3D"mailto:mma=
uricio.fernandez@gmail.com">mmauricio.fernandez@gmail.com</a>&gt; wrote:<br=
><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1=
px #ccc solid;padding-left:1ex"><div dir=3D"ltr">Hi admins, I&#39;m wonderi=
ng if there is any other way the password in a psql session besides .pgpass=
 file??</div></blockquote><div><br></div><div>That, or an environment varia=
ble.</div><div><br></div><div>David J.</div><div><br></div>

--0000000000009486cb0643dec2d4--