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 ) id 1uM5xa-002ScJ-FF for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Jun 2025 14:16:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uM5xZ-00AKZj-5o for pgsql-hackers@arkaria.postgresql.org; Mon, 02 Jun 2025 14:16: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 ) id 1uM5xY-00AKZa-Sn for pgsql-hackers@lists.postgresql.org; Mon, 02 Jun 2025 14:16:16 +0000 Received: from mail-pj1-x102e.google.com ([2607:f8b0:4864:20::102e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uM5xV-0002xN-2D for pgsql-hackers@postgresql.org; Mon, 02 Jun 2025 14:16:16 +0000 Received: by mail-pj1-x102e.google.com with SMTP id 98e67ed59e1d1-312b0d83a10so894891a91.0 for ; Mon, 02 Jun 2025 07:16:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1748873772; x=1749478572; darn=postgresql.org; h=content-disposition:mime-version:message-id:subject:to:from:date :from:to:cc:subject:date:message-id:reply-to; bh=c5JyX7Jxp65yGva4umLQ73hpzRxiGdurTn/9B27GG1Y=; b=Ae3P2z0kQfoTUQpucueezV1FTY/8HkeOD4G824JAaEF13Gl0CLBhAoBK+j9ZBMKKok jEUyC0N/Iw0ENlYX/xmGPhdjVonPMj0LeqxIJKWqu+XOh5LQJv6sNdMX1z4Duu/RwtP0 GX1DsnWmucsVgERMteLgvlpzP9r2O96AdGa7l8qn6RWsZY5Ytm8FBFSeG3Drut8WxjWM 2rwgV20801/ux0c/hPu+Rawd9y2xeIeXXGlPMuKdDIO1hnZafgO5l7Y+fCjLCNu/4Ozz SM2SlxEGF0MrQW8qOOWZi9y16rf09MfQ8Xrcg4VpkzuKE3T9JbpSv+kQt2cqiA7LJClW gYVA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1748873772; x=1749478572; h=content-disposition:mime-version:message-id:subject:to:from:date :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=c5JyX7Jxp65yGva4umLQ73hpzRxiGdurTn/9B27GG1Y=; b=TqKYhx5Ns6Xlb5FtPHXoI9uv/EnBaabZhTrChV/tB1ZWEtOUZ0LK8LhXLArVb0Evoy kKGsNGNvxI0WlXmFxfUhjk+IEMJ99H4BLR+2N/XXHxOFWX2Tkh8Jndw3Vt6aPnRXE4tn d0r570x0vThGX+ptYtdaUGriaz46nUt4e/jxH9drnx+oY5MJWFUbx5jBc9In+TLTYBSU SBydV+/B/tmjr5efIXRD2RyhTgynJcD9USHQ6TPk/V392+IbhpM4XxcMryvhrUnABrb3 Gipcj/OlABDjWE6w8ywNXwVLyWmV+PI4HYcJhl4qIkNA1yr3jD+vAb6SXdbpiKI33vSO HuTw== X-Gm-Message-State: AOJu0Yxc360zU8p5MWaDUY2yMmVLcoVtBJ8CME+Y1lUKH3HfoksZ7ln2 EexXbI9/yWajO65D+BqK7ymQj2nuLhZ/fEInUlMJo9m4fHhc9b6A0bnKo/VYbQ== X-Gm-Gg: ASbGncvo21mtcA33U36/pAhLc/Y1oS2hPmKdObrQf6eucZZBarH4jnbvRtp5WP7TesK vA4UntcbKUfbZU2zm5GLArt7wRBbyYXWbgALrjJ8jEseCo3AkteN4qv+mUFKqHHRYp0jNiFwIkc EwRJL8EUr6MjehzrqDRgS2GZvWcVZS0mj37wLhMuSa3hCVhsJGkYh0KrHIow2LzfDHeGPKhni28 r90Y1vd5idi+Ig3FyPuZGoY07LO2UudCzV+jeNta1E7j6yuCS+wmY3tr7/czp+dVTFf0p9bKBeq e6UwAfCyeoaBk855doUtIIHJPDMEnSUxZj/pvRjak8O3r2xVyKlCY2fjkGB2DH44NLmZXUXh2CA ye2p90J6cjil0SZnG8x/Ip90JfvNSYCbd/+ea8n60WQwHCGmD77Al X-Google-Smtp-Source: AGHT+IFE5goG19SsJGktnOSYgqEase67xYkKMJeGMdXT+NjU/kVIL/Ygf2KYTara1/QCHCzUJAO/yA== X-Received: by 2002:a17:90b:1d51:b0:311:a314:c2dc with SMTP id 98e67ed59e1d1-3125036bafdmr22569501a91.14.1748873772396; Mon, 02 Jun 2025 07:16:12 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-4fdd7ef6af1sm1729434173.106.2025.06.02.07.16.11 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 02 Jun 2025 07:16:12 -0700 (PDT) Date: Mon, 2 Jun 2025 09:16:10 -0500 From: Nathan Bossart To: pgsql-hackers@postgresql.org Subject: fix notes about password encryption in pg_authid docs Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk I noticed that the docs for the pg_authid catalog still indicate that passwords might be stored "unencrypted," which hasn't been possible since commit eb61136. The attached patch attempts to fix that. If acceptable, I'd back-patch it to all supported versions. -- nathan