Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lOOrw-0006iE-P1 for pgsql-admin@arkaria.postgresql.org; Mon, 22 Mar 2021 18:01:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lOOrv-0003xX-NN for pgsql-admin@arkaria.postgresql.org; Mon, 22 Mar 2021 18:01:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lOOrv-0003xP-GA for pgsql-admin@lists.postgresql.org; Mon, 22 Mar 2021 18:01:35 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lOOrt-00028J-CD for pgsql-admin@lists.postgresql.org; Mon, 22 Mar 2021 18:01:34 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id 1F11D9F824; Mon, 22 Mar 2021 18:01:30 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at emo05-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo05-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 9l-cPPr46o8J; Mon, 22 Mar 2021 18:01:30 +0000 (UTC) Received: from [10.190.31.10] (unknown [164.111.83.67]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 5AC5D9F8E0; Mon, 22 Mar 2021 18:01:27 +0000 (UTC) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.60.0.2.21\)) Subject: Re: Where are password hashes stored? From: Scott Ribe In-Reply-To: Date: Mon, 22 Mar 2021 12:01:27 -0600 Cc: Pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: <609F9D36-3AF6-492D-98A0-1DD5BAD278CF@elevated-dev.com> References: To: Ron X-Mailer: Apple Mail (2.3654.60.0.2.21) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Mar 22, 2021, at 11:59 AM, Ron wrote: >=20 > This is v9.6, if it matters. >=20 > I need to send a screenshot of roles and their password hashes, but I = can't seem to find the relevant table, and Google only shows pages about = .pgpass and crypto. >=20 > Thanks. select * from pg_shadow;